Connect Orcle8i using VB6 ADO

[larva]

Hi folks,

How to connect Orcle8i using VB6 ADO ? What should be the connection string ? Do I need to set it at Control Panel/Administrative Tools/Data Source(ODBC) there ? How to set it ? Any website contain these information ?

Public conn As ADODB.Connection
Public rs As ADODB.Recordset

 

[UThomas]

Why don't you just link the tables? Then you can refer to them as if they are local and only use "CurrentProject.Connection" instead of having to explicitly open the data source each time?

Thomas

 

[joohang]

Do a google search on "Data Source" or "Connection String". You'll see a site with virtually all DSN connection strings you'll ever need.