Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 864
  • Last Modified:

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!



0
dtolo
Asked:
dtolo
1 Solution
 
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now