Forum Home Forum Home > Legacy Products > SalesCart NET
  New Posts New Posts RSS Feed - ODBC Error
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Forum LockedODBC Error

 Post Reply Post Reply
Author
Message
ShaneS View Drop Down
Newbie
Newbie
Avatar

Joined: January/03/07
Location: United States
Status: Offline
Points: 9
Post Options Post Options   Thanks (0) Thanks(0)   Quote ShaneS Quote  Post ReplyReply Direct Link To This Post 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???
Back to Top
admin View Drop Down
Admin Group
Admin Group

Forum Administrator

Joined: March/11/04
Status: Offline
Points: 329
Post Options Post Options   Thanks (0) Thanks(0)   Quote admin Quote  Post ReplyReply Direct Link To This Post 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;

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 11.04
Copyright ©2001-2015 Web Wiz Ltd.

Copyright 2015 by ComCity® LLC and SalesCart™.  All Rights Reserved