I've build a Windows service that allows a user to choose a DSN and the service will access it and peform tasks on it. The code works without error when running under a test command line application, and fails when running as the actual Windows Service. My question is, are Windows Services not allowed to access User DSN? Is there any ...
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 Reports. Please suggest. ...
I am a newbie with Subsonic. I want to create a SQL connection using DSN; then I want to generate the DAL using Subsonic. Please can you give me some pointers on what to do? ...
Hey I work in a big company and need to connect to a oracle database. It is set up so that i can connect to it through DSN, but I would like to connect to the db directly. How do i do that, when the only information I have is the name of the db and the username and password. It works fine through dsn. ...
I'm trying to load some data to an Oracle database using SQL Loader. Is it possible to invoke it with specifying the server to load the data into using a DSN instead of a TNS? Right now my command line looks like this: sqlldr uesr/password@tns_id..., I'd like to replace tns_id with a DSN that points to tns_id. Can SQL Loader figure out ...
I've been having a problem for the past month and can't seem to figure out what is wrong. Here's the setup and a little background. Background: I have a web-host who was running my website on Windows Server 2003 and SQL Server 2000. One of my webpages returned a result set from a stored procedure from the SQL server as xml. Below is th...
Hi all, I'm trying to parse a DSN (from a Symfony application) using regular expressions, in order to link with a secondary application, but using the same database. The DSN I currently have is: mysql:dbname=my_db_name;host=localhost with a regex of: /^(\w+):(dbname=(\w+))?;?(host=(\w+))?/ (using preg_match()). This matches OK, ...
I have an Access 2003 database MDB where all of the tables exist as linked tables within SQL Server 2005. The MDB file contains all of the ODBC information that points to the correct SQL Server and log-on credentials (trusted connection). What I would like to do is add a new linked table to the MDB file however I am not sure how to go ...
I have a query: The "X" tables are from one data source and the "Y" table is from another...but there is join between the data sources. I can't seem to figure out how to enter the two different connection strings for this to run. Conne...
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using Microsoft.SqlServer.Management.Common; using Microsoft.SqlServer.Management.Smo; using System.Data.SqlClient; using Microsoft.Win32; usin...
Right now we are using Fastpath ODBC DSN connection method to access our "ARUNA" Database. Our development platform is C# on the .NET Framework. We are in need of connecting the DB without using DSN. Is it possible to connect Aruna using DSN less method? Update Somewhere I heard about ODBC Bridge softwares, can anybody shed light on...
Hi, I'm trying to connect to an access database from a php script using ODBC. When I put the db on my local c: drive create a system DSN i can connect no problem, but when it's on the networked drive I get the error: Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is n...
I am trying to create a script such that I am given an array of server names and from these names I would like to create a system dsn on each of those respective machines. I know that you can use SQLConfigDataSource() to create a dsn on your local machine, but it does not seem to give any parameters for creating the dsn on a separate ma...
We are using MS Access as a reporting front-end for Oracle. The data is accessed via an ODBC connection, and there are two linked tables in Access to Oracle that are the raw data tables. I'd like to be able to set up the connection and link the tables from within the Access file. That way users don't have to worry about setting up an DSN...
I can connect to a remote MySQL db from an Excel workbook on my machine no problem using the following connection string: Driver={MySQL ODBC 5.1 Driver};Server=server;Database=database;user=user;Password=;Option=3; ..but when others try to use the same workbook the connection can't be made ("Data source name not found and no defaul...
I'm fetching emails from a POP3 server and I'd like to make a difference between a regular email and DSN (Delivery Status Notification) / NDR (Non-Delivery Report/Receipt) messages. What is the best/safest way to identify those messages? Are there any particular message-headers I should be looking for? Thanks in advance! ...
What odbcconf.exe command line can I use to change the path to the MS Access .mdb file for an already existing System DSN? ...
I need to make an application in Java , which needs to use SQL database . I wil provide the users with the database file , but that won't run because to setup the database connection we first need to add a User DSN in Windows . Is there a way to add it( User DSN ) automatically when the applcation installs ? ...
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 runtime? ...
I need to make a connection to an Access Database. In order to do that I created a System DSN. I had success making that connection using local files. However, the database must be at a remote server and I mapped a network drive so I can access the database files. Mapping the drive and using the remote files, an error arises when I try ...