http://forum.salescart.com/forum/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Tue, 21 Apr 2026 15:43:19 +0000 Thu, 25 Jan 2007 10:05:39 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 11.04 360 forum.salescart.com/forum/RSS_post_feed.asp?TID=672 http://forum.salescart.com/forum/forum_images/web_wiz_forums.png http://forum.salescart.com/forum/ http://forum.salescart.com/forum/forum_posts.asp?TID=672&PID=2380&title=odbc-error#2380 Author: admin
Subject: 672
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;

]]> Thu, 25 Jan 2007 10:05:39 +0000 http://forum.salescart.com/forum/forum_posts.asp?TID=672&PID=2380&title=odbc-error#2380 http://forum.salescart.com/forum/forum_posts.asp?TID=672&PID=2377&title=odbc-error#2377 Author: ShaneS
Subject: 672
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???
]]> Wed, 24 Jan 2007 13:50:42 +0000 http://forum.salescart.com/forum/forum_posts.asp?TID=672&PID=2377&title=odbc-error#2377