1
vote
1answer
17 views

Report all ODBC DSN on workstations in the network

In preparation for retiring SQL Server A (2005) and deploying SQL Server B (2012), I've discovered numerous Microsoft Office assets (Excel, Access) that connect via ODBC DSNs. Is there a method to ...
0
votes
2answers
417 views

How to connect an ODBC DSN to nondefault SQL Server instance on default port?

We are migrating an SQL Server 2000 database on one server to SQL Server 2008 R2 on another server. The client application use a User DSN to connect directly to the SQL Server on the internet. I have ...
0
votes
0answers
80 views

SQL Server connection issue with ODBC Driver 11 for SQL Server

When creating a DSN's. I can create a DSN to our SQL Server (Windows Server 2003 with MS SQL Server 2005). With the SQL Server Native Client 11.0, however when i try to do the same thing with the ...
1
vote
2answers
3k views

Unable to Create System DSN

Environment: Windows 7 Professional 64-bit Operating System Problem: (ODBC Data Source Administrator) Opening Administrative Tools -> Data Sources (ODBC) -> Click "System DSN" tab. Error: ODBC ...
2
votes
1answer
87 views

Issue With Case Sensitivity on IBM Power server queries

Where I work, we have an IBM Power System that we use for data storage and access. It is currently running i OS 6.1. We have a website on an IIS server that pulls data from this server and has ...
2
votes
2answers
4k views

How to configure Windows user accounts for ODBC network with NT authentication?

I'm trying to create a connection to an SQL Server database from the ODBC Data Source Administrator using "Windows NT authentication using the network login ID". Both server and client are running ...
1
vote
0answers
171 views

ODBC DSN Authentication Options

I was wondering if besides the standard username/password ODBC authentication, other options exist to authenticate an ODBC connection using an alternate method like PKI similar to SSH. Seems like a ...
0
votes
3answers
2k views

DSN, ODBC: How to create DSN using different windows account

Is there a possibility to create DSN (ODBC to SQL Server) using different Windows account than current coputer login account? I’m trying to create System DSN to SQL Server and I would like to create ...
3
votes
3answers
3k views

ODBC: trouble removing system DSN

I have a colleague who has two DSNs with the same name - one's a user DSN and the other, a system one. He removed the user DSN but can't remove the system DSN in ODBCad32 Anybody encountered this ...