ConnectionStrings for ADO Data Control

[Giraffe69]

I'm new to ADO Data Controls having trouble writing a connection string to use.

In the open code:

Set c = New ADODB.Connection
c.ConnectionString = "Driver={Microsoft ODBC for Oracle}; Server=myServ.world; Uid=myID;Pwd=myPWD;"

the connection string above works fine. But when I try to use it in thr ConnectionString property of an ADO Data Control I get the error:

...ORA-00942: table or view does not exist

I've tried including extra terms like:

Database=mySchema; OR DataSource=mySchema;

but this generates the error:

...Driver's SQLSetConnectAttr failed.

I've even tried including a provider term like:

Provider=msdaora;

but this generates the classic 'TNS:unable to connect to destination' error.

This is really doing my head in! Any advice on how to get the Data Control to work would be really appreciated?

Andy

 

[MarkSweetland]

You can find a wealth of connection string examples here:

http://www.able-consulting.com/tech.htm

Mark

"You guys pair up in groups of three, then line up in a circle."
- Bill Peterson, a Florida State football coach

 

[zemp]

I believe that datacontrol has a wizard that helps build the connection string. Look for the ellipses in the property window when you highlight the datasource property.

zemp