|
 |
asp_database_setup thread: New User - Help
Message #1 by "hk chua" <chua@a...> on Sun, 18 Nov 2001 01:14:06
|
|
hi,
i've been experimenting with asp coding...
the below is my code for the database connection:-
Dim Conn, dbPath
dbPath = "User.mdb"
Set Conn = Server.CreateObject("adodb.Connection")
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Datasource =" & dbPath
I keep getting the error message:-
"Microsoft JET Database Engine error '80004005'
Could not find installable ISAM. "
Can anybody please tell me what is wrong?
Thanks
cheers
huikee
Message #2 by "Ken Schaefer" <ken@a...> on Mon, 19 Nov 2001 11:19:44 +1100
|
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "hk chua" <chua@a...>
Subject: [asp_database_setup] New User - Help
: the below is my code for the database connection:-
:
: Dim Conn, dbPath
: dbPath = "User.mdb"
: Set Conn = Server.CreateObject("adodb.Connection")
: Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Datasource =" & dbPath
:
: I keep getting the error message:-
: "Microsoft JET Database Engine error '80004005'
: Could not find installable ISAM. "
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your connection string is incorrect. Data Source is two words, not one.
See: http://www.adopenstatic.com/faq/80040e21.asp#Scenario2
You need:
strDBConnect = _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & strDBPath & ";"
Cheers
Ken
Message #3 by "hk chua" <chua@a...> on Sat, 24 Nov 2001 18:06:30
|
|
thanks. it works now!
cheers
huikee
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> From: "hk chua" <chua@a...>
> Subject: [asp_database_setup] New User - Help
>
> : the below is my code for the database connection:-
> :
> : Dim Conn, dbPath
> : dbPath = "User.mdb"
> : Set Conn = Server.CreateObject("adodb.Connection")
> : Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Datasource =" & dbPath
> :
> : I keep getting the error message:-
> : "Microsoft JET Database Engine error '80004005'
> : Could not find installable ISAM. "
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> Your connection string is incorrect. Data Source is two words, not one.
> See: http://www.adopenstatic.com/faq/80040e21.asp#Scenario2
>
> You need:
> strDBConnect = _
> "Provider=Microsoft.Jet.OLEDB.4.0;" & _
> "Data Source=" & strDBPath & ";"
>
> Cheers
> Ken
>
>
|
|
|
View Cart
