Super User
Super User

Questions tagged [dsn]

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.

Note that DSN also stands for Defense Switched Network, a sortof proprietary version of PSTN for United States military bases. Questions about this DSN should not use this tag.

18 questions
7
votes
2 answers

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 domain users on the same computer at different…
waldrumpus
  • 599
5
votes
2 answers

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 Control Panel. I need to do the same in Windows 7…
GiddyUpHorsey
  • 568
2
votes
1 answer

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-Bit OS). How to check, which architecture which…
BendEg
  • 141
1
vote
1 answer

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 get the following…
Ivan
  • 2,364
1
vote
1 answer

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 2007.
waanders
  • 293
1
vote
2 answers

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=DBNAME"} I need to create it with an specific option,…
Bernat
  • 13
1
vote
2 answers

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 retrieve data. These work fine on 32bit and 64bit…
Kristiaan
  • 209
1
vote
1 answer

InstallAnywhere issue: This application has unexpectely quit

I have downloaded IBM Client SDK 4.10 FC5DE for Windows x64. When I proceed to install it, InstallAnyWhere popups saying "Preparing installation files...". When it reaches to 100% below error is shown and installation terminates: This application…
Willy
  • 235
1
vote
0 answers

How to use an ODBC file source (.DSN) to export to excel with defined location but no defined filename, bringing up "select workbook"

How can I set up a DSN to direct to a specific location, but then allow me to select the file rather than writing to a specific file. [ODBC] DRIVER=Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm,…
Some_Guy
  • 794
0
votes
0 answers

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, and SQL server sends various responses into each…
arch-abit
  • 465
0
votes
1 answer

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 is hosted at localhost (127.0.0.1). I have R scripts…
Jubbles
  • 105
0
votes
2 answers

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 spreadsheet as the source and click on the "Select…
Al Qadi
  • 1
0
votes
2 answers

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 in OraClient11g_home1"). The problem, though, is…
Kevin
  • 165
0
votes
1 answer

Is it possible to port User DSN's from one laptop to another?

My company sent laptop upgrades to some employees. I have some User DSN's on my old laptop that I need to move to the new one. They are DB2 DSNs, and it looks like the old driver is 1111_64R1 and the new one is 1155_64. I copied the db2cli.ini…
Johnny Bones
  • 709
0
votes
1 answer

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 J normally, but not when coming in through…
MPelletier
  • 824
1
2