2. ASPRunnerPro General questions
  3. ASPRunner 6.2 - SQL server access
This topic is locked

ASPRunner 6.2 - SQL server access

 		6/25/2010 4:03:20 PM
ASPRunnerPro General questions
L
 luic author

Hi,
I used ASPRunner 6.2 to create a project against a sql server 2005 db. If I use the MS SQL server as my db when I create the project, when I run the generated application, I got this error :
ADODB.Connection error '800a0e7a'
Provider cannot be found. It may not be properly installed.
/test/NCRex/output/include/dbcommon.asp, line 48
However, if I change the db source to ODBC, I can run the application. It looks like the db provider is different when choosing MS SQL.
Chris.
Sergey Kornilov admin 6/26/2010

Chris,
this may be a difference between what SQL Server providers installed on your local box and on the server.
You can either install missing provider on the server or connect to your database using ODBC connection string (via 'Connection string' connection type).