Solved

Catastrophic failure

Posted on 2003-11-23
5
1,224 Views
Last Modified: 2013-12-25
Hi,
I try to connect Oracle and I get this run-time eror:
-2147418113(8000ffff)     catastrophic failure .

any ideas ?

Thanks
0
Comment
Question by:fdsafog56
  • 3
5 Comments
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 9805814
Show how you try to connect (your code).
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 9805815
0
 

Author Comment

by:fdsafog56
ID: 9808827
Here the code:

Dim conDB As New ADODB.Connection
Dim strCnn  As String

 strCnn = "DSN=visits;UID=visit;PWD=visit;DBQ=kvilot;DBA=W;APA=T;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;FRL=F;PFC=10;TLO=0;"
 conDB.Open strCnn

0
 
LVL 70

Accepted Solution

by:
Éric Moreau earned 25 total points
ID: 9809573
Unless you really need a DSN, don't use them. Better use the OLE DB providers connection strings like in the link I have provided.
0
 
LVL 1

Assisted Solution

by:robdogg10
robdogg10 earned 25 total points
ID: 9816079
Remove DBQ from your connection string.  It's already defined in the DSN.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

I’ve seen a number of people looking for examples of how to access web services from VB6.  I’ve been using a test harness I built in VB6 (using many resources I found online) that I use for small projects to work out how to communicate with web serv…
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

820 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