Personal Oracle + VB6 + Oracle Objects for OLE????

Hi all!

Do you happen to know if we can use OO4O in VB6 to connect to Personal Oracle 7.3.4? I have tried using "2:", "ORCL", "2:ORCL", and "oracle" as my connect string (for database name), but I continue to get the error message "Object doesn't support this property or method."

I use the exact same code (with the production server name in place of "2:" at work without any problems whatsoever.

Following are my connection lines:

Set OraSession = CreateObject("OracleInProcServer.XOraSession")

Set OraDatabase = OraSession.DbOpenDatabase("2:", _

        "username/userpassword", 0&)

Any ideas???!

Thanks! And have a great Christmas holiday!

===> Roy
Received on Sat Dec 26 1998 - 09:00:20 CST