Database Discussion - Does anyone know what this error means?

Print Page | Close Window

Does anyone know what this error means?

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=7592
Printed Date: 30 March 2026 at 1:12pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Does anyone know what this error means?

Posted By: mattsang
Subject: Does anyone know what this error means?
Date Posted: 25 November 2003 at 9:01am

Vbscript Runtime error 'ASP 0185 : -2147467259'
Data source name not found or no default driver specified

/acc2/pwd2.asp,line 6

The script:

Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("Users.mdb")
sql = "Select * From users Where ID='" & ID & "' And Pwd = '" & Pwd & "'"
Set rs = conn.Execute( sql )

Replies:

Posted By: MorningZ
Date Posted: 25 November 2003 at 9:05am

it means your connection string is not correct or is not pointing to the right location of the file

-------------
Contribute to the working anarchy we fondly call the Internet

Posted By: BoLt
Date Posted: 25 November 2003 at 9:10am

I may be wrong but it sounds like your data base is corrupt and can not find the information the script is looking for.

I may be corrected on this!!!!

-------------
BoLt (Computer Engineer)
I suffer from Dyslexia, it means I can not spell to well not that I am thick.

www.welshlens.co.uk

Posted By: mattsang
Date Posted: 25 November 2003 at 9:15am

which problem leads to this error? ODBC setting? or DSN? or file permission?