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

Character Set issue using SQL Server and ODBC in php

I connected to to sqlsever2008 with odbc(with dsn) and php but problem is that when I retrieve information from that it has character like ���������. My datatype in sqlserver is nvarchar. Any idea why it is happening? NOTE: The page is…
Mahdi_Nine
  • 14,205
  • 26
  • 82
  • 117
0
votes
1 answer

how do you setup a db data source in a visual studio 2005 deployment

I'm working on deploying a visual studio 2005 windows application executable with an embedded crystal report using visual basic. It seems to install everything just fine, however, the system dsn isn't being setup. How do you configure a setup…
phill
  • 13,434
  • 38
  • 105
  • 141
0
votes
4 answers

How can I connect to a local ODBC datasource

I created an ODBC database on my local machine with driver SQL server Native client 10.0, which connects to a remote server, see . I am working on a project about customized ODBC to an inhouse database and want to Test how I can connect to a data…
hong pei
  • 929
  • 2
  • 13
  • 27
0
votes
1 answer

How to identify 32 bit odbc when calling it from .net application in windows 7

I have a desktop application in vb.net which runs fine in Windows XP but after installing the application on Windows 7 64 bit its not able to run. The 32 bit ODBC does show the driver for DB2 connection(Version 9.7) but the version 64 bit of ODBC…
Ashu
  • 31
  • 1
  • 3
  • 10
0
votes
1 answer

how to get default database name of system DSN of windows in java

DatabaseMetaData data = connection.getMetaData(); resultSet = data.getCatalogs(); while (resultSet.next()) { System.out.println(resultSet.getString("TABLE_CAT")); } above code gives me name of all the database of the sql…
Pravin
  • 1,137
  • 12
  • 20
0
votes
1 answer

only one instance of resultSet is allowed while connecting SQL SEVER using DSN

i am getting bellow error [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt my code private static final String DRIVER = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; private static final String URL =…
Pravin
  • 1,137
  • 12
  • 20
0
votes
0 answers

How can I call web services from a database driver?

I have a COTS (commercial, off the shelf) application that must connect to some kind of ODBC connection (the driver doesn't really matter). However rather than save to a database, I want the data to be saved via an HTTP Post to a webservice. Is…
Domenic D.
  • 5,276
  • 4
  • 30
  • 41
0
votes
1 answer

Query regarding multiple DSN (domain source name)

I'm new to ODBC and DSN's in general. We have a product A that accesses a database "T" via a DSN D1 that has already been defined. I'm now writing a test app testA that exercises various functionalities of product A and also needs to validate…
Omi
  • 976
  • 2
  • 20
  • 35
0
votes
1 answer

Excel - changing embeeded DSN

I have an Excel with an embeeded DSN. When I open the Excel in Notepad i see it: DSN=serverName;Description=serverName;UID=UserName;;APP=Microsoft Office 2003;WSID=LT-533571;DATABASE=DatabaseName I want to change the server property, how can I do…
Adam
  • 756
  • 4
  • 10
  • 23
0
votes
1 answer

ConnectionString odbc pwd

I have a problem with the following connection string: ConfigurationSettings.AppSettings["connstr"] = "Dsn=dsn_name; Trusted_Connection=yes;Uid=usrName;Pwd=some+Password;"; This throws an exception that authentication fails. The problem with that…
user2090983
  • 29
  • 4
0
votes
3 answers

Accessing ODBC DSN on LAN

I've googled but didn't find the connecting string to access ODBC DSN for MS ACCESS over LAN this is what I have so far but only works on the local machine:
Ali
  • 1,648
  • 2
  • 26
  • 48
0
votes
2 answers

Using $dsn string variable as parameter in database PDO

Goal: to simply fetch array from a MySQL database. Issue: I am using the $dsn "string variable" as a parameter in the PDO Statement but there appears to be an uncaught exception and it has something to do with invoking the driver or the…
Ben
  • 1,013
  • 4
  • 16
  • 34
0
votes
0 answers

jdbc odbc connectivity without dsn creation

I am trying to make jdbc-Odbc connection without making the DSN but is throwing the exception. I am using the following code and it is throwing data source name not found no default driver specified exception. try { …
adesh
  • 1,157
  • 3
  • 18
  • 28
0
votes
1 answer

DSN not able to connect to a remote SQL server

I am moving all my existing applications to a new web server, applications use a DSN based connection using ODBC driver. On the new server I am trying build DSN which connect's to remote SQL Server, but I am getting the error :…
foo-baar
  • 1,076
  • 3
  • 17
  • 42
0
votes
1 answer

ASP DSN-Less Connection Issues

Sorry if this isn't the appropriate place to put this question, but I'm new to the forums. My issue relates to ASP and a DSN-less connection. I have a website, which was built quite a while ago using DSN connections to an Access database, which ran…
user1607021
  • 47
  • 1
  • 1
  • 6
1 2 3
…
25 26