Cannot open Access database in ASP

[xg]

Hi, I am writing an ASP page which contains the following code:

var MM_DBConn=Serve r.CreateObject( "ADODB.Connecti on");
MM_DBConn.Open( "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=c:\trio. mdb;"); // failed on this line
//MM_editQuery is an INSERT sql statement
MM_DBConn.Execu te(MM_editQuery );

When I run this on a Windows 2000 Professional system, I got the following
error:

Microsoft JET Database Engine error '80004005'

Not a valid file name.

And it points out that it failed on the MM_DBConn.Open statement.

However, if I copy the above code to a Visual Basic 6.0 form (on the same
machine) like this:

Private Sub Command1_Click( )
Dim o As Object
Dim rs As Object

Set o = CreateObject("a dodb.connection ")
Call o.open("Provide r=Microsoft.Jet .OLEDB.4.0;Data Source=c:\trio. mdb")
Set rs = o.execute("sele ct count(*) from comments")

End Sub

Everything works. Can someone tell me what went wrong? Thanks!

xg

[Mike Brind]

xg wrote:

Hi, I am writing an ASP page which contains the following code:

var MM_DBConn=Serve r.CreateObject( "ADODB.Connecti on");
MM_DBConn.Open( "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=c:\trio. mdb;"); // failed on this line
//MM_editQuery is an INSERT sql statement
MM_DBConn.Execu te(MM_editQuery );

When I run this on a Windows 2000 Professional system, I got the following
error:

Microsoft JET Database Engine error '80004005'

Not a valid file name.

And it points out that it failed on the MM_DBConn.Open statement.

However, if I copy the above code to a Visual Basic 6.0 form (on the same
machine) like this:

Private Sub Command1_Click( )
Dim o As Object
Dim rs As Object

Set o = CreateObject("a dodb.connection ")
Call o.open("Provide r=Microsoft.Jet .OLEDB.4.0;Data Source=c:\trio. mdb")
Set rs = o.execute("sele ct count(*) from comments")

End Sub

Everything works. Can someone tell me what went wrong? Thanks!

xg

You have an extra semicolon after the closing parenthesis, after your
connection string. It should look like this:

MM_DBConn.Open( "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=c:\trio. mdb;")

You'll also need to do the same on the following line:

MM_DBConn.Execu te(MM_editQuery )

--
Mike Brind

[Bob Barrows [MVP]]

xg wrote:

Hi, I am writing an ASP page which contains the following code:

var MM_DBConn=Serve r.CreateObject( "ADODB.Connecti on");
MM_DBConn.Open( "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=c:\trio. mdb;"); // failed on this line
//MM_editQuery is an INSERT sql statement
MM_DBConn.Execu te(MM_editQuery );

When I run this on a Windows 2000 Professional system, I got the
following error:

Microsoft JET Database Engine error '80004005'

Not a valid file name.

This is most likely a permissions problem. If your website is using
Anonymous access, then the IUSR_machinenam e account needs to be granted
Change permissions for the folder containing your database file (which
probably should be located in a subfolder, not in the root).
http://www.aspfaq.com/show.asp?id=2009

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Kyle Peterson]

permissions probably

http://www.powerasp.com/content/new/...ermissions.asp

http://www.powerasp.com/content/new/...ermissions.asp
"Mike Brind" <pa*******@hotm ail.com> wrote in message
news:11******** **************@ e56g2000cwe.goo glegroups.com.. .

xg wrote:

Hi, I am writing an ASP page which contains the following code:

var MM_DBConn=Serve r.CreateObject( "ADODB.Connecti on");
MM_DBConn.Open( "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=c:\trio. mdb;"); // failed on this line
//MM_editQuery is an INSERT sql statement
MM_DBConn.Execu te(MM_editQuery );

When I run this on a Windows 2000 Professional system, I got the
following
error:

Microsoft JET Database Engine error '80004005'

Not a valid file name.

And it points out that it failed on the MM_DBConn.Open statement.

However, if I copy the above code to a Visual Basic 6.0 form (on the same
machine) like this:

Private Sub Command1_Click( )
Dim o As Object
Dim rs As Object

Set o = CreateObject("a dodb.connection ")
Call o.open("Provide r=Microsoft.Jet .OLEDB.4.0;Data
Source=c:\trio. mdb")
Set rs = o.execute("sele ct count(*) from comments")

End Sub

Everything works. Can someone tell me what went wrong? Thanks!

xg

You have an extra semicolon after the closing parenthesis, after your
connection string. It should look like this:

MM_DBConn.Open( "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=c:\trio. mdb;")

You'll also need to do the same on the following line:

MM_DBConn.Execu te(MM_editQuery )

--
Mike Brind

[xg]

Thanks everyone. I grant the "Modify" permission of
"c:\inetpub\www root\triomotors \" for user "IUSR_DESKT OP" and the code now
looks like this:

var MM_DBConn=Serve r.CreateObject( "ADODB.Connecti on");
MM_DBConn.Open( "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=c:\inetp ub\wwwroot\trio motors\trio.mdb ;");
MM_DBConn.Execu te(MM_editQuery );

I still get the same error message. Please help. Thanks!

xg

"Bob Barrows [MVP]" <re******@NOyah oo.SPAMcom> wrote in message
news:eY******** ******@TK2MSFTN GP14.phx.gbl...

xg wrote:

Hi, I am writing an ASP page which contains the following code:

var MM_DBConn=Serve r.CreateObject( "ADODB.Connecti on");
MM_DBConn.Open( "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=c:\trio. mdb;"); // failed on this line
//MM_editQuery is an INSERT sql statement
MM_DBConn.Execu te(MM_editQuery );

When I run this on a Windows 2000 Professional system, I got the
following error:

Microsoft JET Database Engine error '80004005'

Not a valid file name.

This is most likely a permissions problem. If your website is using
Anonymous access, then the IUSR_machinenam e account needs to be granted
Change permissions for the folder containing your database file (which
probably should be located in a subfolder, not in the root).
http://www.aspfaq.com/show.asp?id=2009

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Bob Barrows [MVP]]

It's got nothing to do with your problem, but you really should put the
folder containing the database outside of the wwwroot folder for security
reasons.

A couple questions:
Where is this code located? If it's in one of the event handler subs in
global.asa, then the IWAM_machinenam e account also needs Modify permissions
for the folder containing the database.
Is this database file located on the same machine as the website?
Is your website using Anonymous access? If it's using Integrated
Authentication with Anonymous disabled, then all database users require
Modify permissions for the folder containing the database, not just IUSR and
IWAM.
Have you modified the isolation settings for your application? With some
settings, the IWAM account is doing the work, not the IUSR, so you need to
grant permissions to the IWAM account.

xg wrote:

Thanks everyone. I grant the "Modify" permission of
"c:\inetpub\www root\triomotors \" for user "IUSR_DESKT OP" and the code
now looks like this:

var MM_DBConn=Serve r.CreateObject( "ADODB.Connecti on");
MM_DBConn.Open( "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=c:\inetp ub\wwwroot\trio motors\trio.mdb ;");
MM_DBConn.Execu te(MM_editQuery );

I still get the same error message. Please help. Thanks!

xg

"Bob Barrows [MVP]" <re******@NOyah oo.SPAMcom> wrote in message
news:eY******** ******@TK2MSFTN GP14.phx.gbl...

xg wrote:

Hi, I am writing an ASP page which contains the following code:

var MM_DBConn=Serve r.CreateObject( "ADODB.Connecti on");
MM_DBConn.Open( "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=c:\trio. mdb;"); // failed on this line
//MM_editQuery is an INSERT sql statement
MM_DBConn.Execu te(MM_editQuery );

When I run this on a Windows 2000 Professional system, I got the
following error:

Microsoft JET Database Engine error '80004005'

Not a valid file name.

This is most likely a permissions problem. If your website is using
Anonymous access, then the IUSR_machinenam e account needs to be
granted Change permissions for the folder containing your database
file (which probably should be located in a subfolder, not in the
root). http://www.aspfaq.com/show.asp?id=2009

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so
I don't check it very often. If you must reply off-line, then remove
the "NO SPAM"

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[pen]

You can try this codes bellow. The Asp page must save under the
directory "c:\inetpub\www root\triomotors \" .
Provider = "Provider=Micro soft.Jet.OLEDB. 4.0;"
DBPath = "Data Source=" & Server.MapPath( "trio.mdb")

Set MM_DBConn = Server.CreateOb ject("ADODB.Con nection")
MM_DBConn.Open Provider & DBPath
MM_DBConn.Execu te("MM_editQuer y")

--
pen
------------------------------------------------------------------------
Posted via http://www.codecomments.com
------------------------------------------------------------------------