I have a web site that I'm writing for a client but am thus far unable to connect to the server via my ASP pages. All the information I can get from the help center at the hosting provider is the DSN, IP address, Username, Password, and the database name. I've been to connectionstrings.com, which is a pretty useful site, and have attempted to use the available resources but to no avail. Here is the connection string I'm currently using, Sub ConnDB() Set DataConn = Server.CreateObject("ADODB.Connection") DataConn.Open "Provider=sqloledb;Data Source=190.190.200.100,1433; Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;" End Sub
Any help with this would be greatly appreciated. Cheers :beer:
An American football fan - Go Seahawks! Lil Turtle