ODBC - Connection String

[jer99 via AccessMonster.com]

I'm having a hard time with a connection string to my oracle database.

What I'm trying to do is run a stored procedure on the oracle side from
Access.
I have set up the code and defined ADODBConnection as NEW ADODB.Connection

I then format my string like this:
MyConnection = "ODBC;DSN=TEST1;UID=TA_PROD1;PWD=PASSWORD;DATABASE=TA.
COM_PROD;"

I then use the following:
ADOConnect.ConnectionString = sConnection
ADOConnect.Open

It errors and tells me
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified

I know I've used a string like this to connect to a database using a dim as a
DATABASE, but I'm having a hard time with this one.
Anyone have any ideas?

 

[RD]

Hmm. I made an application that pulls data from Word forms and writes to an
Oracle db twice a day. Here is my code:

Dim cnn As New ADODB.Connection, sConn As String

sConn = "PROVIDER=MSDAORA; DATA SOURCE=sirdip; USER ID=smith;PASSWORD=letmein;"

cnn.Open sConn
<more code>

See this: http://tinyurl.com/yuvbjw for more.

HTH,
RD