Solved

Catastrophic failure

Posted on 2003-11-23
5
1,226 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
[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
  • 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: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone 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

This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
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 process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Suggested Courses
Course of the Month6 days, 15 hours left to enroll

622 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