p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

asp_databases thread: How to auto-detect database and send right SQL string?


Message #1 by syamlim@n... on Mon, 10 Jul 2000 16:0:4
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.


  Return to Index