Yth masterWeb;
Saya menggunakan ASP dan ADODB untuk akses database di
NT Server (IIS), namun gagal, pada hal kalau saya
run di mesin saya (NT/PWS) tdk masalah.
Database saya MSAccss2000 (sudah dicoba dengan
Access97 hasilnya sama)
Contoh script dan pesan kesalahan, saya lampirkan spt
dibawah ini.
Sudah dicoba juga dengan menset directory ke Read Write.
Mohon koreksinya, trimakasih.
Script1:
dbpath = Server.Mappath("linkdb.mdb")
set con = server.createobject("ADODB.Connection")
set rst = server.createobject("ADODB.Recordset")
conOpen = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
& dbPath & ";"
con.open conOpen
Error1:
ADODB.Connection error '800a0e7a'
ADO could not find the specified provider.
Script2:
dbpath = Server.Mappath("linkdb.mdb")
set con = server.createobject("ADODB.Connection")
set rst = server.createobject("ADODB.Recordset")
'conOpen = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
& dbPath & ";"
conOpen = "DRIVER={Microsoft Access Driver (*.mdb)};
DBQ=" & dbPath
Error2:
Microsoft OLE DB Provider for ODBC Drivers
error '80004005'
[Microsoft][ODBC Microsoft Access 97 Driver]
The Microsoft Jet database engine cannot open
the file '(unknown)'.
It is already opened exclusively by another user,
or you need permission to view its data.
Salam;
Sutoyo
Analisa Web Berhadiah total Rp.500.000 + Tshirt & Topi :
http://www.master.web.id/cgi-bin/webkritik/oktober.cgi
-------[ Master Web Indonesia - www.master.web.id ] -------
Moderator : [EMAIL PROTECTED]
Berlangganan : [EMAIL PROTECTED]
Stop Berlangganan : [EMAIL PROTECTED]
-----------------------------------------------------------
