RE: Detect existing connection to ASA database?

Tech-Archive recommends: Fix windows errors by optimizing your registry

Have you tried calling the CONNECTION_PROPERTY() function?

e.g.

SELECT CONNECTION_PROPERTY('Number') or SELECT
CONNECTION_PROPERTY('SessionID');

One of these might give you what you need.

--
TC


"Byron" wrote:

I'm hitting several ASA databases in quick succession through my application
using ODBC. I look for every file with a .db extension, open it, and read
from a particular table to offer the user a list of databases to choose from
based on that data rather than the file name. This works fine as long as my
applicaiton is the only one using the files.

The problem is, if another application already has a connection to a
database I keep getting the same first row back in the datareader and there
is no exception thrown.

Is there a way to either prevent this behavior, or at least detect that
someone else is already in there and warn them they have to close the other
application?
.

Relevant Pages

  • Re: Standard DBI Proposal
    ... If you're asserting that there is no ODBC on non-Windows platforms, ... Tcl command I can use to connect, ... This is what tclodbc does and I think ... My two workhorse databases are ...
    (comp.lang.tcl)
  • RE: ODBC + MSAccess + Perl + Linux or FreeBSD question.
    ... data on an Oracle databases and have many link tables in MS Access. ... I use MS Access with ODBC to link my mySQL tables from another ... I use PHP and mySQL for a website I have developed but a lot of the ... ODBC + MSAccess + Perl + Linux or FreeBSD question. ...
    (perl.dbi.users)
  • Re: ADO, ODBC, Service process
    ... > is located on a file server. ... if you are using the ADO components, i would rather suggest you to use the ... OLE DB provider contained in Microsoft's Jet 4.0, than using the ODBC. ... distributed with Microsoft's desktop databases. ...
    (borland.public.delphi.database.ado)
  • Are there PHP database plug-ins for Rdb and MySQL on VMS?
    ... I have a budget of zero, and I know a lot more about Perl than I do about PHP. ... A quick google search turned up discussion about using the ODBC PHP plugin to ... talk to Rdb databases, but that won't work for Rdb running on the same machine; ...
    (comp.os.vms)
  • Re: Diff type of data fetching
    ... drivers for connections to client/server SQL databases. ... ODBC is an industry standard supported by Microsoft; ... MS thought their OLEDB classes would make ODBC obsolete but they have had ... OLEDB permits calling ODBC drivers but this is now a deprecated usage as ...
    (microsoft.public.fox.programmer.exchange)