VB connecting to Oracle error - sqresus.dll

[alleycraine]

We have a VB app that connects to Oracle. It was doing just fine until we had to modify the code because the XP users could not get connect to Oracle - See code below.

Now on only a few users machines When I try to run the application that connects to Oracle I get the Error 1114- could not load sqresus.dll.

Tried to re-install oracle client with no use.
The DB is Oracle 8i.



yesno = MsgBox("Is your system an XP system?", vbYesNo)

Set gOCnn = New ADODB.Connection
uid = clean_string(DLOOKUP("Oracle_User", "tbl_Environment_ref"))
pw = clean_string(DLOOKUP("Oracle_pw", "tbl_Environment_ref"))
With gOCnn
If yesno = vbNo Then
.ConnectionString = "Driver={Oracle ODBC Driver};" & _
"Dbq=Jidb;Uid=" & uid & ";Pwd=" & pw
Else
.ConnectionString = "Driver={Oracle in Oracle9};" & _
"Dbq=Jidb;Uid=" & uid & ";Pwd=" & pw
End If
.Open
End With

Oh, to connect to Oracle we have our Tnsnames file in the same directory location as the exe. This has been working fine.

 

[fredericofonseca]

If you use the ODBC test application supplied by Oracle can you connect to your system?

And TNSNAMES should be on the default directory, not on your own.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[alleycraine]

Where is the test application located?


Our users all run our vb.exe from a shared network directory. We put our tnames file in the same location as the exe and VB looks there first. That part has been working fine until we started having users on XP boxes and we needed to put the code in for the other driver. Now we are getting the error. But only on 3 out of 25 users. Now it maybe a coincidence about the timing of the error.
So far only Windows 2000 Pro users are having the problem.

 

[fredericofonseca]

http://forums.oracle.com/forums/thr...50&message=923097&q=6f6462632074657374#923097

will give you some insight.


You should still be able to test the connection by setting up a ODBC connection on control panel and testing it there.

What Oracle client have you installed on the "error" machines?

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[alleycraine]

They have client Oracle 81.

The users computers are locked down tight.
I will see if I can get on one of their computers and try to run the odbc test.

I'm assuming that will test if their driver works?

Thanks

 

[fredericofonseca]

Yes That is the general idea. If the ODBC works then your application is doing something "wrong".


You may also wish to install and try with Client 9i or even 10g, as 8.x is no longer supported, and I'm not sure if it was previously certified on w2000, and most definitely was not on XP.



Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[alleycraine]

Ok, just installed 9i on a users machine and it still does not work, but hey we have a different error.

ODBC Driver Manager: Data Source name not found and no default driver specified.

Have not tested the ODBC connection yet.
They have the users machines locked tight here so I am trying to get admin permissions to one of the machines.. Its like pulling teeth. I actually have an admin guy follow me around so he can log in for me.. I think they are thinking twice on this one.

I appreciate your help..
I am out of my league on this one.

 

[alleycraine]

Ok,
W2K user with Oracle 8 client:
I was able to test the driver and it does not work..
I get cannot load sqora32.dll.


But now My XP users (Oracle 9 clients) are having drivers not working also..
same basic error when I try to create a DS with the Oracle 9 in 9 driver and I get the error driver not working - sqora32.dll

Could there be something in the code that I posted that would corrupt the driver?

They have another DS created with the same driver so it had to work prior to us installing our VB code.

 

[alleycraine]

Ok,
I think the XP users issue is resolved.
They either dont have Oracle Client on their machines or the ones that do dont have permissions to the Oracle home directory..

Still working on the w2K users..
Oracle 9i client is not installing correctly.
The driver is not showing up in the DataSource - driver section.

 

[fredericofonseca]

Yep that's what I was thinking.

Nothing I can do there, but I would suggest logging as Administrator to those machines, remove Oracle using the installer, and then MANUALLY remove all references to the Oracle installation from both registry and the "program files" directory.


You probably have a contract with Oracle. If you do ask them for help through Metalink.

Also search and/or post this problem on forums.oracle.com as there may be something to help you.


As you have a very restricted environment that probably means that your IT department has some type of PC imaging done. Ask them to setup a image with the latest version of Oracle that works with your Application. Try with the latest you can. The Oracle client is free, so you can use V10 to connect to your V8 or V9 Server. The main thing is that you need to test your application and see if it works well with all versions.

Also as I said before the TNSNAMES should be on the default installation directory, not on your network. If your problem is distributing the file to your users there are some very easy ways to do that, and your network admins should help you here.

regarding your question

Could there be something in the code that I posted that would corrupt the driver?

Your connection string as you've show on your post does not affect anything.
The only problems you could get would be if your application set-up is trying to install any DLL's related to Oracle. If it is then you should remove those and use the Oracle installer instead. It has a silent option if you need it, but you should definitely use it instead of your own.




Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[alleycraine]

Ok,
Figured it out and it is something very simple..

There was not a path var pointing to the Oracle bin dir.

Once I set that up they were good to go..

One guys machine is just hose.. I will let them re-image that one..

Thanks