|
livvy38
Starting Member
10 Posts |
 Posted - 29 July 2005 : 21:52:54
|
Hello. I'm in the process of moving my Snitz Forums 3.4.04 from one SQL Server to another SQL Server (different web site hosts).
I'm using Enterprise Manager and can connect to my database without any issues. I've created my database and set the user to access the database.
I am, hoever, having problems connecting to SQL Server through my web site. I have exported my data from the old server and I need to set up the tables again on the new server. No matter which connection string I use (ODBC, OLEDB, or DSN) I receive an error stating that the login failed or [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.
I've tried the following connection three strings and received the above error.
strConnString = "Provider=SQLOLEDB;Data
Source=SERVER_NAME;database=SNITZ_DB;uid=snitz_forum;pwd=snitz_forum;" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)
strConnString = "driver={SQL
Server};server=SERVER_IP_ADDRESS;uid=snitz_forum;pwd=snitz_forum;database=SNITZ_DB" '## MS SQL Server 6.x/7.x/2000 (ODBC connection)
strConnString = "SNITZ_DB" '## DSN
Does anyone have any suggestions as to what I might try next? I have emailed the host but haven't received a response yet.
Thanks in advance for your help.
Andrea |
|
Topic Locked
