2. ASPRunnerPro General questions
  3. Connection Problem
This topic is locked

Connection Problem

 		6/6/2005 16:40:12
ASPRunnerPro General questions
bobvance author

Just tried the demo version, connecting to an excel spreadsheet. Project ran fine on my PC, but get the error message above when I run it on the web. Any ideas?
Sergey Kornilov admin 6/7/2005

Hi,
could you post here the full error message and dbconnection string from include/dbconnection.asp file?
bobvance author 6/7/2005

Your product looks great... hope I am able to get it to work! Thanks
Error:
ADODB.Connection.1 error '800a0bb9'
The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.
/presentation_db/login.asp, line 68
dbconnection file:
<%

strConnection = "Provider=MSDataShape;DRIVER={Microsoft Excel Driver (*.xls)};DBQ=" & server.mappath("db\clients.xls") & ";UID=;PWD=;Readonly=False;"

%>
Sergey Kornilov admin 6/7/2005

Hi,
please download and use new version of ASPRunner Pro

here.
Also make sure you use Windows based web server.
bobvance author 6/7/2005

Just downloaded the beta version, re-built the project, uploaded via FTP, but still get the same error message. How do I determine if my site (www.febg.com) is on a windows based server?
If I find that it is not windows-based, can't I use your product with a mySQL database on my website?
Thanks
Sergey Kornilov admin 6/8/2005

Hi,
I found that www.febg.com is Unix-based.
To check this you can proceed to http://www.xlinesoft.com/selector3.asp, enter your website address and click button with arrow.
I would recommend you to try our another product PHPRunner which is perfect for creating PHP+MySQL websites. Here is the link to the latest version.
Also you can use ASPRunner to build ASP+MySQL interface.