Frustrating Situation with Oracle 8i Database

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

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

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

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

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

Thanks & Regards :)
Abhijit

Quote:

---

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?

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