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
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
  • 23,658
  • 51
  • 191
  • 321
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
  • 27,229
  • 33
  • 143
  • 254
6
votes
2 answers

Creating a DSN-less connection for MS Access within Java

I'm building a desktop app that needs to communicate with a MS Access database. Now, unless I want to register the DSN for the database on every computer that's going to use the desktop app, I need a way to connect to the database in a DSN-less…
Soroush Hakami
  • 5,226
  • 15
  • 66
  • 99
6
votes
2 answers

SSRS - Excel data source error when report deployed to localhost report server

I need help with an SSRS report deployed to localhost which uses ODBC data source to retrieve data from excel file. When the same report is previewed through BIDS 2008, it displays the results as expected. But after deploying the report to the…
Romanshu Goel
  • 103
  • 3
  • 9
5
votes
4 answers

Host...not allowed error in ODBC connection, while connecting to 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]Host '117.x.x.x' is not allowed to connect to this MySQL server My server url is…
sqlchild
  • 8,754
  • 28
  • 105
  • 167
5
votes
2 answers

Is it possible to use (fluent)nhibernate with an odbc connection?

i have to use a custom odbc driver. All i need to pass as a connection string is the DSN. How do i do this with (fluent)nhibernate? FluentNHibernate.Cfg.Db does only offer a OdbcConnectionStringBuilder class with an DSN method. How do i use this?
mrt181
  • 5,080
  • 8
  • 66
  • 86
5
votes
1 answer

How to safely identify a DSN (delivery status notification) message

I'm fetching emails from a POP3 server and I'd like to make a difference between a regular email and DSN (Delivery Status Notification) / NDR (Non-Delivery Report/Receipt) messages. What is the best/safest way to identify those messages? Are there…
Mats
  • 14,902
  • 33
  • 78
  • 110
5
votes
2 answers

Programatically create ODBC connection and link tables in MS Access

We are using MS Access as a reporting front-end for Oracle. The data is accessed via an ODBC connection, and there are two linked tables in Access to Oracle that are the raw data tables. I'd like to be able to set up the connection and link the…
FrustratedWithFormsDesigner
  • 26,726
  • 31
  • 139
  • 202
5
votes
1 answer

Connecting to ODBC using pyODBC

I've read all the faq pages from the python odbc library as well as other examples and managed to connect to the DSN, using the following code: cnxn = pyodbc.connect("DSN=DSNNAME") cursor = cnxn.cursor() cursor.tables() rows = cursor.fetchall() for…
jenryb
  • 2,017
  • 12
  • 35
  • 72
5
votes
3 answers

Powershell to read from database using ODBC DSN instead of connection string

I know how to read value from database using connectionstring, i.e. Establish database connection to read $conn = New-Object System.Data.SqlClient.SqlConnection $conn.ConnectionString = "Server=10.10.10.10;Initial Catalog=database_name;User…
Glowie
  • 2,271
  • 21
  • 60
  • 104
5
votes
3 answers

Enumerating the list of DSN's set up on a computer

I have an Excel application in which I want to present the user with a list of the Data Source Names (ie: DSN's), whereby s/he can choose what data source to use. Hopefully once I've got the list, I can easily access the DSN properties to connect to…
AR.
  • 39,615
  • 9
  • 44
  • 52
5
votes
2 answers

Need to Identify the Database name in an ODBC DSN connected application

I have a Delphi 6 application that uses an ODBC DSN to connect to target databases. I want to include text that lists the name of the Database the DSN is connected to. I tried using the SQL command db_name() but only received a nil in response…
ChargerIIC
  • 1,620
  • 1
  • 33
  • 47
5
votes
2 answers

setting up dsn for a sql server express database

How do i set up a system dsn for a 64 bit sql server express 2008 R2 that is installed on the local machine? I go to add a system dsn and select sql server native client 10 and follow the wizard. However on the dropdown that asks which sql server to…
cableload
  • 4,215
  • 5
  • 36
  • 62
4
votes
2 answers

VBA/MySQL issue using ODBC connector

I have been struggling with this for a few days now. Any help much appreciated. Trying to connect to MySQL database using Excel VBA, on a PC with the following: Excel 2007 Windows 7 x64 Home Premium MySQL 5.5 MySQL ODBC Connector 5.1, 64 bit In the…
ploddingOn
  • 123
  • 1
  • 4
  • 12
4
votes
1 answer

PHP MySQL DSN Connections - How to enable mysql://

How do I enable this type of command on a mysql server and what is it? I see it client code: //$dsn = "mysql://root@localhost/username"; //$dsn = "mysql://admin@999.69.205.174/pass"; Normally I would…
TheBlackBenzKid
  • 26,324
  • 41
  • 139
  • 209
1
2
3
…
25 26