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
2
votes
0 answers

Company ID not found issue occurs while connecting QuickBooks online ODBC driver

I have installed the trial version of the QuickBooks Online ODBC (QODBC) and configured the DSN named “QuickBooks Online Data” as well as "QuickBooks Online Data QRemote" I have ensured both the connection using the test tool and I am able to…
Janakiraman
  • 121
  • 4
2
votes
2 answers

How do I install an ODBC driver using C# during my apllication setup?

I am making an application using c#.net. The application relies on a PostgrSQL ODBC driver and therefore has to check if the driver has already been installed on the user’s computer. If not the ODBC driver has to be installed during my applications…
Peter
  • 71
  • 1
  • 6
2
votes
1 answer

DSN Util C#(Won't create)

I was following this other post --> C# DSN Util So I have the following code. (Slightly Modified) OdbcConnection DbConnection = null; try { DbConnection = new OdbcConnection( …
sealz
  • 5,348
  • 5
  • 40
  • 70
2
votes
1 answer

How do you correctly set DSN? [ERR: No DNSKEY records found ; The CNAME RRset was not signed by any keys in the chain-of-trust]

I successfully deployed my project on Heroku. The problems occurred when I wanted to set a custom domain for it (bought namecheap.com). In neither Heroku nor Namecheap I get an error. Everything is correct, but somehow I cannot reach the page, and…
Marc Abdel Wahed
  • 53
  • 7
2
votes
0 answers

difference between server and DSN in RDOBC package

I'm trying to connect to a MS SQL database via RODBC package. The following is not working : ch = odbcDriverConnect(paste0("Driver=MSODBC;DSN=D.ad009.win.org;database=LCA;UID=LCA-User;PWD=xxxx")) Warning messages: 1: In…
Haribo
  • 2,071
  • 17
  • 37
2
votes
1 answer

Should I place a DSN (datasource) definition inside or outside onApplicationStart() function?

When is it appropriate to place DSN definitions inside the onApplicationStart() function vs outside of the function? I have seen this method:
Millhorn
  • 2,953
  • 7
  • 39
  • 77
2
votes
1 answer

Connect to ONLINE MySQL database using DSN ODBC

I am connecting an online MySQL database. I have downloaded MySQL ODBC Connector 5.1. Now am trying to setup the DSN. But am getting the error: Connection Failed : [HY000] [MySQL] [ODBC 5.1 Driver]Access Denied for user 'user123'@'myweb.com' I…
sqlchild
  • 8,754
  • 28
  • 105
  • 167
2
votes
2 answers

Is this a Microsoft or an Oracle Problem?

In my original thread here: How can I fix ORA: 01013 (user requested cancel...) when trying to link Oracle tables in MS Access? I describe an issue attempting to link Oracle tables into a Microsoft Access (office 365) database. The process timed…
Arlie
  • 31
  • 7
2
votes
2 answers

Case Sensitivity Of Datasource Names

All, I Have a small confusion about Case sensitivity of ODBC DSN names. Say, you have configured a DSN in your machine with lower case "serverabcd" but in the web.config it's written in upper case "SERVERABCD". Does that make for a problem OR does…
Rahul
  • 76,197
  • 13
  • 71
  • 125
2
votes
1 answer

dsn for ms access 2003 in windows 7

I am trying to create a dsn for ms access in windows 7. But its showing: "The setup routines for the Microsoft Access Driver(*.mdb) ODBC driver could not be found.Please reinstall the driver. " and "Error found: The specified DSN contains an…
bsm
  • 1,793
  • 11
  • 30
  • 41
2
votes
3 answers

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
  • 9,848
  • 22
  • 141
  • 284
2
votes
1 answer

DSN Less Connection (MS Access to SQL2016)

I have this solution that works when I want to convert linked tables to a DSNLess Connection: http://www.accessmvp.com/DJSteele/DSNLessLinks.html But it's always been an Access DB (2010 or 2013) to SQL2012. I now have a SQL2016 instance that I'm…
Bill Schanks
  • 143
  • 1
  • 4
  • 14
2
votes
3 answers

yii2 change database dynamically

I'm trying to move to another database dynamically. I've seen several questions that showed change db files from one to another and they just getting some information from next database. But what I need is completely moving to second database. How…
Scott
  • 4,974
  • 6
  • 35
  • 62
2
votes
1 answer

connection string for classic asp application using odbc 11 for sql server

We have a classic asp application, we lost connection with the database. In application server we are able to connect to database only through odbc driver 11 for sql server. Have tried other native client drivers to establish connection which…
Sireesha
  • 31
  • 1
  • 6
2
votes
1 answer

How can I specify the port number with DBD::ODBC?

I currently use the following code to connect to a database in my Perl script: my $dsn = 'dbi:ODBC:MYDATABASE'; my $database = 'uat_env'; my $user = 'user'; my $auth = 'password'; my $dbh = DBI->connect($dsn, $user, $auth, { RaiseError => 1, …
j1nrg
  • 116
  • 14
1 2 3
…
25 26