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

Error Message

 		12/29/2004 1:44:42 AM
ASPRunnerPro General questions
author

I received the following error message: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
I'm new to ASP and SQL. Any help would be appreciated.
Thanks
Sergey Kornilov admin 12/29/2004

Hi,
what database do you use?
Please post your connection string that can be found in include/..._dbconnection.asp file.
501121 12/31/2004

Thanks for your reply. The database I'm using is an Excel xls spreadsheet.
Here is the connection string you requested:
strConnection = "Provider=MSDataShape;DBQ=C:\DOCUMENTS AND SETTINGS\STEVEJ\MY DOCUMENTS;DefaultDir=C:\DOCUMENTS AND SETTINGS\STEVEJ\MY DOCUMENTS;Driver={Microsoft Text Driver (.txt; .csv)};DriverId=27;Extensions=txt,csv,tab,asc;FIL=text;MaxBufferSize=2048;MaxSc

anRows=25;PageTimeout=5;SafeTransactions=0;Threads=3;UID=admin;UserCommitSync=Yes

;"
Thanks for the assistance.