Hi,

Is it possible or manageable to have asp-pages that connect to SQL-Server 
or Access depending on a variable (country code)?
I presume that every pages gets two sets of connections and queries. But 
what about things like caching, can iis 5 be misled by various slightly 
different versions of the pages? What about (un)locking tables or 
connections? Will this become a nightmare?

Any experience in this matter is greatly appreciated. Thanks!


Martin

ASP doesn't care what kind of database you are using, as long as the IIS
computer has an ODBC driver or an OLE DB provider for it.  You can use
any mix of databases.

You would have to open two connection objects.  The queries would be
different, if the table and field names are different.  They might be
the same, if the table and field names are the same.

Carl Olsen

> -----Original Message-----
> From: martin van den berg [mailto:info@q...]
> Sent: Friday, January 03, 2003 2:50 PM
> To: ASP Databases
> Subject: [asp_databases] Access and SQL-Server in one ASP-page
> 
> Hi,
> 
> Is it possible or manageable to have asp-pages that connect to
SQL-Server
> or Access depending on a variable (country code)?
> I presume that every pages gets two sets of connections and queries.
But
> what about things like caching, can iis 5 be misled by various
slightly
> different versions of the pages? What about (un)locking tables or
> connections? Will this become a nightmare?
> 
> Any experience in this matter is greatly appreciated. Thanks!
> 
> 
> Martin
> to unsubscribe send a blank email to leave-asp_databases-
> 1112136X@p...