Data source not found no default driver specified.

From: ad <ambrish.dwivedi_at_gmail.com>
Date: 20 Sep 2005 07:05:55 -0700
Message-ID: <1127225155.541948.295880@g43g2000cwa.googlegroups.com>

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. Received on Tue Sep 20 2005 - 09:05:55 CDT