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
356 questions
40
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
  • 978
  • 1
  • 8
  • 22
21
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,062
  • 22
  • 70
  • 84
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
  • 16,386
  • 23
  • 70
  • 118
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
  • 339
  • 2
  • 3
  • 20
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
  • 2,493
  • 2
  • 22
  • 56
9
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
  • 7,964
  • 6
  • 35
  • 46
9
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
  • 567
  • 2
  • 7
  • 21
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
  • 332
  • 2
  • 16
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
  • 582
  • 2
  • 6
  • 19
7
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
  • 3,649
  • 11
  • 53
  • 111
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
  • 779
  • 5
  • 16
  • 38
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
  • 27,599
  • 40
  • 143
  • 217
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,091
  • 14
  • 39
6
votes
1 answer

How do you programmatically create a System DSN using Powershell or .NET?

How do you create a System DSN in the control panel on ones PC using Powershell or .NET?
Chad
  • 21,566
  • 46
  • 173
  • 299
6
votes
1 answer

Keyword not supported exception when attempting to use a connection string that points to a ODBC DSN

I created an ODBC DSN for my Asp.Net MVC application's database access. One of the main reasons is it makes it easy to keep database credentials (such as server address, port, username, and password) out of source control without hindering my…
KallDrexx
  • 26,119
  • 31
  • 137
  • 246
1
2 3
…
23 24