Connecting VB6.0 and Oracle

[Siva7891]

Hi,
I have some fundamental knowledge about VS2008 and SQL SERVER 2005. For a mini project in my college I had to use VB6.0 and Oracle. Does if any one have links for online material about connecting VB6.0 and Oracle please reply me here. I tried some few things but doesn't worked anything for me

Regards,
Siva7891

[Hack]

Moved To Database Development

Welcome to the forums.

Not a whole lot left out there for VB6, but we do have a Database FAQ section that should help (liknk at the top of this page)

The big difference is that you will be using ADO not ADO.NET

[abhijit]

Hi,
I have some fundamental knowledge about VS2008 and SQL SERVER 2005. For a mini project in my college I had to use VB6.0 and Oracle. Does if any one have links for online material about connecting VB6.0 and Oracle please reply me here. I tried some few things but doesn't worked anything for me

Regards,
Siva7891

1) Install SQL NET client. This will give you the necessary drivers and also install Sqlplus on your machine. The SQLPlus is optional.
2) Configure the tnsnames.ora and sqlnet.ora to point to the correct listener.
3) Use a connectionstring for the Microsoft ODBC for Oracle.

These are the steps in a nutshell. There is a utility called tnsping that will allow you to verify the connection has been correctly configured.