Connection string og access

Den er: \"../db/password.mdb\"

//Claus

Den rigtige syntax er : DSN = \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\" & Server.MapPath (\"..\\db\\password.mdb\")

nordclc:
jeg får flg. svar

Microsoft OLE DB Provider for ODBC Drivers error \'80004005\'

[Microsoft][ODBC Microsoft Access Driver] \'(unknown)\' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

/secure/conn.asp, line 11

og tranekaer:

Microsoft OLE DB Provider for ODBC Drivers error \'80004005\'

[Microsoft][ODBC Microsoft Access Driver] Cannot open database \'(unknown)\'. It may not be a database that your application recognizes, or the file may be corrupt.

/secure/conn.asp, line 12

ahhh, prøv med:

DSN = \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\" & Server.MapPath (\"/db/password.mdb\")

//Claus

Funktionen Server.MapPath gør det, at den selv finder ud at stien, når den søger efter \"/db/password.mdb\"

//Claus

Du kan skifte DBQ=\" & Server.MapPath(\"..\\db\\password.mdb\") uden med DBQ=URL=../db/password.mdb\"

Tak for hjælpen