Get ready for BLACK FRIDAY shopping starting in

Forums

This topic is locked

Site works locally but not on other systems?

Posted 20 Mar 2002 17:34:56
1
has voted
20 Mar 2002 17:34:56 Tom Devins posted:
Hi,

I've set up a site that hits an Access database to display records. I've used UD for the display pages (limit records, recordset nav, etc).

Anyway, it seems to work ok on the computer I built it on, but when I zip a copy and send it to my home computer and copy the folder in my InetPub wwwroot directory I maybe get one search result at best (first page of records) ... as soon as I try to see say records 10 - 20 it breaks down.

My past experience with ASP driven sites (hand coding), all I had to do was keep the directory structure in tact and it would work on any Microsoft box. What's happening here that's causing me problems?

Any advice, suggestions would be very much appreciated.

Thanks.

PS: I've included a couple of errors I've received below. I believe the second error tells me I have to set up the database for system ODBC but even when I do that I get errors. As long as the database is recognized shouldn't the DSN work?

*********************************************
ERROR1 -

Error Type:
Provider (0x80004005)
Unspecified error
/TestFolder/search_acc_main2.asp, line 5


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; Q312461)

Page:
POST 61 bytes to /TestFolder/search_acc_main2.asp

POST Data:
accomm=All&region=All&firstquery=true&submitButtonName=Search

Time:
Tuesday, March 19, 2002, 10:28:26 PM

ERROR2-
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/TestFolder/search_acc_main2.asp, line 5


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; Q312461)

Page:
POST 61 bytes to /TestFolder/search_acc_main2.asp

POST Data:
accomm=All&region=All&firstquery=true&submitButtonName=Search

Time:
Tuesday, March 19, 2002, 10:10:54 PM


More information:
********************************************

Replies

Replied 21 Mar 2002 04:45:14
21 Mar 2002 04:45:14 Michael Rudge replied:
do you have the access ODBC drivers setup correctly? It appears to be looking for a DSN name that has to be setup. In win2k and XP it is in the admin tools. Are you sure that you are getting a connection to your DB? UD will let you test it
?

Michael Rudge

Reply to this topic