Untuk error1, coba anda update driver MDAC pada IIS anda gunakan yang
khusus buat windows NT. Pastikan direktori databasenya benar.
Untuk error2, jawabannya seperti jawaban mas Januar
STY wrote:
> 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]
> -----------------------------------------------------------
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]
-----------------------------------------------------------
