|
 |
access_asp thread: Connection Error with PWD protection.
Message #1 by =?iso-8859-1?B?QnJpYW4gVHJpcHAg9L/0?= <brian_tripp@m...> on Wed, 13 Feb 2002 16:20:44 -0500
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0000_01C1B4AA.63E55B20
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
Hello,
System setup:
Windows NT 4.0 SP 6 running IIS 4.0
Test Browser IE 6
I need to connect to a password protected access database. I?m required to
do this using a DSN-less connection.
Here is my code and error message.
Dim objConn
Dim strConnect
Set objConn = server.CreateObject("ADODB.Connection")
strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=F:\Databases\WorkInstr\EngWrkInstr.mdb;PWD=password;"
objConn.Open strConnect
Error message I receive.
Microsoft JET Database Engine error '80004005'
Could not find installable ISAM.
If I remove the password from the database it will open the connection
without any problems using the following string.
strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=F:\Databases\WorkInstr\EngWrkInstr.mdb;?
Any help on this would be appreciated.
Brian
Message #2 by "Jeffrey Lee" <leech74@s...> on Thu, 14 Feb 2002 06:28:05 +0800
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_001E_01C1B520.C2E9AEC0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I think it should be "password" instead of "pwd".
Try it although I'm not sure if this is causing the problem.
----- Original Message -----
From: Brian Tripp =F4=BF=F4
To: Access ASP
Sent: Thursday, February 14, 2002 5:20 AM
Subject: [access_asp] Connection Error with PWD protection.
Hello,
System setup:
Windows NT 4.0 SP 6 running IIS 4.0
Test Browser IE 6
I need to connect to a password protected access database. I'm
required to do this using a DSN-less connection.
Here is my code and error message.
Dim objConn
Dim strConnect
Set objConn =3D server.CreateObject("ADODB.Connection")
strConnect =3D "Provider=3DMicrosoft.Jet.OLEDB.4.0;" & _
"Data Source=3DF:\Databases\WorkInstr\EngWrkInstr.mdb;PWD=3Dpassword;"
objConn.Open strConnect
Error message I receive.
Microsoft JET Database Engine error '80004005'
Could not find installable ISAM.
If I remove the password from the database it will open the connection
without any problems using the following string.
strConnect =3D "Provider=3DMicrosoft.Jet.OLEDB.4.0;" & _
"Data Source=3DF:\Databases\WorkInstr\EngWrkInstr.mdb;"
Any help on this would be appreciated.
Brian
$subst('Email.Unsub').
Message #3 by "Ken Schaefer" <ken@a...> on Thu, 14 Feb 2002 11:37:18 +1100
|
|
http://www.adopenstatic.com/faq/80040e21.asp#Scenario2
<quote>
This is not to be confused with attempting to use a property that does not
exist. If the last line the the connection string above was changed from
Initial Catalog=pubs to Foobar=Hello then an entirely different error is
generated. For Access/Jet the error message is:
Microsoft JET Database Engine (0x80004005)
Could not find installable ISAM
</quote>
You are attempting to set a property that does not exist (PWD=).
http://www.able-consulting.com/ado_conn.htm#OLEDBProviderForMicrosoftJet
has all the supported properties for the Jet OLEDB Provider
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Brian Tripp τΏτ" <brian_tripp@m...>
Subject: [access_asp] Connection Error with PWD protection.
: Hello,
:
: System setup:
: Windows NT 4.0 SP 6 running IIS 4.0
: Test Browser IE 6
:
: I need to connect to a password protected access database. I'm required
to
: do this using a DSN-less connection.
: Here is my code and error message.
:
: Dim objConn
: Dim strConnect
:
: Set objConn = server.CreateObject("ADODB.Connection")
:
: strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
: "Data Source=F:\Databases\WorkInstr\EngWrkInstr.mdb;PWD=password;"
:
: objConn.Open strConnect
: Error message I receive.
: Microsoft JET Database Engine error '80004005'
: Could not find installable ISAM.
: If I remove the password from the database it will open the connection
: without any problems using the following string.
:
: strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
: "Data Source=F:\Databases\WorkInstr\EngWrkInstr.mdb;"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Message #4 by Thomas Bellavia <TBellavia@V...> on Thu, 14 Feb 2002 09:14:02 -0500
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C1B561.DA866320
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
You need a User ID as well.
-----Original Message-----
From: Jeffrey Lee [mailto:leech74@s...]
Sent: Wednesday, February 13, 2002 5:28 PM
To: Access ASP
Subject: [access_asp] Re: Connection Error with PWD protection.
I think it should be "password" instead of "pwd".
Try it although I'm not sure if this is causing the problem.
----- Original Message -----
From: Brian <mailto:brian_tripp@m...> Tripp =F4=BF=F4
To: Access <mailto:access_asp@p...> ASP
Sent: Thursday, February 14, 2002 5:20 AM
Subject: [access_asp] Connection Error with PWD protection.
Hello,
System setup:
Windows NT 4.0 SP 6 running IIS 4.0
Test Browser IE 6
I need to connect to a password protected access database. I'm
required to
do this using a DSN-less connection.
Here is my code and error message.
Dim objConn
Dim strConnect
Set objConn =3D server.CreateObject("ADODB.Connection")
strConnect =3D "Provider=3DMicrosoft.Jet.OLEDB.4.0;" & _
"Data Source=3DF:\Databases\WorkInstr\EngWrkInstr.mdb;PWD=3Dpassword;"
objConn.Open strConnect
Error message I receive.
Microsoft JET Database Engine error '80004005'
Could not find installable ISAM.
If I remove the password from the database it will open the connection
without any problems using the following string.
strConnect =3D "Provider=3DMicrosoft.Jet.OLEDB.4.0;" & _
"Data Source=3DF:\Databases\WorkInstr\EngWrkInstr.mdb;"
Any help on this would be appreciated.
Brian
$subst('Email.Unsub').
$subst('Email.Unsub').
Message #5 by =?iso-8859-1?B?QnJpYW4gVHJpcHAg9L/0?= <brian_tripp@m...> on Fri, 15 Feb 2002 08:39:32 -0500
|
|
Thanks to all that posted as you said the property did not exist.
I found what I needed by following Ken's link.
http://www.able-consulting.com/ado_conn.htm#OLEDBProviderForMicrosoftJet
I was not using a Workgroup Information File just a password for the
database
so the correct string follows for all interested.
strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=F:\Databases\WorkInstr\EngWrkInstr.mdb;Jet OLEDB:Database
Password=duh;"
Thanks again,
Brian
-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: Wednesday, February 13, 2002 7:37 PM
To: Access ASP
Subject: [access_asp] Re: Connection Error with PWD protection.
http://www.adopenstatic.com/faq/80040e21.asp#Scenario2
<quote>
This is not to be confused with attempting to use a property that does not
exist. If the last line the the connection string above was changed from
Initial Catalog=pubs to Foobar=Hello then an entirely different error is
generated. For Access/Jet the error message is:
Microsoft JET Database Engine (0x80004005)
Could not find installable ISAM
</quote>
You are attempting to set a property that does not exist (PWD=).
http://www.able-consulting.com/ado_conn.htm#OLEDBProviderForMicrosoftJet
has all the supported properties for the Jet OLEDB Provider
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Brian Tripp τΏτ" <brian_tripp@m...>
Subject: [access_asp] Connection Error with PWD protection.
: Hello,
:
: System setup:
: Windows NT 4.0 SP 6 running IIS 4.0
: Test Browser IE 6
:
: I need to connect to a password protected access database. I'm required
to
: do this using a DSN-less connection.
: Here is my code and error message.
:
: Dim objConn
: Dim strConnect
:
: Set objConn = server.CreateObject("ADODB.Connection")
:
: strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
: "Data Source=F:\Databases\WorkInstr\EngWrkInstr.mdb;PWD=password;"
:
: objConn.Open strConnect
: Error message I receive.
: Microsoft JET Database Engine error '80004005'
: Could not find installable ISAM.
: If I remove the password from the database it will open the connection
: without any problems using the following string.
:
: strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
: "Data Source=F:\Databases\WorkInstr\EngWrkInstr.mdb;"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
|
|
View Cart
