Frustrating Situation with Oracle 8i Database

[abhijit]

Hi,
I am facing a specfic problem involving three entities

1) A dll which queries a table obtains a handle on the table
2) Oracle 8i DB
3) a VB form with a ImgEdit.ocx and ImgAdmin.ocx loaded on it.

My VB Form does not load if it gets an handle from the database and the database is Oracle 8i.
It displays a control not registered error.
The specific controls are ImgEdit.ocx and ImgAdmin.ocx

However if I get an handle from an SQL Server Database everything is hunky-dory.
The form loads without any problems.

In both the cases, I am using the same DLL.
The DLL returns me 1 (which is success) when it returns the handle.
Has anyone else faced such a problem? What could be the possible method to tackle this?

I am using VB 6.0 and this DLL has been written in Visual C++

Please help!

Thanks and Regards,
Abhijit

[jim mcnamara]

You cannot use the same DSN or driver for SQL SERVER that you use for Oracle. That's what the error is all about.

[abhijit]

Hi Jim,
Thanks for your interest in my case. However I would like to point out to you, that I am not using a dsn to connect to the database. I am creating a DSN on the fly. (This happens inside the VC++ DLL)
Also I take care to remove the DSN after it has been used. So there are two dsn's.

I am also trying this out with a test application, which is giving out erratic results as well. However the basic functionality of the form getting loaded in this test application does seem to be working.

Cheers!
Abhijit

[amitabh]

It might be a provider problem. Just check to see if you can create a DSN through Control Panel successfully.

[abhijit]

I am able to create a DSN successfully. The problem is not data retrieval, but image control loading.

Thanks & Regards
Abhijit

[Lisgarero]

Originally posted by abhijit
I am able to create a DSN successfully. The problem is not data retrieval, but image control loading.

Thanks & Regards
Abhijit

you trying load an image field from oracle table?

[abhijit]

Hi,
My specific problem is
1) If I establish a connection to an Oracle Database through a VC++ DLL, I am not able to load my form. VB CREATES A LOG WHICH STATES THAT THE IMGEDIT.OCX control is not registered.
2) If I do not use a call to the dll (which establishes the connection), I am able to load the form perfectly fine.
3) If I make this call to establish a connection after I have loaded the form, then I get an error in my connection. i.e my connection fails.


Surprise, I am able to make this work in SQL Server.
The VC++ takes a parameter which tells it connect to ORacle / SQL SERVER. This is working fine when tested without those imgedit and imgadmin controls.



Regards,
Abhijit