classic asp connecting to access database, file not found -


I have to work in a classic ASP for a small job. I'm trying to get a site that runs on my computer to test. I am running Windows 7 and IIS 7.

I get an error when I run from the local host and check the log: 80004005 | I_not_find_file_'c: \ inetpub \ wwwroot \ sc \ website \ data \ si.mdb '

My code is such

  dim objConn dim objRS objConn = set server CreateObject ("ADODB.Connection") objConn.Provider = "Microsoft.Jet.OLEDB.4.0" set objRS = Server.CreateObject objConn.Open ("c: / inetpub / wwwroot / sc / website / Data / si.mdb ")  

This is the correct path of the file however. Anyone know how can I reach it? Is the code wrong or do IIS settings need to be set up?

I do not have any version of the office installed, will this create a problem?

I have not done many different paths and provider settings but none.

Edit code, in fact there was no connection string description in the code, but that person said that it still works

He does not remember the establishment of his friend, but he said, "What do I remember from seeing him, he was connected to the database through the data sources (ODBC) because it's someone in the code as you The direct path is not as a 'world' Using some '(does not know the correct word). "

" post-text "itemprop =" text ">

You can actually try to see who The C file is not found or it is due to the issue of any permission.

In addition to this, although the use of slash rather than backslaces is not usually a problem, you would like to try C. If there is a problem, then there is a difference in case.

If you are using a x64 version of the window, then the jet is not supported in this mode, however you can get it around it. To do this, run the following on the command line:

  set cscript.exe adsutil.vbs W3SVC / AppPools / Enable32BitAppOnWin64 "true" iisreset  

second command May not be required, but I think that before this change is effective, you will need to restart the IIS.

It seems that the code was previously set to use the global DSN, hence the lack of a path in the connection string, although there should still be any type of connection details (such as the DSN name).


Comments

Popular posts from this blog

c# - ListView onScroll event -

PHP - get image from byte array -

Linux Terminal Problem with Non-Canonical Terminal I/O app -