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
4
votes
1 answer

Creating Database at run time and registering it as DSN at run time

I am trying to create an ACCESS DB at run time and register is as a DSN in ODBC.ini using the following code: BOOL fCreated; fCreated = SQLConfigDataSource(NULL,ODBC_ADD_DSN, "Microsoft Access Driver (*.mdb)", …
Omayr
  • 1,949
  • 4
  • 22
  • 35
4
votes
1 answer

Connect to a System DSN via UCanAccess

I'm currently upgrading a project from Java 7 to Java 8, thus I switched from using the JDBC-ODBC Bridge to using UCanAccess. The database I want to connect to is registered as a system DSN so I connected to it like…
SimonH
  • 1,385
  • 15
  • 35
4
votes
1 answer

R: Connecting to multiple databases from R Studio

For the current project I am working, I need to pull data from 2 different databases - SQL Server and Teradata. I am using R-Studio for compilation of my queries and R-scripts I am using the following packages: RODBC, RJDBC, rJava, The…
EsBee
  • 231
  • 2
  • 13
4
votes
2 answers

DataDriven Unit Test using Excel in VS2013

I am creating Datadriven Unit(MS Unit Test) Test using Excel(*.xlsx) file as data source. it is erroring out with the following error Result Message: The unit test adapter failed to connect to the data source or to read the data. For more…
NSS
  • 1,835
  • 2
  • 29
  • 66
4
votes
2 answers

How do I connect my 32 bit app to a 64 bit System DSN?

How do I connect to a 64 bit system DSN from a 32 bit application? I get the error: ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application OdbcConnection con = new…
Pat
  • 627
  • 1
  • 9
  • 24
3
votes
1 answer

How do I remove USER DSN when they don't exist in my registry

So my computer was recently rebuilt and all my settings were re-imaged to a new computer. This meant that most drivers were not re-installed. Right now I have a bunch of USER DSN that are invalid. I cannot remove or configure them. I get the…
Jeff G
  • 33
  • 1
  • 1
  • 3
3
votes
1 answer

connect R to MySQL with RODBC using dsn

Short version: I'm trying to figure out how to use the dsn argument in the odbcConnect() function to connect to a MySQL database. Longer version: I appologize if this is an ignorant question. I didn't find an answer on SO searching under the…
gung - Reinstate Monica
  • 11,583
  • 7
  • 60
  • 79
3
votes
1 answer

Using a file DSN with JDBC

I can happily connect to a System DSN using JDBC: DriverManager.getConnection("jdbc:odbc:SysDSN"); If I try and use a File DSN however I get an error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver…
Coley
  • 707
  • 6
  • 6
3
votes
2 answers

How do I get the response back from server after an email sending?

I want to get response from server with server status (eg. 200, 500) that says if message was delivered. How to do that? >> s = smtplib.SMTP('...') >> resp = s.sendmail('me@me.com', 'exist@email.com', 'message') >> print resp {} >> resp =…
User
  • 1,978
  • 5
  • 26
  • 47
3
votes
1 answer

Why is the Symfony Mailer Component returning an empty response?

I want to convert my mailing from Swift Mailer to the Mailer Component, since I upgraded to Symfony 4.3. I've translated my MAILER_URL to a MAILER_DSN, the following…
Majesteit
  • 183
  • 1
  • 9
3
votes
1 answer

On windows 7, my VB6 app can't see 'System' DSN's but has no trouble finding 'User' DSN's

For a while I was stuck trying to get a visual basic 6 app working in Windows 7. The last remaining snag was that it just couldn't find the DSN when starting up. On a hunch, I deleted the system DSN and created it exactly the same way, but in…
lowlevel
  • 188
  • 3
  • 9
3
votes
2 answers

Classic ASP cannot connect to SQL database after TLS 1.0 removed from server

I have an IIS web application which connects to a SQL Server like this: set objConn = Server.CreateObject("ADODB.Connection") objConn.Open("DRIVER={SQL Server};SERVER=servername;DATABASE=dbname;UID=username;PASSWORD=pwd) Recently I started getting…
gkmchardy
  • 43
  • 1
  • 6
3
votes
2 answers

SSRS: Error while querying data from an Excel file (through ODBC)

I am trying to render a simple chart using SSRS. The data is in an Excel sheet. I have set up an user DSN and created a data source in SSRS using ODBC. I am able to query the excel in Data tab. However while trying to preview, I get the following…
Gnana
  • 573
  • 2
  • 6
  • 14
3
votes
5 answers

File DSN for iSeries AS400 ODBC connection

How can I create a file dsn for connecting to an AS400 system using the iSeries ODBC driver? The iSeries ODBC driver allows many settings to be configured. Where can I find a list of all properties that can be set in the file DSN?
dbDude
3
votes
2 answers

creating DSN entry at runtime?

How can you add a system DSN with its security credentials programmatically at runtime from VB.NET? Keeping key in ODBC.INI is done, but when creating ODBC, it asks for Authentication Type (SQL or Network Login). How can we set that option at…
pvaju896
  • 1,397
  • 6
  • 25
  • 46
1 2
3
…
25 26