ODBC Error
Printed From: SalesCart
Category: Legacy Products
Forum Name: SalesCart NET
Forum Description: For SalesCart NET developers and designers to converse with other SalesCart NET owners
URL: http://forum.salescart.com/forum/forum_posts.asp?TID=672
Printed Date: November/23/24 at 6:42pm
Software Version: Web Wiz Forums 11.04 - http://www.webwizforums.com
Topic: ODBC Error
Posted By: ShaneS
Subject: ODBC Error
Date 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???
|
Replies:
Posted By: admin
Date 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;
|
|