Hi I have recently upgraded one of our servers to SQL 2008 x64 however I get a connection error with my ASPrunner generated Application.
ADODB.Connection error '800a0ea9'
Provider is not specified and there is no designated default provider.
/gismo/include/dbcommon.asp, line 140
Asprunner generates this connection string
strConnection = "DRIVER=SQL Server Native Client 10.0;SERVER=XXXXXXX;Trusted_Connection=Yes;APP=Xlinesoft.com AspRunner Professional;WSID=XXXX;DATABASE=XXXXXX;"
However I have to manually change it to:
strConnection = "PROVIDER=SQLOLEDB;SERVER=XXXXXX;Trusted_Connection=Yes;APP=Xlinesoft.com AspRunner Professional;WSID=XXXXXX;DATABASE=XXXXXX;"
for my application to work.
How do I get it to work with the Native driver?