DATA SOURCE NOT FOUND NO DEFAULT DRIVER SPECIFIED

22 Sep 2005 11:26 AM

ambrish.dwivedi

hi there,
i have got a client server application made in VB6 using an oracle91
databse .It was working fine earlier but now we have deployed server
application in another computer.Doing which it throws the error.
"DATA SOURCE NOT FOUND NO DEFAULT DRIVER SPECIFIED"

I have made the system dsn and user dsn entries and the test connection
was succesful.i can acces the database server through sqlplus though!!
i just dont know wat is going wrong.here is the code of my connection
string:

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;"

Dim rscnt As ADODB.recordset
Set rscnt = New ADODB.recordset

so plzz help me in gettin out of it,as all my trials have failed so
far...

22 Sep 2005 1:25 PM

Douglas Marquardt

Hmmm... sounds to me like when the oracle client was installed,
they did not select "custom" and install the oledb driver for oracle?

Doug.

Show quoteHide quote

<ambrish.dwiv***@gmail.com> wrote in message news:1127388407.899926.66900@o13g2000cwo.googlegroups.com...
> hi there,
> i have got a client server application made in VB6 using an oracle91
> databse .It was working fine earlier but now we have deployed server
> application in another computer.Doing which it throws the error.
> "DATA SOURCE NOT FOUND NO DEFAULT DRIVER SPECIFIED"
>
> I have made the system dsn and user dsn entries and the test connection
> was succesful.i can acces the database server through sqlplus though!!
> i just dont know wat is going wrong.here is the code of my connection
> string:
>
> 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;"
Show quoteHide quote

>
>
>
>
> Dim rscnt As ADODB.recordset
> Set rscnt = New ADODB.recordset
>
> so plzz help me in gettin out of it,as all my trials have failed so
> far...
>

22 Sep 2005 2:32 PM

Tony Spratt

"Douglas Marquardt" <no_spam@dummy.com> wrote in message
news:usDfZk3vFHA.2164@TK2MSFTNGP10.phx.gbl...
> Hmmm... sounds to me like when the oracle client was installed,
> they did not select "custom" and install the oledb driver for oracle?
>
> Doug.

Or the driver is not locally known as: "DRIVER={Oracle in OraHome90}" any
more.

I've had problems where different installations (upgrades vs. clean,
multiple homes etc.) have different driver names. Oracle seems quite good at
that...