Solved

Trouble setting up an ODBC Connection

Posted on 2004-09-28
2
839 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 4

Accepted Solution

by:
roshkm earned 500 total points
ID: 12170912
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
ID: 12171094
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

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

726 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