?
Solved

Erratic Oracle Database connection via vb program problem

Posted on 2003-02-20
5
Medium Priority
?
400 Views
Last Modified: 2012-05-04
I have written a vb6 SP5 program that connects to an Oracle database via the following code

cnOrcl.ConnectionString = "Provider=MSDAORA.1;Data Source=" + sOracleDataSource + "; " & _
        "User ID=" + sOracleUserID + ";Password=" + sOraclePassword + ";"
Screen.MousePointer = vbHourglass
On Error Resume Next '
cnOrcl.Open
If Err.Number <> 0 Then
    MsgBox "Error connecting to Oracle database  -   error   = " + CStr(Err.Number) + " - " + Err.Description, vbCritical, "Error"
     Screen.MousePointer = vbDefault
     Exit Sub
End If

The program works on most pc's but I know of at least 2 where this connection doesn't work and I get the following error:

Error connectiong to Oracle database - error - 3706 - Provider cannot be found. It may not be properly installed.

Now I have had IT reinstall all the odbc drivers.  I can connect to the database from Access and Excel using the odbc connection.  I have tried registering the msdaora.dll.  Frankly I have tried lots of different things over a period of about a day and am now flumoxed.

Does anyone have any ideas of what I could try next?

Thanks

Niall
0
Comment
Question by:NiallMoore
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 16

Expert Comment

by:twalgrave
ID: 7991331
1) Did you create a setup program and distribute that way?
2) Re-install the MDAC version you are using on their machine
3) Check the DSN to make sure it is properly set

0
 

Author Comment

by:NiallMoore
ID: 8004069
1.  Yes I did create a setup program which appears to have done its job properly.
2. I got the IT department to reinstall MDAC.  I have checked that it is the same version that I used.
3.  The DSN id fine.  I have used it to connect to the database via Aceess and Excel.

0
 
LVL 16

Accepted Solution

by:
twalgrave earned 400 total points
ID: 8004095
0
 

Expert Comment

by:CleanupPing
ID: 9447606
NiallMoore:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this post we will learn how to make Android Gesture Tutorial and give different functionality whenever a user Touch or Scroll android screen.
Create a Windows 10 custom Image with custom task bar and custom start menu using XML for deployment.
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question