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?

 

Thanks

Andy

Link to post
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 post
Share on other sites
×
×
  • Create New...