asp_web_howto thread: asp access help
Message #1 by "Bill Boyd" <wboyd@a...> on Mon, 3 Dec 2001 18:53:43
|
|
I've written a com component that access
an access database and returns a recordset
to asp. It works fine on my development
box (w2k) but when i move it to my production
box (nt4) i get this error.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access 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.
the connection string is
connstr = "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=pandp.mdb;DefaultDir=C:\inetpub\wwwroot\ppweb;" & _
"Uid=;Pwd=;"
theconn.Open connstr
The file isn't open and permission are everyone full control.
Any ideas?
Message #2 by "Ken Schaefer" <ken@a...> on Tue, 4 Dec 2001 11:47:18 +1100
|
|
What version of the Microsoft Data Access Components are installed on the
server? Win2k ships with MDAC v2.5, whereas if you only installed the NT
Option Pack onto the WinNT server, then you'd still be at MDAC v1.5 on the
server. If you're using something like Access2000, then the ODBC driver on
the server wont be able to open your new Access file.
You'll have to download the latest MDAC from www.microsoft.com/data/ and
make sure you get the additional Jet/Desktop Database Drivers download.
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Bill Boyd" <wboyd@a...>
Subject: [asp_web_howto] asp access help
: I've written a com component that access
: an access database and returns a recordset
: to asp. It works fine on my development
: box (w2k) but when i move it to my production
: box (nt4) i get this error.
:
: Microsoft OLE DB Provider for ODBC Drivers error '80004005'
:
: [Microsoft][ODBC Microsoft Access 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.
:
: the connection string is
:
: connstr = "Driver={Microsoft Access Driver (*.mdb)};" & _
: "Dbq=pandp.mdb;DefaultDir=C:\inetpub\wwwroot\ppweb;" & _
: "Uid=;Pwd=;"
: theconn.Open connstr
:
: The file isn't open and permission are everyone full control.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Message #3 by patrick.frenette@s... on Tue, 4 Dec 2001 13:11:39
|
|
Salut,
Try this:
connstr = "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=pandp.mdb;DefaultDir=C:\inetpub\wwwroot\ppweb\;" & _
"Uid=;Pwd=;"
theconn.Open connstr
Yours
Patrick Frenette
> I've written a com component that access
> an access database and returns a recordset
> to asp. It works fine on my development
> box (w2k) but when i move it to my production
> box (nt4) i get this error.
>
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC Microsoft Access 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.
>
> the connection string is
>
> connstr = "Driver={Microsoft Access Driver (*.mdb)};" & _
> "Dbq=pandp.mdb;DefaultDir=C:\inetpub\wwwroot\ppweb;" & _
> "Uid=;Pwd=;"
> theconn.Open connstr
>
> The file isn't open and permission are everyone full control.
>
> Any ideas?
Message #4 by William Boyd <WBOYD@a...> on Thu, 06 Dec 2001 08:16:23 -0700
|
|
Ken
I've Installed the mdac 2.7 and jetsp. went the dsn route by
creating the dsn and changing the connect string. All with no
success. I never had this problem will sql server. I'm going to
see if they have a copy here.
I want to thank you for all help you've given me. If you can think
of something else I'm all ears.
>>> "Ken Schaefer" <ken@a...> 12/03/01 07:47PM >>>
What version of the Microsoft Data Access Components are installed on the
server? Win2k ships with MDAC v2.5, whereas if you only installed the NT
Option Pack onto the WinNT server, then you'd still be at MDAC v1.5 on the
server. If you're using something like Access2000, then the ODBC driver on
the server wont be able to open your new Access file.
You'll have to download the latest MDAC from www.microsoft.com/data/ and
make sure you get the additional Jet/Desktop Database Drivers download.
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Bill Boyd" <wboyd@a...>
Subject: [asp_web_howto] asp access help
: I've written a com component that access
: an access database and returns a recordset
: to asp. It works fine on my development
: box (w2k) but when i move it to my production
: box (nt4) i get this error.
:
: Microsoft OLE DB Provider for ODBC Drivers error '80004005'
:
: [Microsoft][ODBC Microsoft Access 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.
:
: the connection string is
:
: connstr = "Driver={Microsoft Access Driver (*.mdb)};" & _
: "Dbq=pandp.mdb;DefaultDir=C:\inetpub\wwwroot\ppweb;" & _
: "Uid=;Pwd=;"
: theconn.Open connstr
:
: The file isn't open and permission are everyone full control.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Message #5 by danny.o'reilly@d... on Thu, 6 Dec 2001 16:22:59
|
|
The MS Knowledge Base has quite a bit of info on this error. Search for
string "The Microsoft Jet database engine cannot open the
file '(unknown)'" at http://support.microsoft.com/default.aspx?
scid=fh;rid;kbinfo
Danny
Message #6 by "Ken Schaefer" <ken@a...> on Fri, 7 Dec 2001 19:39:32 +1100
|
|
The only other thing I can think of is:
: connstr = "Driver={Microsoft Access Driver (*.mdb)};" & _
: : "Dbq=pandp.mdb;DefaultDir=C:\inetpub\wwwroot\ppweb;" & _
: : "Uid=;Pwd=;"
...change Dbq= to be a fully qualified path:
DBQ=c:\inetpub\wwwroot\ppweb\pandp.mdb
(or whatever)
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "William Boyd" <WBOYD@a...>
Subject: [asp_web_howto] Re: asp access help
: Ken
:
: I've Installed the mdac 2.7 and jetsp. went the dsn route by
: creating the dsn and changing the connect string. All with no
: success. I never had this problem will sql server. I'm going to
: see if they have a copy here.
:
: I want to thank you for all help you've given me. If you can think
: of something else I'm all ears.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
View Cart
