2. ASPRunnerPro General questions
  3. asp web server
This topic is locked

asp web server

 		6/5/2008 6:38:40 AM
ASPRunnerPro General questions
A
 actros author

Hello, i am new in forum and i want to ask somethink.

I download the asprunnerpro and i made a asp site with my database and it work fine in my IIS server in my local pc,

but when i upload my site to a asp web server like (titanichost,...) didnt work.

I make some chanches with the server map path but nothing, didnt work but ather asp site who i made (without asprunner)

work in that server.

Is possible to work and how?

Thanks.
J
 		Jane 6/5/2008

Hi,
please send a detailed description of what does not work, all error messages to support@xlinesoft.com.
A
 		actros author 6/5/2008

First when i put the test.asp page from your site to nofeehost return : D:\content\users1\actros

I upload my files to web and the error who return is:

----------------------

<% strConnection = "DBQ=" & server.mappath("db\Northwind.mdb") & ";Driver={Microsoft Access Driver (.mdb)};DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;" %>

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/actros/include/dbcommon.asp, line 117

------------------------------------

i look in the dbcommon.asp line 117 and the problem is to open the database

i go to include folder dbconnection.asp file and i change the path as :actros\db\Northwind.mdb

because the site say in the fag :

How do I connect to my MS Access database?

Make sure your database is in the "db" directory in your file space.

Here is a sample ASP code to connect to a MS Access database.

Dim Conn

Set Conn = Server.CreateObject("ADODB.Connection")

strConnection = "DRIVER=Microsoft Access Driver(.mdb);DBQ=" & Server.MapPath("/USERNAME/db/yourdatabase.mdb")

oConn.Open(strConnection)

....

...

oConn.Close
and return the same error:
<% strConnection = "DBQ=" & server.mappath("actros\db\Northwind.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;" %>

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/actros/include/dbcommon.asp, line 117

-----------------------------------------

i try to change the "\" with "/" as: actros/db/Northwind.mdb

but nothing

is it possible to work?
S
 		semleon 6/12/2008

I could be way off here, but just a thought:

  1. Have you verified that the db is on the server and accessable?
  2. Do you have an ODBC to that db built on the Server? (Check your odbc connections on the server and test them)