asp_databases thread: How to auto-detect database and send right SQL string?
Hi Greeting,
Our ASP pages and Data Objects connect to different databases(MS SQL,
Oracle, DB2) with different version of SQL string. now we use Application
variable and a case statement to send the right SQL string to right
database. However, this requires reset Application variable manually
eveytime when database change. So how can ASP or ADO or other ways auto
detect what database is connected to so it will send the right version of
SQL statement.
Thanks.
|





