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
52
votes
5 answers

Differences Between Drivers for ODBC Drivers

I was setting up the System DSN (64 bit) for my database in SQL server 2016 with Windows 10 64 bit pro. While I was asked to choose the driver to set up a data source, there are the following selections: ODBC Driver 13 for SQL Server SQL Server SQL…
Jason
  • 1,200
  • 1
  • 10
  • 25
23
votes
2 answers

How do I create a DSN for ODBC in Linux?

I am digging around in a Linux application that supposedly uses DSNs to connet to SQL Server. The connection stopped working and I can't find the credentials that are being used (all I know is the DSN's name). I am familiar with DSNs in Windows,…
deadprogrammer
  • 11,253
  • 24
  • 74
  • 85
16
votes
1 answer

PDO returning error "could not find driver" with a known working DSN

I'm trying to connect to an odbc database via php's PDO class: $dsn = 'odbc:CS_HDZipCodes32bit'; $username = 'demo'; $password = 'skdemo!'; $connection = new PDO($dsn, $username, $password); die( var_dump( $connection ) ); but when I do, I get…
Chris Schmitz
  • 20,160
  • 30
  • 81
  • 137
14
votes
1 answer

How do I create a passthrough query in access using a DSN-less connection?

I'm using DSN-less connections to my SQL Server in an Access database. However, whenever I try to write a "Pass-Through" query and run it, a dialog box pops up asking for the DSN.
Brett G
  • 349
  • 2
  • 4
  • 20
11
votes
4 answers

Specify a default driver for ODBC

I have a legacy VB6 app which builds a DSN based on a parameter in a config file. The parameter is an ODBC connection, and the connection has a name (DSN-NAME) which maps a server (DBSERVER) to a driver ("SQL Server Native Client"). Generally, it…
crb
  • 8,132
  • 6
  • 37
  • 48
11
votes
3 answers

SQLGetInfo - How to use this function

I have developed a c# application which connects to many types of database servers like Sql,Oracle,Mysql etc..Connection was established using ODBC. I need to find the server type (DBMS type) for which the connection was established, as the user…
Dah Sra
  • 4,107
  • 3
  • 30
  • 69
11
votes
4 answers

SQLGetPrivateProfileString failed with

Typing the command: odbcinst -q -s on RHEL 6, I get the following error message: odbcinst: SQLGetPrivateProfileString failed with . All my DSN's are also not showing up when I run: odbcinst -q -d
Kapil Vyas
  • 607
  • 2
  • 8
  • 22
10
votes
4 answers

DSN to connectionstring?

We've got an ASP.NET website that uses a database that we want to be able to use a connectionstring to get to. We've successfully set up a DSN for connecting to this DB, but I can't seem to discover the correct magic to go with a…
Beska
  • 12,445
  • 14
  • 77
  • 112
8
votes
1 answer

SQL Server DSN-Less ODBC Specify 32 bit Driver

I'm working with an older application that I recently updated to .NET 4.5. The application has been using DSN ODBC connections. However, in the case of the application, it is accessed from a single location on a network drive, so it doesn't make…
Jarrod Christman
  • 380
  • 2
  • 19
8
votes
3 answers

Neither DSN nor SERVER keyword supplied

I am trying to connect to SQL database slightly different ways: with and without use of parameter. Why without use of parameters works fine, but with use of parameters - gives me an error. Did I make a syntax error? I went through each letters and…
Serdia
  • 4,242
  • 22
  • 86
  • 159
7
votes
3 answers

creating a new ODBC user DSN with Delphi

AI am trying to make a new entry in User DSN, in ODBC Data Source Administrator with the following code: procedure TForm1.FormCreate(Sender: TObject); var strAttributes: string; wideChars : array[0..1000] of WideChar; pfErrorCode: DWORD; …
dzibul
  • 612
  • 2
  • 7
  • 20
7
votes
1 answer

Set DSN encoding for ODBC Driver 11 for SQL Server on Windows 10

TL;TR How force this ODBC driver to encode in UTF-8? Detailed description I'm writing PHP 5. 5. application which connects to database Microsoft SQL Server 2014 via PDO using ODBC driver. More specifically I'm using "ODBC Driver 11 for SQL…
Daniel.P.
  • 480
  • 2
  • 8
  • 19
7
votes
2 answers

How to programmatically create an ODBC Linked Table to a SQL Server View and have it be editable?

When I create a DSN connection to SQL Server using the wizard, I am able to link it to a view. In this case, Access recognizes it as an editable table. But if I use a DSN-less connection to a view using vba code (Method 1 from…
Mike
  • 961
  • 6
  • 19
  • 43
7
votes
1 answer

Connect to MySQL database and fetch data in Julia

How can I fetch data from MySQL database in Julia? It looks like this package provides tools for connecting to any database, including MySQL. However, it looks like assuming I have to first setup ODBC DSN to connect to it (I don't know what it is in…
Blaszard
  • 30,954
  • 51
  • 153
  • 233
6
votes
2 answers

How to configure ColdFusion's ORM for multiple session scope DSNs?

How do you configure ColdFusion 9's ORM to use multiple DSNs if possible? Is is possible to setup the datasource in the context of a session scope instead of the application scope? Or how, in CF9, do you configure Hibernate to use multiple…
Micah
  • 1,221
  • 17
  • 42
1
2 3
…
25 26