Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What do I need to change in order to test the ANETVBW converted northwind program with a different web server other than my default local host server?

April 26, 2017anetvbw converted Default different Northwind program Test web server

0

Posted

What do I need to change in order to test the ANETVBW converted northwind program with a different web server other than my default local host server?

1 Answer

0

Posted

You can add two statements to the Sub Main() in the \code\northwind_.vb file to change the values of svc.Url and northwindconnstr. For example, mssqlwebserver is your web server and SQL server. You just need to modify the routine Main: Sub Main() svc.Url = “http://mssqlwebserver/microtoolswebservice/microtoolsservice.asmx” northwindconnstr = “Provider=sqloledb;Data Source=(local);Initial Catalog=northwind;User Id=;Password=;Integrated Security=SSPI” Application.Run(New FormMenu) End Sub After you change the routine Main and rebuilt the project I should be able to access the SQL server’s northwind database on your mssqlwebserver from the desktop application northwind.exe.