|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#1
|
|||
|
|||
|
ADODB.Connection.1 error '80004005'
I hage been trying for ages . . . this code will not work .. the directory is correct .. i think that the connection string is incorrect . ..
can someone help me out This is the error ADODB.Connection.1 error '80004005' SQLState: IM002 Native Error Code: 0 [INTERSOLV][ODBC lib] Data source name not found and no default driver specified include/constring.asp, line 9 --------------------------------------------------------------------------------- this is my code .. --------------------------------------------------------------------------------- <% Dim Conn 'Connection object Dim AdminName 'Administration username Dim AdminPassword 'Administration password Dim ImageFolderName Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("fpdb/gallery.mdb") AdminName = "admin" AdminPassword = "admin" ImageFolderName = "images" 'Subroutine to check admin login details function findUser(UserID, Password) if TRIM(UserID)=AdminName AND TRIM(Password)=AdminPassword then Session("UserID") = TRIM(UserID) Session("Password") = TRIM(Password) findUser = true ELSE findUser=false message = "Sorry, Incorrect username / password" END IF end function %> ---------------------------------------------------------------------------------- you can msg me on msn at URL THANK YOU ANYONE!!! |
|
#2
|
|||
|
|||
|
i still want an answer . . . is there really no one that knows what is wrong with the code???
|
|
#3
|
|||
|
|||
|
connection with access
Instead of Provider=... use
Driver={Microsoft Access Driver (*.MDB)}; |
|
#4
|
|||
|
|||
|
What server OS? The error you listed may be caused if you are trying to put an Access db on a *nix box using chilisoft for asp.
If you're on a windows server you may need to update your MDAC, you can download the latest from http://www.microsoft.com/data |
![]() |
| Viewing: Dev Shed Forums > Databases > Database Management > ADODB.Connection.1 error '80004005' |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|