Import from Sql Server
 

Hello There

I'm looking for help concerning the *connection string* which I need to
connect to the Sql Server.

I'm writting a web-based .net application and I use Excel on the server
to generate some reports. I write the code in C# and added the excel
library so that I can communicate with Excel.


WHAT I DO:
Programmatically, I defining a QueryTable with the necessary query and
connection string. It works quite well. The connection string was:

"ODBC;Driver=SQL Server;server=computername; database=dbname;
uid=username; pwd=password;"

Unfortunately some queries create temporary tables and exactly those
queries are not working... I guess it could be that the ODBC doesn't
support those temporary tables.

Solution: I tried to use a different sql provider, but it's not
working. So, could somebody help me with the connection string. Which
provider are supported by the Excel QueryTables?

Thanks a lot for your help!

PS: I know, it would be good not using temporary tables. But the
queries are coming from external sources...


--
RedSnowRider
------------------------------------------------------------------------
RedSnowRider's Profile: http://www.excelforum.com/member.php...o&userid=32182
View this thread: http://www.excelforum.com/showthread...hreadid=519289