MS Query help required

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Grant Reid (granr_at_sybase.co.za)
Date: 04/08/04 

Date: Thu, 8 Apr 2004 16:29:59 +0200

Hi

I have a spreadsheet on my notebook which I use for DBA services at a
particular client. It connects to database server via an existing ODBC
database connection extracting data from system tables. I would like to be
able use this spreadsheet at other clients, WITHOUT having to create a new
ODBC connection.
Is there any way that this can be accomplished?

The ideal scenario would be that the logon credentials and server address
reside on one sheet and upon arrival at another client, one merely changes
this information and then queries the database.

Any help would be appreciated.

Regards - Grant

Relevant Pages

  • Re: Confusion about database updates
    ... all connecting to the same database server. ... >> The problem occurs when connection to the database server is lost. ... Let the MySQL server do that when your client ...
    (comp.lang.java.databases)
  • Re: TIP#308: Choice of dict as the row representation
    ... a database query all be returned as lists. ... database and transport it in dvd's or jump drives. ... When you do a large select, the database server manages the results ... Just because the client issues a query to select terabytes ...
    (comp.lang.tcl)
  • RE: System.Transaction
    ... First verify the "Distribute Transaction Coordinator" Service is running on ... both database server computer and client computers ... If it is running and client application is not on the same computer as the ... database server, on the computer running database server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: JDeveloper..
    ... >> In JDeveloper, How can I create client setup in Jdeveloper? ... >> Database server which can be defined in DataBaseConnection wizard.It ... >> install it from other System(means client) How can I generate jar file? ... > The database connection wizard seems to be strictly for use from within ...
    (comp.lang.java.programmer)
  • Re: Error disconnecting clients with ODBC Error
    ... Try using another ODBC tool like WinSQL and see if you get the same behavior. ... We use a third party software program that connects to the SQL database to store all our data. ... Every so often we get disconnected with an ODBC error and have to close the client then reconnect to the server. ...
    (microsoft.public.sqlserver.odbc)