how to connect ORACLE database through ODBC?
Well it was just for experience. i surely learned a lot of things while
doing it. Actually i was making it for my friend who had Oracle 7.x and
had difficulties in exp/imp. I am aware that Oracle 8.0 can anytime do
better than what i could have done and also that you are not a salesman
of Oracle. But i am still eager to find out HOW to ACCESS SYNONYMS.
Anyway thanks a lot for a reply.
still if you know ths solution please mail asap.
Purav
Quote:
> it is neither a solution nor relating to VB.
> But the Oracle Nevigator 8.0 in Personal Oracle 8.0 can do the same
thing
> and it has a lot of good features.
> I am not salesman of Oracle
Quote:
> > Hi,
> > Don't worry. I will mail solution to you within few days. its very
> > easy. I had a lot of Problems when i was working with it but
actually
> > its simple.
> > I was making a Oracle export manager in Vb. Normally you export
Oracle
> > tables through the file exp.exe in the orawin/bin directory. I
wanted
> > to make thru GUI so that you dont have to remember all the tables if
> > you are exporting the tables. for that i was connecting to oracle
thru
> > the user specified and show the tables belonging to that user in a
> > listbox for him to choose. But to display all the tables you have to
> > use the synonym called as TAB in oracle. Thru VB it gave me an
error:
> > public.tab doesnot exist though tab is public and can be used by
> > anyone. since then i am unable to find out the problem and my dream
of
> > making a Oracle export manager has become MISSION INCOMPLETE. Do you
> > have any idea of accesing synonyms thru VB. Can you please try.
> > Connecting to Oracle , DO NOT WORRy I will definetly help you.
> > Please mail back.
> > Purav
> > > I am using VB 4.0 for win95. How to connect ORACLE7.3 database
> > through
> > > ODBC?
> > > What are the setting in ODBC?
> > > My example is :
> > > 1. Create new data source from ODBC and select driver - Oracle
ODBC
> > > Driver
> > > for Rdb.
> > > 2. Data Source Name - ABC
> > > Description - Abc database
> > > 3. Data Source
> > > Server: servername
> > > Class: generic
> > > User ID: abc
> > > Attach Statement:
> > > 4. Database Option
> > > Transport: 2=tcp/ip
> > > DBI Option: 0
> > > 5. Translation Options
> > > Option: 0
> > > Library:
> > > 6. In the VB application :
> > > SET myworkspace = DBEngine.Workspaces(0)
> > > SET mydatabase = myworkspace.OpenDatabase("ABC", FALSE, FALSE,
> > > "ODBC; uid=abc;
pwd=abc;")
> > > I got an error, it can open Oracle database.
> > > Thank you for your help.
> > Sent via Deja.com http://www.deja.com/
> > Share what you know. Learn what you don't.
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
