RichB

Help. I am a thicko mac user. Fact.

I am trying to develop something on my PC of which I am not a complete numpty with.

I have W2K and just installed IIS.
IIS is working and serving the pages.

I have some ASP code that works on one of our live webservers but not on my local machine.

The error I get is this;
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x5f0 Thread 0x694 DBC 0x13b4194 Jet'.
/top.asp, line 5

I have just upgraded my Jet thingy (whatever the hell that is ) from a updater from a PC savvy colleague but I still get this message.

The ASP *should* handle the connections itself so I am under the impression I don't need to set up any DSNs manually, I have had this working before but have since reinstalled the OS etc.

Is there something else I am probably missing?
Why is it talking about the registry?

Any helpful comments?

SJ_Skyline

have you replicated the file / system DSN from the original machine onto the new machine?

Can you also post up line 5 of top.asp - that would give a clue as to what is happening.

[Edited by SJ_Skyline - 1/30/2004 11:26:32 AM]

RichB

I believe I do not need to manually set up a DSN if the code is written in such as way as to do it itself.

It is failing here on the line 'conn.ActiveConnection = '

<%
set conn = Server.CreateObject("ADODB.Recordset")
conn.ActiveConnection = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=C:\inetpub\mysite\data\mydb.mdb"
conn.Source = "SELECT * FROM tbl ORDER BY name ASC"
conn.CursorType = 0
conn.CursorLocation = 2
conn.LockType = 3
conn.Open()
%>

Puff The Magic Wagon!

iTrader: (2)

From google...

http://www.attention-to-details.com/...or-process.asp

RichB

Bloody hell. I hate to admit it but I had missed out the wwwroot bit from the full path.

<slopes off with tail between legs>

Thanks guys, it's always something blindly obvious

ids

Rich

Just a quick pointer that you may be aware of.... remember to keep any access databases out of the docroot that gets served by IIS, as anyone )if they knew the filename could download the db.

You could for instance put it in c:\inetpub\data. As long as IUSER_YourMachine as probably Change NTFS permissions to the folder/file then shoud still work.

Ids

RichB

thanks for the advice!