"No such system DSN as x"
From: simon dot burrows at staffplan dot co dot uk ("simon)
Date: 06/29/04
- Previous message: Kevin Frevert: "Re: sorting data with aggregatefield in sql statement"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 29 Jun 2004 12:46:41 +0100
You'll probably think I'm crazy, but I have a good reason for making
very limited use of ADO in a legacy delphi app which uses the BDE. Both
the BDE datasets and the ADO datasets are connecting to the same SQL
Server database using the same ODBC alias (yes okay I know it sounds
horrible but bear with me).
The code which uses ADO starts as follows:
qryADOLock := TADOQuery.Create(Self);
qryADOLock.ConnectionString := Format('Provider=MSDASQL.1;Persist
Security Info=False;Data Source=%s;User ID=%s;Password=%s', [AliasName,
Username, Password]);
...where AliasName is the name of the ODBC System DSN.
This worked okay in development. Deployed to 1 site and it worked ok
for the sys admin. However, when he rolled it out, users were getting
the error "No such system DSN as [AliasName]" at the point when the ADO
query connected.
If the sys admin logged onto the same machine where the error was
occurring, it worked ok, so the error must be related to permission.
Can anyone suggest what permissions may be causing this? My only
thought is that the ADO connection is attempting to create a temporary
file which it doesn't have permission to write, but this seems unlikely.
- Previous message: Kevin Frevert: "Re: sorting data with aggregatefield in sql statement"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
