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
45 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
940 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
87 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
1k 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 ...
0
votes
2answers
2k views

System DSN command prompt

I can create a System DSN connection via the following command: odbcconf.exe /a {CONFIGSYSDSN "SQL Server" ...
6
votes
2answers
6k 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
35 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 ...
0
votes
1answer
5k views

MS Excel 2010 - Using DSN + 32 bit drivers

I need some advice as im 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 DSN file to connect to data sources to ...
3
votes
2answers
9k 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
180 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
986 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 ...