Originally from : "Ganius Tanuel" <[EMAIL PROTECTED]>
Originally dated: Fri, 10 Nov 2000 10:33:29 +0700
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<e-WebAuthor>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~Forum Diskusi WebAuthoring untuk Kristen-Katholik~~~~~~~~~~~
Untuk yang script1, mungkin versi providernya beda, coba diganti dengan 3.5
atau 3.51. Tapi nanti errornya akan sama dengan script2. Kalau providernya
ketemu, sebaiknya memakai provider untuk 'mengirit' 1 layer.
Untuk error di script2, coba lihat di artikel Microsoft KB berikut:
Check NT Permissions When You Use IDC/ASP Files with Access
http://support.microsoft.com/support/kb/articles/Q161/3/33.asp
Regards,
.Gt
From: STY <[EMAIL PROTECTED]>
> Yth WebAuthor;
> 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 (gagalnya di baris "con.open conOpen")
> 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
> con.open conOpen
> 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.
I-KAN %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% e-WebAuthor
Permulaan hikmat adalah takut akan TUHAN! Mazmur 111:10a / Amsal 9:10a
-----------------------------------------------------------------------
WEB--> http://hub.xc.org/scripts/lyris.pl?enter=i-kan-webauthor
SUBSCRIBE--> To: [EMAIL PROTECTED], Isi/Body: kosong
UNSUBSCRIBE--> To: [EMAIL PROTECTED], Isi/Body: kosong
This conference is now hosted by GRC. See our site at
http://www.grcomputing.net
