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

What are the access restrictions on accessing a DSN

We are running part of our app as a windows service and it needs to b able to access DSNs in order to import through ODBC. However there seem to be a lot of restrictions found through trial and error on what DSNs it can access. For example it…
John C
  • 611
  • 1
  • 9
  • 26
0
votes
1 answer

As BIDS 2008 is only 32 bit how can we develop for 64 bit?

I am working to get my packages running on SSIS 2008 64 bit. My pacakges used DSN so I made 64 bit DSN.. but as BIDS is only 32 bit I run into error like below. I think .Net Provider\Odbc Data Provider is 32 bit (as it is part of BIDS 32 bit) but…
Pritesh
  • 1,938
  • 7
  • 32
  • 46
0
votes
1 answer

Extended Stored Procedure with ODBC DSN

I have an extended stored procedure (written in Delphi if that makes any difference) that makes its own connection via ODBC and performs some processing - stuff that can't be done using T-SQL alone. If I try to connect using the System DSN that is…
J__
  • 3,777
  • 1
  • 23
  • 31
0
votes
1 answer

How to Create DSN in 64 bit O.S for Access database

How to create DSN in 64 bit OS for MS Access database for Windows OS?
Mahendra
  • 116
  • 1
  • 2
  • 6
0
votes
1 answer

ASP.NET 1.1 application failed connecting after migrating from SQL Server 2000 to SQL Server 2008

We have an ASP.NET 1.1 application installed on server A and SQL Server 2000 on server B. We want to migrate our database from SQL Server 2000 to SQL Server 2008. The issue is we don't have the code for ASP application as it was developed by some…
don great
  • 53
  • 1
  • 11
0
votes
1 answer

How to get database details from DSN in linux?

I am digging around an linux webapps using zend framwork. I couldn't find database connection string except the following in the…
orchidit
  • 17
  • 2
  • 8
0
votes
1 answer

What are the pitfalls and advantages of using different methods to distribute an ODBC database to different machines?

Having an MS-ACCESS front-end and a MYSQL back-end, what methods are available to distribute your Access file to new machines lacking the MySQL ODBC drivers and a pre-configured DSN. Could respondents please specify their preferred method only,…
Nag Hammadi
  • 297
  • 1
  • 6
  • 17
0
votes
1 answer

Connect to ONLINE MySQL database using DSN ODBC 2

I am facing this problem: stackoverflow question except my host doesn't seem to have cpanel. Since the answer given in the linked question is cpanel related it has not helped me. Is there anything I can do?
Nag Hammadi
  • 297
  • 1
  • 6
  • 17
0
votes
1 answer

I need help transferring UPS dsn from XP to Windows 7 64bit

I'm "upgrading" our Windows computer used for shipping. As part of our workflow, ShipGear exports to UPS On Line World Ship (UOWLS) via a mapped "keyed import" inside UOLWS. I used the UPS Utility in menu Start->UPS to do a database back up.…
Krista K
  • 21,503
  • 3
  • 31
  • 43
0
votes
1 answer

connection not opening from WCF with dsn

This code is written in WCF. when I add reference from localhost then this code works fine but when service reference is added from IIS then it fails in cn.Open() . It doesn't throw any exception and just hangs in this line. …
user270014
  • 581
  • 3
  • 21
0
votes
1 answer

SQLSRV32.DLL and MARS support

After search through google I came to know that the SQLSRV32 odbc driver do not support MARS.What are the workarounds for this. One way i guess is stop loop through the results of several SQL commands. But in my case i have to create 30-40 table and…
arjun
  • 625
  • 10
  • 27
0
votes
1 answer

MSAccess via ODBC - squirrely behavior - DSN settings

I am utilizing an MSAccess database on 2 machines in the same bldg. Machine1 has the database on it. Machine2 has a mapped drive to the database on Machine1. I can use the same key value on Machine1 and get a record, but using that same key value on…
Yosem
  • 4,685
  • 3
  • 22
  • 29
-1
votes
1 answer

Classic ASP - 500 Internal Server Error

I realise this question is asked several times previously but having looked at the guidance on the previous questions I still have no solution A working classic ASP application was transferred to another server and is indeed in the IIS Manager…
AJF
  • 1,801
  • 4
  • 27
  • 54
-1
votes
1 answer

ODBC Call Failed between Access 2010 and Advantage database server Over a network

First and Foremost, I know zip, zilch, nada, about VBA, access, and Advantage database Server. I have a PC in one location that can connect and update with an Access 2010 file where every drive is mapped, e.g. \file\whatever The advantage…
John Hernandez
  • 1
  • 1
-1
votes
3 answers

Android Studio Error/Warning : Cannot Find System Dns

I am using Android Studio 2.2 and when I try to do a trial run of hello world program, I am facing the error "cannot find system dns servers! Name resolution will be disabled". Also am getting avd with blank screen. Can you help me to solve this…
Albin Shaju
  • 3
  • 1
  • 5
1 2 3
…
25
26