DAO dsn-less connection?

[ordendelfai]

I am trying to use the below code to link a table from an Oracle server, using the Oracle ODBC Driver for RDB. The code below will pop open a login request, and after I enter the correct password I get:

"Run-time rrror '3000'
Reserved error (-7778); there is no message for this error."

This doesn't help as I have no error to find a solution. Anyone have any ideas?

Public Function LinkTables()
Dim db As DAO.Database
Dim tdf As DAO.TableDef
Dim strConnect As String

'KBASE Server:
strConnect = "ODBC;Driver={Oracle ODBC Driver for Rdb};" & _
"CLS=kdb_read;" & _
"SVR=ss-kdb;" & _
"UID=myuserid;"

Set db = CurrentDb()
    
    Set tdf = db.CreateTableDef("MyTable")
    tdf.Connect = strConnect
    tdf.SourceTableName = "MyTable"
    db.TableDefs.Append tdf

Set tdf = Nothing
Set db = Nothing

End Function

~Joel
As common courtesy and to help other members who might find your thread helpful in the future, please respond if the advice given resolved your issue.

 

[ordendelfai]

Checking in again to see if someone can help ;-)

~Joel
As common courtesy and to help other members who might find your thread helpful in the future, please respond if the advice given resolved your issue.

 

[Turkbear]

Hi,
Do you have an RDB database( the 64 bit Digital one) or an Oracle one..

The Oracle driver is usually just labeled Oracle Driver

Or use the CR supplied ones..

 

[ordendelfai]

Hmm, good question. I believe it is an RDB (not sure about the difference). I know that only the RDB driver works to connect to the server.

~Joel
As common courtesy and to help other members who might find your thread helpful in the future, please respond if the advice given resolved your issue.

 

[taupirho]

Let me get this right - you are trying to link an Oracle database to an RDB database?

 

[ordendelfai]

I just clarified with our database team, it is an RDB database. I am trying to connect to it from Access 97, but using a DSN-less connection. If I use the DSN, it works fine, but it would be very helpful if I could avoid using the DSN so I don't have any problems when distributing the .mdb.

Thanks for looking into this ;-)



~Joel
As common courtesy and to help other members who might find your thread helpful in the future, please respond if the advice given resolved your issue.

 

[taupirho]

Hi, the following url may be of use to you

http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm