2. ASPRunnerPro General questions
  3. ASP Error
This topic is locked

ASP Error

 		9/10/2011 11:20:17 AM
ASPRunnerPro General questions
B
 BCHESKIS author

I wonder if anyone has experienced a similar issue.....been searching for a solution for some time....

I'm migrading an old ASPrunner designed application to a new server.

Old server: Windows 2003/MySql 4

New Server: Windows 2008 r2/MySql 5.5
In the application all the pages that I designed using dreamweaver work just fine...however all the pages that I designed using ASPrunner (with the exception of the login page) gives me the error bellow.
I suspect that something inside the aspfunctions.asp page simply will not work with windows 2008 r2+Mysql 5.5.

Any one?
**

ASP error happened
Technical information

Error number -2147217900

Error description Provider commands and tables are invalid in shape commands when the Data Provider is NONE.

URL /xxxx/CLIENT/ASP/RECEIVE_SHIPMENTS/order_detail_list.asp

Admin 9/10/2011

Connection string issue.
You need to see what connection string Dreamweaver generates and paste the same string to include/dbconnection.asp file.
B
 		BCHESKIS author 9/11/2011



Connection string issue.
You need to see what connection string Dreamweaver generates and paste the same string to include/dbconnection.asp file.


Thanks for the reply....connection string was my first port of call....
B
 		BCHESKIS author 9/11/2011



Thanks for the reply....connection string was my first port of call....


Found...at least part of the problem.....
In the old server I had this as part of the connection string: Provider=MSDataShape

In the new server it produces the error above (no idea why...)

Once removed....the pages will produce the usually easier error to deal with:

"Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another."



Will keep investigating....
Admin 9/11/2011

It looks like you use quite old version of ASPRunnerPro and ASP may not be compatible with your web server. I would suggest to rebuild this app using the latest version of ASPRunnerPro to see if it makes the difference.