Problem in ASP

Actually i have got a problem while submitting form through asp into access database check the error blow:

Error:

Microsoft JET Database Engine error '80004005'

Not a valid file name.

/admin/login.asp, line 26

As far as path is concern its perfect but still problem at the same position, Does anyone know how can i fix this problem.

 

post admin/login.asp's code dude. i'll have a look

 

Are you sure that your connection string is pointing correctly to your MS Access database?

 

Actually i am calling cn.asp file in login.asp file and here is the code of cn.asp file:

<%
dim Conn
Conn = "Provider=Microsoft.JET.OLEDB.4.0; Data Source = /admin/db.mdb"
%>

Please guide me how can i fixed this problem!

 

What's your URL?

 

Couple of things...

First make sure that your mdb is in a directory that can't be red in IIS, for security purposes. Either put it outside of your web directory, or put it in a directory and go into IIS and disable reading.

But as far as your error, it's your connection string. Put in the full file path in there C:\....\admin\db.mdb

Conn = "Provider=Microsoft.JET.OLEDB.4.0; Data Source = C:\inetpub\....admin\db.mdb"

 

Actually, i am testing on live domain, here is the path: "http://mojizahfoods.com/admin/login.asp" and my database is in admin folder but still im getting error.

 

here is the URL: "http://mojizahfoods.com/admin/login.asp" and my database is in admin folder but still im getting error.

 

yes, i am 100% sure that my access database is pointing correctly with ms access database.

 

I tried to download your database by entering http://mojizahfoods.com/admin/db.mdb into my browser to see if it was there. Doesn't appear to be a valid URL.

 

Try putting the full path in your connection string, even if it's in the same directory.

 

if DB in the /admin/ same folder then you may use
Data Source = /db.mdb
or
Data Source = db.mdb

else in a different folder then you may try
Data Source = ../otherfolder/db.mdb

 

Is the problem solved?

 

No, Still not.
Waiting that some one will help me in this digital discussion forum.

 

<%
Conn = "Provider=Microsoft.JET.OLEDB.4.0; Data Source ="& pathChangeAnyTime & "db.mdb"
%>


Did you really move your access database file to the place it shall be?

 

Try using the absolute path instead of the relative path. I had similar problem and changing to absolute path worked for me.

Regards,
UrStop

 

could you guide me how can i make absolute path?

 

absolute path will be somethig like c:\foldername\foldername\msaccesss.mdb

You can do a response.write with the mappath method of ASP to get the absolute path and then use it in the connection string.

 

You have to use Server.Mappath ie physical path for accessing DB not virtual path. Are u using that??

 

as it seems, this problem has been solved...
checked the url,
can login with admin/admin...
even due you cant add a user since the db seems to be read only.
gl then.