Re: Two different dsns return the same dataset

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Frank Hickman" <fhickman3_NOSP@xxxxxxxxxxxxxxx>
Date: Wed, 7 Nov 2007 23:21:23 -0500

"walter1234" <walter1234@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:21D27822-6E01-4221-A714-8382E61B6885@xxxxxxxxxxxxxxxx

Frank,
Thanks for your reply
THe sql is the same, but the return dataset is absolutely identical, down
to
the record id numbers. The two locations have different number of records
in
the tablem, I checked.

Is there a default connection assigned to the "dba" user id which may be
overriding the DSN?

--
============
Frank Hickman
NobleSoft, Inc.
============
Replace the _nosp@m_ with @ to reply.

.

References:
- Re: Two different dsns return the same dataset
  - From: Frank Hickman

Prev by Date: Re: Two different dsns return the same dataset
Next by Date: sqlite 3 / ODBC
Previous by thread: Re: Two different dsns return the same dataset
Next by thread: Re: Two different dsns return the same dataset
Index(es):
- Date
- Thread

Relevant Pages

Re: PerfMon recording to SQL 2005
... I've been out of the SQL world for a couple years so dusting ... A System DSN, specifying windows authentication, and change to an ... Configuring the log file, choose the tested DSN as the System DSN ... The user account I created in SQL is an owner of the ...
(microsoft.public.sqlserver.server)
Re: PerfMon recording to SQL 2005
... I've been out of the SQL world for a couple years so dusting off ... A System DSN, specifying windows authentication, and change to an existing ... Configuring the log file, choose the tested DSN as the System DSN ... The user account I created in SQL is an owner of the ...
(microsoft.public.sqlserver.server)
Re: PerfMon recording to SQL 2005
... I've been out of the SQL world for a couple years so dusting off ... A System DSN, specifying windows authentication, and change to an existing ... Configuring the log file, choose the tested DSN as the System DSN ... The user account I created in SQL is an owner of the ...
(microsoft.public.sqlserver.server)
Re: Failed Connection to SQL Srvr 2005
... Next when DSN, by default, was ... On the server (Server Config ... I have a range of clients, some who have SQL 2000 ... (connections work). ...
(microsoft.public.sqlserver.connect)
RE: SQL-Server and Win2k3
... If your servername is the same, and ip address is the same then you should ... Check if your DSN creates an alias. ... If you have to recreate your DSN after moving SQL, ... but your instance of sql is NOT listening on this network ...
(microsoft.public.sqlserver.connect)