View Full Version : Help with Access Database Search

09-03-2005, 08:05 AM
Help with Access Database Search.
Heya all,. Can anyone help with creating a search page to search an access database?

I created a login page which worked well. I could login by using a user name and password and it would login to the search page.

From there I then created a search.asp page followed by a results.asp page.

Now when I enter a user name and password to login to the search page i get the following message.
ADODB.Recordset.1 error '80004005'

SQLState: IM002
Native Error Code: 0
[INTERSOLV][ODBC lib] Data source name not found and no default driver specified

/html/search.asp, line 28

Line 28 in the search.asp pages reads as follows.

Recordset1.ActiveConnection = MM_connDatabase_STRING

Can anyone suggest what I have done wrong?

Thanks. MR.