Connecting To A Remote SQL Server
This should be one of the simplist aspects to setting up my web site. However, it is turning into a compete nightmare. I have the using Dreamweaver and Asp.net book and it only goes into connecting to a local Access database.
I spent the entire day today trying to connect to an SQL Server hosted by Interland. No one there is capable of helping me with Dreamweaver. Therefore, I have decided to turn to the Internet tonight.
If someone would be so kind as to either tell me or give me a link to a site that does I would be most appreciative.
Additional notes, I am using asp.net c#. I was able to view all the databases on their server when I went throught the OLD BC. However, once I put the connection string into the main database setup screen and press test.... I get error messages.
Interland says that the SQL Server and my webserver are on two different servers. I know their has to be something I am missing in my remote folder, or something.