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

Crystal reports , the report you requested requires further information, login using ODBC DSN

The report is runnig fine in Visual Studio 2005 but fails when I deploy it on IIS. It prompts, the report you requested requires further information. I think it needs to get installed some service pack either of SQL server client, or of Crystal…
Asghar Ali Rana
  • 1
  • 1
  • 1
0
votes
1 answer

QTP- How to connect to a 32 bit DSN from a 64 bit environment (Windows 7 - 64 bit)

How to connect to a 32 bit SQL server using DSN from a 64 bit environment (Windows 7 - 64 bit) through QTP. I tried by creating DSN from this C:\WINDOWS\SysWOW64\odbcad32.exe but that gives error: "Error # -2147467259 [Microsoft][ODBC Driver…
Harisha K P
  • 327
  • 2
  • 7
  • 19
0
votes
1 answer

Error when function "OpenDataSource" is called

I want to create a MS Word merge document. I have already created a template document. When my application is started, it creates an ODBC, called "Hrms2008". I am new to this kind of stuff, that's why I don't know what causes the error. …
Gauri K.
  • 79
  • 1
  • 1
  • 10
0
votes
1 answer

Connecting to SQL server using SQL Client and DSN

Would it be possible to connect to SQL server using DSN however using SqlClient rather than ODBC. As a matter of fact we have to upgrade a legacy VB6 component however we have to keep the user suitability same ie the users are connecting to…
user1829319
  • 691
  • 1
  • 8
  • 22
0
votes
1 answer

Cannot find System DSN in Reporting Services

I have created System DSNs to a MySQL and Oracle database and I have been able to use these DSNs to create linked servers in my SQL Server database and all is working fine. However, I am trying to create a report in BIDS 2008 / Reporting Services…
Matrich
  • 183
  • 2
  • 16
0
votes
0 answers

php pdo with mssql and a dns

Trying to see if I can make PDO open my mssql database on my server. With vbscript my call to the connection looks like this: set MyConn = Server.CreateObject("ADODB.Connection") MyConn.Open("dsn=MYDSN;uid=MYUID;pwd=MYPWD;DATABASE=MYDATABASE;APP=ASP…
kqlambert
  • 2,693
  • 6
  • 33
  • 50
0
votes
4 answers

Error trying to connect to MySql using DSN

It has been a long time since using VB6 and I didn't use MySql or DSN connections then, but I'm working on a legacy application that uses these. When I try to open the connect I am getting a Data source not found and no default driver specified…
KevinManx
  • 519
  • 1
  • 5
  • 26
0
votes
1 answer

Google Apps Script API rackspace DNS

I was able to run the API from the duncio Curl. Then try from google Apps Script. Part of Get the token WORKED, but then I can not make any more acion. I put the code in case it helps show where I have the problem function Token() { var user =…
Mvillani
  • 11
  • 3
0
votes
1 answer

DSN connection runs twice

I have defined System DSN connection "ASPClassic" in ODBC. After I run the following code in Classic ASP Set conn=Server.CreateObject("ADODB.Connection") conn.open "DSN=ASPClassic" I can see in SQL Server two logon attempts. The first one is a…
Yevgeni Grinberg
  • 359
  • 5
  • 19
0
votes
1 answer

How to work with 32 and 64 bit DSN Simultaneously?

My application is in classic asp. Till now it is working fine with 32bit windows server and connecting oracle via a system DSN which is prepared with "Microsoft ODBC driver for oracle". Now, the server has been migrated to 64bit Windows server 2008…
Surath Chandra Dutta
  • 1
  • 1
0
votes
1 answer

How to Get the driver type of DSN?

I have got the list of DSN in my machine alike private IEnumerable EnumDsn(Microsoft.Win32.RegistryKey rootKey) { Microsoft.Win32.RegistryKey regKey = rootKey.OpenSubKey(@"Software\ODBC\ODBC.INI\ODBC Data Sources"); if (regKey…
joedanny
  • 147
  • 1
  • 2
  • 10
0
votes
1 answer

Read only ODBC connection

Good Morning! I'm working on a VB6 project which reads/writes to its database via an ODBC data source stored in the system. What I'm hoping to accomplish, is to temporarily set the ODBC connection to "Read Only" so that I can see what SQL the system…
Nick Heidke
  • 2,787
  • 2
  • 34
  • 58
0
votes
1 answer

Dynamic DSN using VB6 for SQL server

I want to create Dynamic DSN in my VB6 Application. I have tried the following code in my MODULE. using the following Microsoft link- http://support.microsoft.com/kb/171146. My code is here- Private Declare Function SQLConfigDataSource Lib…
Teju MB
  • 1,333
  • 5
  • 20
  • 37
0
votes
1 answer

System DSN is not working in Remote Desktop Server(RDS) for all users

I am running a VB 6 application for a report. It prints well in local with System DSN. But when i put the .exe of the application in RDS , report is not printing for System DSN rather its printing for User DSN. For System DSN its showing- "Cannot…
Teju MB
  • 1,333
  • 5
  • 20
  • 37
0
votes
1 answer

The specified DSN contains an architecture mismatch between the Driver and Application error

So I've done hours of trial and error and research on this trying to figure out what this error means. As far as I can tell, it's caused by a difference between the bit architectures of the ODBC driver and Microsoft Access (which I'm attempting to…
Jpon9
  • 3
  • 1
  • 6
1 2 3
…
25 26