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

Roy

By the way, how are you finding OO4O?

I have been spending a lot of time with it over the last few weeks making it run with VB5 and PO8. I have found it to be rather unstable, particularly for bound controls such as the DBGrid and the MSFlexGrid. It seems to be more stable when those same controls are unbound and I load them manually, but that's obviously more work and I'm concerned that performance may be worse.

I'm currently using OO4O version 2.1.3.2.

What's your experience?

If you are using VB6, I'd be curious about MS's OLEDB for Oracle. It sounds like they borrowed the idea from OO4O. Do you have any experience with the OLEDB? I was considering getting VB6 just to try this, but it's quite expensive.

Looking forward to hearing from you.
Jerry

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
Received on Sun Dec 27 1998 - 17:29:51 CST