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.

Filter by
Sorted by
Tagged with
0 votes
1 answer
24 views

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 ...
Johnny Bones's user avatar
0 votes
0 answers
71 views

Is it possible to create a local data source (DSN) to my development MSSQL LocalDB instance?

A project using a legacy code library works in terms of DSN name, user, password - not an approach I'm very familiar with as a developer used to DB connection strings. For testing, I have a LocalDB ...
Mr. Boy's user avatar
  • 5,236
0 votes
2 answers
1k views

Migrating multiple User DSN connections (ODBC)

I'm looking for a way to migrate multiple User DSN connections (ODBC) from an old server to a fresh new server. In the registry i can only see the saved User DSN connections of my own user, is there ...
M. St.'s user avatar
  • 1
1 vote
1 answer
1k views

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 ...
Willy's user avatar
  • 235
1 vote
0 answers
553 views

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's user avatar
  • 754
2 votes
1 answer
778 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-...
BendEg's user avatar
  • 141
1 vote
1 answer
12k 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 ...
Ivan's user avatar
  • 2,214
0 votes
0 answers
182 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, ...
arch-abit's user avatar
  • 465
0 votes
1 answer
3k 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 ...
Jubbles's user avatar
  • 105
1 vote
1 answer
247 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 ...
waanders's user avatar
  • 285
0 votes
2 answers
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 ...
Al Qadi's user avatar
1 vote
2 answers
7k 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=...
Bernat's user avatar
  • 13
7 votes
2 answers
18k 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 ...
waldrumpus's user avatar
0 votes
0 answers
55 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 ...
shodowsjedi's user avatar
1 vote
2 answers
9k 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 ...
Kristiaan's user avatar
  • 209
5 votes
2 answers
26k 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 ...
GiddyUpHorsey's user avatar
0 votes
2 answers
3k 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 ...
Kevin's user avatar
  • 165
0 votes
1 answer
288 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 ...
MPelletier's user avatar
0 votes
2 answers
2k 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 ...
Kanini's user avatar
  • 1,102