64 bit connection string to ORACLE

[Andrzejek]

I have this connection string to connect to ORACLE

strCn = "Driver={Microsoft ODBC for Oracle};" & _
        "SERVER=T321;UID=ANDY;PWD=MYPASS"

(VBA code for MicroStation, kind of AutoCAD)

It works fine for most of my users, but some of them run it on 64-bit machines and this connection does not work.

Any ideas of what should I use for my connection string instead....?

Have fun.

---- Andy

 

[oradba101]

Hi, Andy

Is the Oracle ODBC driver an option? It generally works better than Microsoft's driver does.

Regards,


William Chadbourne
Programmer/Analyst