SQL Server

[bcandy]

Sorry I?m not hot on SQL Server setup. I need to use SQL Server on my website, but also need to access it from a VB app. Do I need to setup a fixed IP to my SQL Database? Or is there a different technique for doing this?

Thanks in advance.

Brian Candy

 

[hatton]

Sorry I?m not hot on SQL Server setup. I need to use SQL Server on my website, but also need to access it from a VB app. Do I need to setup a fixed IP to my SQL Database? Or is there a different technique for doing this?

Thanks in advance.

Brian Candy

Theoretically you should be able to have your VB application point to an ODBC DSN on the computer that is running it, then point the DSN to the domain of the MSSQL servers running here at JodoHost.

However, I'm not a VB person so that's only a guess!

 

[Yash]

No, you wouldn't need a dedicated ip for that. Just use the mssql host name, username and password