I am testing your product and experienced an error when I try product on our server running Windows 2000 with SP3. Have searched this forum/FAQ for error and so far nothing I saw fixed the problem. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=99&image=1&table=forumtopics' class='bbc_emoticon' alt=':o' /> Could be because I am a newbie at ASP and putting apps up on web -- so am missing something. In case this matters to ASPRunner: I recently had a vendor develop a dot-net application for our server. Most of the dot-net files are located on the web site's root directory and most use an "aspx" extension. The dot-net app works well and has no problem connecting to our MS Access 2002 database and can be seen on net by our stores over web.
To trial ASPRunner I created simple test DB with one table. After following ASPRunner's instructions in the help file and wizard, I created a special subdirectory below the web root directory called "testrun". I get this error at web page it creates:
Error: ASP error happened
Technical information
Error number -2147467259
Error description [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x248 Thread 0xcd0 DBC 0x2050014 Jet'.
URL /testrun/Stores_list.asp
SQL query select ID, Store, City, Phone From [Stores] order by [Store] asc
<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=99&image=2&table=forumtopics' class='bbc_emoticon' alt=':huh:' />
Here is the connection string -- I created a subdirectory ("testrun") one level beneath the root directory for our web site. On the server the local path to your program's created files would be: c:\extra.myname.com\site\testrun\default.asp ("extra.myname.com" being a pseudonym for our real site name).
<%
strConnection = "Provider=MSDataShape;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & server.mappath("db\testme.mdb") & ";UID=;PWD="
%>
<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=99&image=3&table=forumtopics' class='bbc_emoticon' alt=':blink:' />
In case it helps, here is the connection string used by the dot-net application: </system.web><appSettings><add key="ConnectionString" value="PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=c:\extra.myname.com\Database\otherprogram.mdb" />
I would love to be able to get ASPRunner working on our server as I have several Access databases that need to be converted to the web and your product frankly looks like a good one for that purpose (especially for a newbie).
Any help appreciated! <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=99&image=4&table=forumtopics' class='bbc_emoticon' alt=':P' />
Kel