Data source not found no default driver specified.
- From: "ad" <ambrish.dwivedi@xxxxxxxxx>
- Date: 20 Sep 2005 07:05:55 -0700
hello,
am stuck with an application which uses
1. VB6,TCP/IP FOR CLIENT
2. VB6,TCP/IP,ADO FOR SERVER SIDE
3. ORACLE 9I FOR DATABASE.
on running the server application it gives the error "data source not
found no default driver specified"
am using the following code for connection:
Public Sub Connect()
On Error GoTo subend
Set cnnpass = New ADODB.Connection cnnpass.Provider =
"MSDASQL.1"
cnnpass.open "Persist Security Info=False;DRIVER={Oracle in
OraHome90};SERVER=WMPDB;UID=WMP_DEV;pwd=wmp_dev;DBQ=WMPDB;DBA=W;APA=T;EXC=F;XSM=Default;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;GDE=F;FRL=Lo;BAM=IfAllSuccessful;MTS=F;MDI=Me;CSR=F;FWC=F;PFC=10;TLO=O;"
am able to connect to the database using sqlplus,but not through the
application.Have checked the oracle driver entry in the odbc data
source administrator drivers list.
So plz suggest what is it dat is goin wrong ,this thing is driving me
crazy.
.
- Follow-Ups:
- Re: Data source not found no default driver specified.
- From: Turkbear
- Re: Data source not found no default driver specified.
- Prev by Date: Export hangs with: "exporting cluster definitions"
- Next by Date: Re: Career Advise - Database Management
- Previous by thread: Export hangs with: "exporting cluster definitions"
- Next by thread: Re: Data source not found no default driver specified.
- Index(es):
Relevant Pages
|
