My site works ok locally, then, on the live server i get this error as soon as it even thinks about connecting to the database...


-----MY ERROR------------------------------

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x1058 Thread 0xefc DBC 0x2472004 Jet'.

/asp-scripting/kidsprints/gallery.asp, line 5

-----END OF MY ERROR----------------------

line 5 is marked ***...

@LANGUAGE="VBSCRIPT"
<!--#include file="Connections/kidspix.asp" -->
<aspcode%
set rsPictures = Server.CreateObject("ADODB.Recordset"
***rsPictures.ActiveConnection = MM_kidspix_STRING
rsPictures.Source = "SELECT * FROM qryPictures"
rsPictures.CursorType = 0
rsPictures.CursorLocation = 2
rsPictures.LockType = 3
rsPictures.Open()
rsPictures_numRows = 0
%aspcode>

My connection string is correct.

Could it be anything to do with directory permissions on the server???

Help would be appreciated.

TIA
Leed.



Edited by - leed on 25 Feb 2002 11:07:31

Hello Leed,

Normally i have to ask the people where i host my site to set up a ODBC-connection, like you did your self when you hosted it locally... so give them a call or send them an e-mail to say where your database is and what the name is for the connection string so they can setup this stuff for you...

Let me know how it worked out...