<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=1708&image=1&table=forumtopics' class='bbc_emoticon' alt=':(' /> Hi
Can anyone help with this.
This error seems to be quite common. However I only get it when searching.
The exact error is:
Technical information
Error number -2147467259
Error description [Microsoft][ODBC Excel Driver] Unknown
URL /Sheet1$_list.asp
SQL query select [Reference], [Document Name], [Description], [Location], [Approved], [Internal], [External] From [Sheet1$] where 1=0 or Reference like '%psg0004%' or [Document Name] like '%psg0004%' or Description like '%psg0004%' or Location like '%psg0004%' or Approved like '%psg0004%' or Internal like '%psg0004%' or External like '%psg0004%'
After looking thru the message boards it appears it maybe the connection string?
My connection script in the include/..dbfile is:
<%
strConnection = "Provider=MSDataShape;DBQ=" & server.mappath("db\PSGDocumentCentre[1].xls") & ";Driver={Microsoft Excel Driver (*.xls)};DriverId=790;MaxBufferSize=2048;PageTimeout=5;UID=admin;"
%>
Any help would be much appreciated. I cant search my data at the moment.
Cheers.
