Re: Data source not found no default driver specified.

"ad" <ambrish.dwivedi_at_gmail.com> wrote:

>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.

Try using a DSN-Less connection instead ( it is more reliable - and is the current recommended method) - something like this

   cst = "Provider=OraOLEDB.Oracle;" & _

        "Server=<server>;" & _ 
        "Data Source=<dbname>;" & _ 
        "User ID=<uid>;" & _ 
        "Password=<pwd>" 
 

    set conn = CreateObject("ADODB.Connection")     conn.open cst Received on Tue Sep 20 2005 - 09:46:29 CDT