Solved

Trouble setting up an ODBC Connection

Posted on 2004-09-28
2
814 Views
Last Modified: 2008-01-09
I'm back experts

I have access right to a sql server database.  I can connect to it fine via ado and in sql enterprise manager.

I set up the connection (selecting the option to change the  default database to: (from master to CSSD)) I get this:

Microsoft SQL Server ODBC Driver Version 03.85.1117

Data Source Name: Intranet
Data Source Description:
Server: appalachian\intrasql1
Database: CSSD
Language: (Default)
Translate Character Data: Yes
Log Long Running Queries: No
Log Driver Statistics: No
Use Integrated Security: No
Use Regional Settings: No
Prepared Statements Option: Drop temporary procedures on disconnect
Use Failover Server: No
Use ANSI Quoted Identifiers: Yes
Use ANSI Null, Paddings and Warnings: Yes
Data Encryption: No

However when I go test odcb connection I get the follwing error:

Microsoft SQL Server ODBC Driver Version 03.85.1117

Running connectivity tests...

Attempting connection
Connection established
Verifying option settings
[Microsoft][ODBC SQL Server Driver][SQL Server]SELECT permission denied on object 'syscharsets', database 'master', owner 'dbo'.
Disconnecting from server

TESTS FAILED!

HELP!



0
Comment
Question by:dtolo
2 Comments
 
LVL 4

Accepted Solution

by:
roshkm earned 500 total points
Comment Utility
Hi there,

Please do check whether the login you have used is having the right privilege to execute select query. If possible, try with login 'sa'. You wont be getting any prob with permissions.

Again, do confirm that you have selected the tcp/ip in client configuration (i know that this is not the issue but still)

cheers,
RKM
0
 
LVL 2

Author Comment

by:dtolo
Comment Utility
Aparently I had to Ignore the test error.  It's because I don't have access to "Master"
database which is where it's trying to get some data from.  The connection
still works.
0

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now