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

From: <arno_at_sysdec.ee>
Date: Mon, 04 Jan 1999 10:18:21 GMT
Message-ID: <76q4hc$hop$1@nnrp1.dejanews.com>

Hello!

You must use an empty string for database if connecting to personal oracle:

Set OraDatabase = OraSession.DbOpenDatabase("", _

"username/userpassword", 0&)

Arno Nurges

In article <3684f8e0.1836644_at_news.igs.net>, acresr_at_cnwl.igs.net wrote:
> 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
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Jan 04 1999 - 04:18:21 CST