Jump to content

Connecting to SQL Server


Recommended Posts

Using the (wonderful) UniGUI I can compile the same code into an exe and a dll just by changing one line in the project source.


So, I upload both to my virtual private server. Windows exe runs fine and connects to SQL Server on the VPS using this connection string:


Provider=SQLOLEDB;Initial Catalog=ISSYS_Live;Data Source=(local)\SQLEXPRESS;User Id=XXXXX; Password=YYYYYY;Integrated Security=SSPI;


I then install the DLL as ISAPI under IIS 7 and run under Firefox. The program works fine but the SQL connection fails.


I am missing something here. Is it:


- Something I have to configure in IIS 7

- Something in SQL Server

- Something in Windows firewall?




Link to comment
Share on other sites

Set AutoCoInitialize=True and hacked about with the connection string until this one worked using Windows Authentication


data source=.\SQLEXPRESS;Integrated Security=SSPI;


Now connected!


Thanks Farshad for your swift response.

Link to comment
Share on other sites


  • Create New...