Skip to Content.
Sympa Menu

freetds - Re: Genereic db connection

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: PMoore AT axa.com.au
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Genereic db connection
  • Date: Thu, 12 Jul 2001 08:44:15 +1000



why not do a query "select name from master..sysdatabases"
and store the result in an array and then iterate through each value
issuing a "use database" command
and do what ever it is you have to do in each database ???

i'm assuming the databases all live on the one server......
peter


Peter Moore
Contractor,
ITeG, Axa Australia
Ph: + 61 9618 5183






Stefan Hudac <stevohudac AT yahoo.com>@franklin.oit.unc.edu on 12/07/2001
08:06:01 AM

Please respond to "TDS Development Group" <freetds AT franklin.oit.unc.edu>

Sent by: bounce-freetds-132908 AT franklin.oit.unc.edu


To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
cc:
Subject: [freetds] Genereic db connection


Hi guys.

I'm working now on project where there is connection
not fixed, but generic by db. It means that for each
part of the project there is database and all this
connection information are stored in other database.
All run on MSSQL7. Any idea how to obey fixed
connection written in interfaces file, and connect to
other database without entering it into interfaces
file?

Thnx

Stefan

__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/

---
You are currently subscribed to freetds as: [PMoore AT axa.com.au]
To unsubscribe, forward this message to
$subst('Email.Unsub')










**********************************************************************
Important Note
This email (including any attachments) contains information which is
confidential and may be subject to legal privilege. If you are not
the intended recipient you must not use, distribute or copy this
email. If you have received this email in error please notify the
sender immediately and delete this email. Any views expressed in this
email are not necessarily the views of AXA. Thank you.
**********************************************************************




Archive powered by MHonArc 2.6.24.

Top of Page