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 seems that it cannot 1. access a system DSN unless the account that is running the service ha...
I have an Excel application in which I want to present the user with a list of the Data Source Names (ie: DSN's), whereby s/he can choose what data source to use. Hopefully once I've got the list, I can easily access the DSN properties to connect to the appropriate database. Please note, I do not want to use a DSN-less connection. ...
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 or values with updated SQL Server drivers. Accepted Answer Note: Using SQLConfigDataSour...
How can I get data from a database that I can only access through an ODBC Data Source (DSN) in T-SQL MS SQL Server, any version? ...
Hi, I normally store all my configs in the registry. Even though I have started using LINQ I would not like to have the DSN in the web.config, but rather let it stay in the registry and attach it (maybe in the Application Start Event) to the System Config. How can this be done? Thanx for any ideas! edit: to make it clear: I do not wa...
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? ...
I am digging around in a Linux application that supposedly uses DSNs to connet to SQL Server. The connection stopped working and I can't find the credentials that are being used (all I know is the DSN's name). I am familiar with DSNs in Windows, but how are they created and where are they stored in Linux? ...
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 error: error [hy000] [microsoft] [odbc excel driver] the connection for viewing your lin...
Scenario: Our install package used to add User DSN. We changed this to install System DSNs due to Terminal Servers and Citrix. The problem is that some of these old User DSNs are floating around, and our application automatically chooses the User before the System and the connection info has changed as we upgraded server software. I g...
I have inherited a web application with an Access backend (yes I know). I need to get this thing deployed asap to a shared hosting provider. Unfortunately, it's not as easy as I imagined as hosts tend to lock down access to Access databases (AFAICT). I have a shared account with GoDaddy - I have enabled Access database use, and created...
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 order to see data in the pivot table? ...
Hello, I am really stumped on this, I am not sure if someone can at least point me in the right direction? I have an MS Access Reporting Application. It has a few local tables in it but predominantly relies on tables from a SQL Server 2005 database that it links to. It links to the SQL DB via a System DSN. I have built a function th...
I have a legacy VB6 app which builds a DSN based on a parameter in a config file. The parameter is an ODBC connection, and the connection has a name (DSN-NAME) which maps a server (DBSERVER) to a driver ("SQL Server Native Client"). Generally, it builds a DSN like this: DSN=DSN-NAME;User=foo;Password=bar If I specify a hostname i...
I have an application that connects via a DSN to an Oracle database. If the initial attempt to connect fails, then I make sure their DSN exists. If it does not exist, then I create it using the SQLConfigDataSource command. That command requires the driver name as one of its arguments. On my machine, I have the 11g driver, so the follo...
We've got an ASP.NET website that uses a database that we want to be able to use a connectionstring to get to. We've successfully set up a DSN for connecting to this DB, but I can't seem to discover the correct magic to go with a connectionstring. Is there a straightforward way to translate the values from the DSN into a connectionstri...
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 set up (e.g. named MyDataSource), the xp returns the following error: [Microsoft][ODBC SQ...
Hi, I'm trying to connect to a MySQL 5 database using the MySQL ODBC 5.1 driver. In the control panel's ODBC settings I created and tested the ODBC connection and it's working fine. When I try to use the connection from VBScript code I get an error though: ADODB.Connection error '800a0ea9' Provider is not specified and there is no desig...
Hi there, I want to implement a "smartODBCLogin". I know how to get a list of all engineNames and drivers from all ODBC data sources out of the registry. Now I want to know, which of these sources are available (active). (To open a new odbcConnection wouldn't work/help, would take to much time.) Does anybody know how to implement this...
Hello, 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 it? It's driving me nuts, tried editing the excel in Notepad - crashes the Excel, ...
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 project to setup the system dsn during the installation? thanks in advance ...