I do not remember who, but some great and knowledgeable cf person pointed me to some scripts that allow you to manipulate datasources. These worked great. I have been able to call the functions and add the datasources that I needed to programmatically.
If you did not get the email let me know and I will rebroadcast it this evening.
thanks,
kaigler
---------- Original Message ----------------------------------
From: Dave Watts <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Tue, 25 Nov 2003 09:42:34 -0500
>> Old CF used to find the DBs in the odbc registry key. You could
>> also add them in thru the cf admin but you didn't have to. Does
>> mx not work that way any longer? Meaning, is it required now to
>> add dbs thru the admin or will mx still find them in the odbc
>> registry key?
>
>CFMX uses JDBC, not ODBC. JDBC datasources have no registry entries at all,
>and are listed only in the appropriate XML configuration file. CFMX does
>come with an ODBC bridge of sorts, which allows CFMX to talk to ODBC
>datasources, but it's my understanding that this should only generally be
>used if you can't find a JDBC driver for your database. I'm pretty sure that
>CFMX doesn't automatically register information for existing ODBC
>datasources, too.
>
>Dave Watts, CTO, Fig Leaf Software
>http://www.figleaf.com/
>voice: (202) 797-5496
>fax: (202) 797-5444
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
