error 3151 - - connection to Oracle failed

[ricm9]

I keep getting this error message. I link Oracle tables to an Access db, make a DAO call to Access, and use an SQL statement to generate a recordset in VB. I know the Access connection is good because I can view the records from Access. Also, I can use the ODBC driver to manually connect (outside of VB). The DAO connection is good because I can get the name of the database.

OK, I didn't do the stupid things I did before like have the table open and try to connect. And I have used this successfully before, so what stupid thing am I doing wrong this time?

 

[ricm9]

Sorry.

The stupid thing I did THIS time was set the reference to DAO 3.6 and not 3.5. Once I made the switch, I had no problems.

I can be SUCH an idiot at times.