In computing, a database source name (DSN, often also known as a data source name) are data structures used to describe a connection to a database.

learn more… | top users | synonyms

0
votes
0answers
51 views

ODBCAD.exe same datasource in system32 and syswow64

Currently i want to proof, which odbc data sources are configurated on a windows server 2008 R2 machine. When i open system32/odbcad32.exe and SysWow64/odbcad32.exe, they contains the same sources (64-...
0
votes
0answers
15 views

MS Access DSN Connection

We have a few end users that have a DSN connection in Access a past DBA gave to them. Now they're asking me to allow other users this same access. I'm waiting to see how they're set up but wanted to ...
1
vote
1answer
4k views

Server Admin has insufficient rights to add SYSTEM DSN. Why?

My Logon ID is in the Administrator Group for a server. Yet, when I run bring up the ODBC Data Source Administrator by launching it as the Administrator and navigate to the SYSTEM Data Source tab, I ...
0
votes
0answers
126 views

Copy Excel workbook with a pre-configured DSN to other computers

I am working on one Excel 2010 report using one workbook with a few worksheets. The first sheet has a field to enter a number and upon update it passes that number to a stored procedure in SQL server, ...
0
votes
1answer
2k views

Linux Fedora - how to create DSN of database in MySQL instance running on localhost for use by RODBC?

A few preliminaries - OS: Fedora release 16 (Verne) MySQL server version: 5.5.29 MySQL Community Server R version: 2.15.1 (2012-06-22) -- "Roasted Marshmallows" I am running a MySQL server that ...
1
vote
1answer
125 views

Can't choose MS Acess as an option for a ODBC User DSN: why?

I try to setup an User DSN using an MS Access driver, but although visible as an option in the User DSN tab I only can choose for SQL Server in the second dialog. Why? I am using Windows 7 and Access ...
0
votes
2answers
2k views

ODBC Data Source Administrator Window Crashes

I would really appreciate some help with this. Running Windows 2008 R2 EE x64 SP1 with latest updates Office 2010 X64 (verified) with latest updates When I create a System DSN with an Excel ...
1
vote
2answers
4k views

System DSN command prompt

I can create a System DSN connection via the following command: odbcconf.exe /a {CONFIGSYSDSN "SQL Server" "DSN=NAME|Description=DESCRIPTION|SERVER=MYSQLSERVER|Trusted_Connection=Yes|Database=...
6
votes
2answers
11k views

System DSN vs user DSN

Every new computer in my company undergoes the same software installation process; one program in particular needs to access a MS SQL Server database via ODBC. The program is then used by multiple ...
0
votes
0answers
42 views

Ubuntu accessing the Virtual BOX DSN

I have Ubuntu 12.04 Installed on my System and have installed Virtual box 4.1.12. and Having Windows7 running in my VBOX (Guest Addition Installed). Now I have crated the DSN on VWin7 Instance which ...
1
vote
2answers
7k views

Using DSN + 32 bit drivers

I need some advice as I'm running into a problem and so far I have been unable to find a solution. We have a set of reports developed in MS Excel that use a DSN file to connect to data sources to ...
4
votes
2answers
16k views

How do I configure ODBC DSNs in Windows Server 2003 and Windows 7?

I haven't done this in quite a while, but years ago I have set up DSNs for an ODBC connection using Windows 2000 and maybe Windows XP. I remember there being a Data Sources or ODBC icon to click in ...
0
votes
2answers
2k views

Where'd my System DSN that I just added go to?

I installed Oracle 11g on my Win 7 x64 PC. When I look in Data Sources (under Administrative Tools in the Control Panel) and click on the System DSN tab, I can see the Oracle driver listed ("Oracle ...
0
votes
1answer
203 views

What configuration for DSN access in Apache?

I am configuring a standalone Apache Http Server (2.2.16, on Windows. Can be XP or more recent) to communicate with J (standalone as in not XAMPP or other packages). I can get my list of user DSN's in ...
0
votes
2answers
1k views

Change SystemDSN to FileDSN for 100's of MS Access and Excel Files

A particular team in my office uses 100's of Microsoft Access Models. They all connect with the database using SystemDSN and, the name of the SystemDSN is hardcoded in the Microsoft Access Models. My ...