Re: Data source not found no default driver specified.
- From: Turkbear <john.g@xxxxxxxxxxxxxxxx>
- Date: Tue, 20 Sep 2005 09:46:29 -0500
"ad" <ambrish.dwivedi@xxxxxxxxx> 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
.
- Follow-Ups:
- References:
- Prev by Date: Re: Career Advise - Database Management
- Next by Date: Re: Data source not found no default driver specified.
- Previous by thread: Data source not found no default driver specified.
- Next by thread: Re: Data source not found no default driver specified.
- Index(es):
Relevant Pages
|
