Trouble setting up an ODBC Connection

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!



LVL 2
dtoloAsked:
Who is Participating?
 
roshkmCommented:
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
 
dtoloAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.