ODBC Error

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

I am setting this up with the Product Management plugin, I have a SQL database named Products, I have given rights to a specific user group, and I have set up the DSN I believe correctly. But I 

keep getting this error.

Could not open data connection. Error:

[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login 'Products'. Login fails.

The Invalid ConnectionString is defined as: DSN=Products; 

Any suggestions???

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
ShaneS Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: January/03/07 Location: United States Status: Offline Points: 9	Post Options Post Reply Quote ShaneS Report Post Thanks(0) Quote Reply Topic: ODBC Error Posted: January/24/07 at 1:50pm
	I am setting this up with the Product Management plugin, I have a SQL database named Products, I have given rights to a specific user group, and I have set up the DSN I believe correctly. But I keep getting this error. Could not open data connection. Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login 'Products'. Login fails. The Invalid ConnectionString is defined as: DSN=Products; Any suggestions???

admin Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Forum Administrator Joined: March/11/04 Status: Offline Points: 329	Post Options Post Reply Quote admin Report Post Thanks(0) Quote Reply Posted: January/25/07 at 10:05am
	No, this means you have not set it up correctly. Most likely the problem is on the DSN side which you may or may not even be able to see. 1. I wouldn't call my DSN, Products. Its just too generic and theres a chance someone would step on it or you stepped on someone elses. Call it ShanesProducts or something less generic. 2.The error is it can't open the database with that DSN. Typically for SQL, I would suggest a DSN-Less, direct driver approach. Take a look at this website...I just recently found it and its excellent. http://www.connectionstrings.com/ More specifically for what your trying to do: http://www.connectionstrings.com/?carrier=sqlserver I would use something more like this in place of DSN=Products; : Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Uid=myUse rname;Pwd=myPassword;