If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Data Access, Manipulation & Batch Languages > Delphi, C etc > Data Source Name Not Found and No Default Driver Specified PLEASE HELP!

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-04-03, 12:19
Kaan133 Kaan133 is offline
Registered User
 
Join Date: Jul 2003
Posts: 2
Data Source Name Not Found and No Default Driver Specified PLEASE HELP!

I wrote a program (in VB6) who uses Access Driver Database connection to connect databases with ADODC.
However in SOME systems I take an error message
"Data Source Name Not Found and No Default Driver Specified" and the program can't work properly.
Please help me where is the difference between a system who can operate this program and who cannot?
(Both have WinXP, OfficeXP, IIS, ODBC)
Which component should I install or what configurations shoul I make?

(the connection string is something like this:
Provider=MSDASQL.1;
Persist Security Info=False;
Extended Properties="DSN=MS Access Database; DBQ=C:\deneme.mdb; DriverId=25; FIL=MS
Access; MaxBufferSize=2048; PageTimeout=5;...
)

Please HELP

Thank you
Kaan
Reply With Quote
  #2 (permalink)  
Old 07-04-03, 17:04
dbadelphes dbadelphes is offline
Registered User
 
Join Date: Feb 2003
Location: Montreal, Canada
Posts: 117
Re: Data Source Name Not Found and No Default Driver Specified PLEASE HELP!

Try to install thelast version of MDAC from Microsoft's site on each computer where the application is installed, or you can try to package the app using the Package and Deployment Wizard(it should gather all the dependencies) then install the package on all destination computers.


Quote:
Originally posted by Kaan133
I wrote a program (in VB6) who uses Access Driver Database connection to connect databases with ADODC.
However in SOME systems I take an error message
"Data Source Name Not Found and No Default Driver Specified" and the program can't work properly.
Please help me where is the difference between a system who can operate this program and who cannot?
(Both have WinXP, OfficeXP, IIS, ODBC)
Which component should I install or what configurations shoul I make?

(the connection string is something like this:
Provider=MSDASQL.1;
Persist Security Info=False;
Extended Properties="DSN=MS Access Database; DBQ=C:\deneme.mdb; DriverId=25; FIL=MS
Access; MaxBufferSize=2048; PageTimeout=5;...
)

Please HELP

Thank you
Kaan
__________________
Steve
Reply With Quote
  #3 (permalink)  
Old 07-05-03, 11:50
Kaan133 Kaan133 is offline
Registered User
 
Join Date: Jul 2003
Posts: 2
There are some versions of MDAC_TYP.exe.
I downloaded a 5MB version. But it didnt solve the problem.
Reply With Quote
  #4 (permalink)  
Old 07-07-03, 09:07
dbadelphes dbadelphes is offline
Registered User
 
Join Date: Feb 2003
Location: Montreal, Canada
Posts: 117
Re: Data Source Name Not Found and No Default Driver Specified PLEASE HELP!

Any MDAC version 2.5+ should work
I'd suggest in that case to check the data link properties(property page for the ADODC control)->Use connection string radio button->Build button, and finaly test your connection. Maybe the access to DB is not allowed from those computers. Also check DSN in ODBC.

Quote:
Originally posted by dbadelphes
Try to install thelast version of MDAC from Microsoft's site on each computer where the application is installed, or you can try to package the app using the Package and Deployment Wizard(it should gather all the dependencies) then install the package on all destination computers.
__________________
Steve
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On