If the data sources could only be Oracle or SQL Server, why not simply use a "known" bit of PL/SQL or TSQL?
E.g. "SELECT @@VERSION" on SQL Server will return something like Microsoft SQL Server 7.00 - 7.00.623 (Intel X86) Nov 27 1998 22:20:07 Copyright (c) 1988-1998 Microsoft Corporation Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 6) On Oracle it will either fail or return something else > Frans Bouma wrote: > >> I am using ADO.NET to connect to a database using a DSN > (through the > >> ODBC) in my application. I need to find whether the database I am > >> connected to is either SQL or Oracle. Is there anyway we > can do this? =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
