OraFAQ Forum: Forms » Connection to Remote Oracle Databse using ODBC in VB

Home » Developer & Programmer » Forms » Connection to Remote Oracle Databse using ODBC in VB

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Connection to Remote Oracle Databse using ODBC in VB [message #122718]

Wed, 08 June 2005 04:00

mehulp
Messages: 2
Registered: June 2005

Junior Member

Hi,

Is it possible to connect a remote oracle database using ODBC from VB.

Is it necessary to install oracle on a computer running VB application?

Please help me in solving this problem.

Thanks in advance.

Report message to a moderator

Re: Connection to Remote Oracle Databse using ODBC in VB [message #123540 is a reply to message #122718]

Mon, 13 June 2005 22:00

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Yes you can connect to an Oracle database via ODBC.

To which version of Oracle database are you trying to connect?

David

Report message to a moderator

Re: Connection to Remote Oracle Databse using ODBC in VB [message #123617 is a reply to message #123540]

Tue, 14 June 2005 03:07

mehulp
Messages: 2
Registered: June 2005

Junior Member

Martin,

My oracle version is 8i.

And I want to globally access this database from different location from my VBA application. I don't want to install oracle client each & every place. is it possible & if yes then please guide me.

Thanks,
MEHUL

Report message to a moderator

Re: Connection to Remote Oracle Databse using ODBC in VB [message #123801 is a reply to message #123617]

Tue, 14 June 2005 20:13

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Go to http://www.oracle.com/technology/software/tech/windows/odbc/index.html. This lists the various ODBC drivers for the various versions of Oracle. Near the top right corner is documentation on using the drivers.

David

[Updated on: Tue, 14 June 2005 20:14]

Report message to a moderator

Re: Connection to Remote Oracle Databse using ODBC in VB [message #123988 is a reply to message #122718]

Wed, 15 June 2005 15:59

joeancell
Messages: 19
Registered: June 2005

Junior Member

If you are using ODBC driver, I don't believe it is possible to access remote server without installing Oracle client. Most of drivers I worked with communicate with OCI layer which requires you have Oracle client installed and defined server in your tnsnames.ora file.

Report message to a moderator

Previous Topic:	Forms Code
Next Topic:	D2K Migration to Windows XP from NT

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:36:24 CDT 2024