Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Trouble setting up an ODBC Connection

Posted on 2004-09-28
2
Medium Priority
?
856 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 1500 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

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

610 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