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

Perl DBI Connection Inconsistencies

Background I am working on a project than involves the retrieval of data from two difference databases. One of the databases is using a Microsoft SQL database engine and the other is running a MySQL engine. I need an easy way to specify the Data…
Jonathan
  • 671
  • 1
  • 8
  • 21
3
votes
2 answers

Using PDO's odbc to connect to a MSSQL server instance with Windows Authentication

I'm trying to connect to a MSSQL database using PDO with odbc. I'm aware that there's a package SqlSrv (but for some reason that package (.dll) won't load properly). So I found some documentation arguing it's also possible with PDO. In my PHP.ini…
Ben Fransen
  • 10,884
  • 18
  • 76
  • 129
3
votes
1 answer

DSN-less Connection MS Access front end and SQL server backend

I don't normally program in MS Access VBA so forgive my question if it's stupid. So I'm using MS Access 2010 as a front end and SQL Server 2014 as a backend. (I don't have a choice in frontend interface so please no suggestions on alternate…
user3003304
  • 288
  • 1
  • 6
  • 18
3
votes
2 answers

ODBC PDO returning 'No data received'

I'm using CentOS 6.5 to create a PDO ODBC connection to a Microsoft Access .mdb file through PHP. I'm using MDBTools and unixODBC. My odbcinst.ini looks like this [MDBToolsODBC] Description=MDBTools…
user1871245
3
votes
1 answer

32-bit Database Driver with 64-bit R to Query Big Data

I have a 32-bit HortonWorks Hadoop/Hive database that I'm able to query within 32-bit R using RODBC. When trying to connect to the database in 64-bit R I receive this error: [RODBC] ERROR: state IM014, code 0, message [Microsoft][ODBC Driver…
Hack-R
  • 22,422
  • 14
  • 75
  • 131
3
votes
0 answers

How to create 32 bit System DSN in Windows 7 64 bit machine using c#

I need to create 32 bit System DSN programitically in Windows 7 OS which is 64 bit. I used the following code. [DllImport("ODBCCP32.DLL", CharSet = CharSet.Unicode, SetLastError = true)] private static extern bool SQLConfigDataSource(UInt32…
K.P.
  • 105
  • 1
  • 9
3
votes
5 answers

What is the simplest, most maintainable way to create a SQL Server ODBC Data Source?

I need a programmatic way of creating a SQL Server ODBC Data Source. I can do this by directly accessing the Registry. It would be better if this could be done via an available (SQL Server/Windows) API to protect against changes in the registry keys…
Matthew Murdoch
  • 30,874
  • 30
  • 96
  • 127
3
votes
0 answers

DSN-Less connection in VBA to two different iSeries LPARS generates Error 3011 to one of them

This question is not about dsn-less connection strings in MS Access per se (which I can build successfully). The following string worked just fine last week when connecting to our iSeries from MS Access 2010 on Windows 7. Over the weekend, our IT…
Mack Robers
  • 51
  • 2
3
votes
2 answers

How to connect to Sybase Server/Database without port number using DSN or RapidSQL? Or how to find port number?

I have Some Sybase Server/Databases. I know 1. Server Name 2. Database Name 3. Username 4. Password. Using this I can connect using ISQL but while using RapidSQL it asks for port. I have existing application which uses DSN, while creating DSN also…
Pritesh
  • 1,938
  • 7
  • 32
  • 46
2
votes
1 answer

Check for System DSN and create System DSN if NOT Existing (iSeries Access ODBC Driver)

can someone please help me with this? i need to check through the System DSN for my ODBC connection to the AS400 servier and create a System DSN if a particular one does not exist. i've tried googling and have not been able to find anything good for…
cookiemonsta
  • 141
  • 3
  • 10
2
votes
1 answer

WiX ODBC data source error. ODBC error 8: Invalid keyword-value pair

I am trying to establish a Data Source Name (DSN) to a SQL Server 2008 R2 database during the install process using Windows Installer XML (WiX) to install on a Windows 7 machine. I am setting two integrated security conditions from within a dialog…
PerPlexSystem
  • 704
  • 1
  • 15
  • 30
2
votes
1 answer

PEAR::Mail with DSN SMTP service

Do you know if it is posible to set a DSN communication using the Pear Mail function in PHP? Explain: If a write this code in a telnet session: telnet smtp.example.com 25 [...] mail from: me@example.com 250 2.1.0 Ok rcpt to: you@fakemail.com…
ivan_vaz
  • 110
  • 2
  • 12
2
votes
1 answer

DSN connection and password with @

I think about switching to DB access library that uses DSN connection - connect("mysql://login:password@database?options"). DSN uses @ as a separator. Does it mean that the password cannot contain @ symbol? Is there other restrictions?
Vitaly Lebedev
  • 113
  • 2
  • 3
  • 15
2
votes
1 answer

How to Create DSN in ubuntu

I want to create a DSN in Ubuntu Linux 10.10 for a Java application with a MySQL back end. Sorry if the question is simple but I really need your help. How can I create it? What are the drivers that are needed to install for the same?
Geetanjali
  • 1,043
  • 3
  • 13
  • 37
2
votes
3 answers

Excel query table still works after deleting File DSN, how is that possible?

I have an xls with a pivot table using a proc to populate it. I deleted the data connection in 'admin tools - odbc - file DSN' and it still works, how is that possible? Does that mean that the recipent doesn't have to have the file DSN present in…
adolf garlic
  • 3,034
  • 7
  • 39
  • 54
1 2 3
…
25 26