Connection string works on server, not in DW!

Question

Hi!I am trying to connect to an excel sheet with a named range. I have tried every possible connection string there is. Sometimes the connection works on the server, and sometime it works in Dreamweaver CS5. But never at both server and DW. Right now I am using:"Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=C:\inetpub\wwwroot\www\malaif\db	abeller.xls;" & "Extended Properties=""Excel 8.0;HDR=Yes;"";"And the page shows up fine in IIS 7.5. In DW when i test the connection in Database/Custom Connection String (Using driver on testing server)  I get "Format of the initialization string does not conform to the OLE DB specification".Environment: IIS 7.5 on Win 7 64 bit. (defaultapp pool configured to 32bit) Page is asp VBScript.I hope someone is kind enough to give me a hand with this. This is driving me nuts!Greetings!/Richard

richnilss · Answer

Hi again!Went through a couple of strings again... This one:"Driver={Microsoft Excel Driver (*.xls)};" & "DriverId=790;" & "Dbq=C:\inetpub\wwwroot\www\malaif\db	abeller.xls;"Works on the server, in DW it says "Connection was made successfully. BUT, it doesn't show any tables. When I try to creata a recordset it says "Unable to retrieve tables from this connection, click on the 'Define...' button to test this connection." Wich off course does not work...Any ideas?Thanks in advance!/Richard

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded