Originally from : STY <[EMAIL PROTECTED]>
Originally dated: Wed, 8 Nov 2000 15:20:43 +0700
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<e-WebAuthor>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~Forum Diskusi WebAuthoring untuk Kristen-Katholik~~~~~~~~~~~
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.
Maaf, email yang sama sudah pernah saya kirimkan
ke milis lain.
Salam;
Sutoyo
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
