RE: DSN

[Schreck, Thomas (PPC)]

I need to tell what database I’m working with from my DSN value so I know to load some database specific code.  My idea is to take the DSN, determine the database type (SQL, ORACLE, ACCESS, etc.) and load the appropriate module.   Thanks -   Tom Schreck 817-252-4900 [EMAIL PROTECTED]   I have not failed.  I've found 10,000 ways that won't work.   - Thomas Edison   -----Original Message----- From: Jacob Cameron [mailto:[EMAIL PROTECTED] Sent: Monday, November 10, 2003 1:27 PM To: [EMAIL PROTECTED] Subject: RE: DSN   If you can see errors, run this query:  select junk from stuff   The error message will report the what DB your using.   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Schreck, Thomas (PPC) Sent: Monday, November 10, 2003 12:40 PM To: [EMAIL PROTECTED] Subject: DSN Can CFMX return the type of database a DSN connects to?  How can I tell if the DSN I’m using is for a SQL Server, Oracle, Access, or MySQL database?   Thanks -   Tom Schreck 817-252-4900 [EMAIL PROTECTED]   I have not failed.  I've found 10,000 ways that won't work.   - Thomas Edison