Stack Overflow
Stack Overflow

Questions tagged [dsn]

Data Source Name is used to define the connection to a data source such as a database. They are primarily used in ODBC.

Data Source Names (DSN) are data structures used in connections to databases. Such as name, directory, user information.

Three types of DSNs exist. These are:

  • User DSN
  • System DSN
  • File DSN
383 questions
0
votes
3 answers

How to Select data from Table from a DSN in T-SQL?

How can I get data from a database that I can only access through an ODBC Data Source (DSN) in T-SQL MS SQL Server, any version?
jinsungy
  • 10,717
  • 24
  • 71
  • 79
0
votes
2 answers

PostgreSQL DSN Connection string in C#

I am trying to connect PostgreSQL database to C# application. For that I have created ODBC data source, now I need the connection string to include in C#. Question: How to write DSN connection string for PostgreSQL in C#?
Sarfaraz Makandar
  • 5,933
  • 16
  • 59
  • 84
0
votes
1 answer

connect to oracledb in java

I work in a big company and need to connect to a oracle database. It is set up so that i can connect to it through DSN, but I would like to connect to the db directly. How do i do that, when the only information I have is the name of the db and the…
user284774
0
votes
1 answer

Cannot connect to FoxPro database due to architecture mismatch between Driver and Application

Getting this error message when attempting to connect to a FoxPro database via a DSN on a Windows 7 x64 PC: The specified DSN contains an architecture mismatch between the Driver and Application This project uses Visual Studio 2005. The…
JasonH
  • 589
  • 9
  • 18
0
votes
2 answers

Why is my connection not able to open? MS Access 2013

In Access 2013 VBA I am trying to open the connection: Set cn = New ADODB.Connection connectionString = "ODBC;DSN=MyDSN;Trusted_Connection=Yes;APP=Microsoft Office 2013;DATABASE=MyTest" cn.Open (connectionString) I have…
John S
  • 7,909
  • 21
  • 77
  • 145
0
votes
1 answer

How to use ODBC DataSource in CakePHP 2.4

I am newbie to cake php. How can I configure database.php in cake 2.4 with ODBC as Data Source. The DSN is pointing to Teradata.
Comrade Raj
  • 1
  • 1
0
votes
2 answers

Having Trouble with ODBC DSNs and 32 bit vs 64 bit

I am writing an application to interface with a Progress DataBase in VB.net. My development machine is a 32bit Win 7 computer. I have a System DSN configured for the database that I need to use. Since it's on a 32 bit machine its a 32 bit DSN. App…
PsychoData
  • 1,198
  • 16
  • 32
0
votes
1 answer

Create SQL Server DSN

I am needing to create a DSN through code to connect with SQL Server. I tried the example in this link, but it always fails as the dataSourceKey is never null. Does someone have a different solution or another…
MasterOfStupidQuestions
  • 925
  • 1
  • 16
  • 37
0
votes
1 answer

Is there a VB script or a bat file that I can run to list all DSN's on a machine?

What I am looking for is a simple vb script that can run and return a list of all the DSN's or ODBC connections on the local machine.
BSanders
  • 295
  • 1
  • 6
  • 29
0
votes
1 answer

ColdFusion MySQL Backup with DSN

I have ColdFusion (8) that hooks into a MySQL DB. It uses a DSN connection. I was wondering if there was a way to create a backup of the DB? It's fairly hefty at around 10Gb so was wondering if there were any extra precautions I'd need to take to…
pee2pee
  • 3,619
  • 7
  • 52
  • 133
0
votes
1 answer

why would qt still look for db string when its a dsn?

I'm trying to set up dsn with qt and i cant get it to work. The dsn does work with isql. I'm using ubuntu 12.04 POSTGRES is the dsn. connection line: QSqlDatabase db =…
Laars
  • 3
  • 1
0
votes
2 answers

How can I monitor all SQL commands that go through a ODBC User DSN

How can I monitor all SQL commands that go through a ODBC User DSN? the datasource is using the SQL Server native Client 10.0 driver. I have an access app with hundreds of confusingly complex reports. Over the last 3 years We have ported the app…
gnarbarian
  • 2,622
  • 2
  • 19
  • 25
0
votes
1 answer

how to access client machine DSN list (User or system) from asp.net web application

How can I access DSN list from client machine using ASP.Net web application? is it even possible or not? On local development server, it works fine and I can achieve it but what about live server? There are so many security concerns now a days which…
KRules
  • 1
  • 1
  • 4
0
votes
1 answer

Problems with DSN connection (Win64 app to a 32Bit Postgres Server)

I'm having trouble with the following: We have a 32bit Postgres Server here in the office. I'm developing an application in Visual Studio 2013, in a 64bits Windows 8. When I run the application, I get the following error: ERROR [IM014]…
00lenon
  • 29
  • 5
0
votes
1 answer

how to connect to the database in zend with dsn line

zend framework 1.x how to receive zend db_adapter and connect to mysql having dsn like mysql://john:pass@localhost:3306/my_db previously was always using this way: $connectParams = array('dbname' => MY_DB, 'password' => MY_PASS, …
Eugene
  • 1,680
  • 3
  • 14
  • 23
1 2 3
…
25 26