How can I connect VB6 to ORACLE8

[dafty]

i found the "oradc(oracle data control)" but i don't know how to use it. And Do you have another way to connect to oracle8 by VB6

 

[woyler]

dim cnConnection as ADODB.connection

Set cnConnection = Createobject("ADODB.Connection&quot

cnConnection.connectionstring = "provider=MSDAORA;data source=NAMEofYourSERVER;user id=YourUserName;password=YourPassword"

cnConnection.Open

'You can also use the ODBC driver for ORACLE. Here is the syntax for the connection string:
"driver={Microsoft ODBC for ORACLE};server=SERVER;uid=UserName;pwd=Password"

 

[dafty]

dear woyler,

i just a see in my computer and it have the OLE help in my oracle group. i will find to solve my problem by it. thank u. your answer help me much.