>>What are the other drivers - MySQL(3) and MySQL (4/5), for instance - are they JDBC drivers?
Yes - I know that MySQL 4/5 uses uses a jar file located under your CF installation dir EX: C:\ColdFusion_install_Dir\wwwroot\WEB-INF\lib\mysql- connector-java-5.0.4-bin.jar I am assuming CF 8 shipped with this because I did didn't place it there,... That and in CF 7 you had to DL the Mysql driver from the Mysql site (Due to redistribution issues) and place it in the above dir in order to get Mysql 4/5 to work correctly. Hope that helps. Cozmo On 9/18/07, Jim McAtee <[EMAIL PROTECTED]> wrote: > > ----- Original Message ----- > From: "Dave Watts" < [EMAIL PROTECTED]> > To: "CF-Server" <[email protected]> > Sent: Tuesday, September 18, 2007 7:42 AM > Subject: RE: CF8 and ODBC Drivers > > > >> Does CF8 install its own ODBC drivers? > > > > No. As Jochem said, CF uses a bridge. This bridge is called SequeLink, > > and > > consists of the two ODBC services in your services list. > > > Is this bridge used only for 'ODBC Socket' datasources? What are the > other drivers - MySQL(3) and MySQL (4/5), for instance - are they JDBC > drivers? And Access & Access w/Unicode - is CF bridging to the installed > Access ODBC driver, or using a driver that it installed? > > > > Within the CF > > Administrator, you choose "ODBC Socket" to connect to an existing ODBC > > datasource. So, you'd define your Excel ODBC data source as a system > > datasource within the ODBC Administrator application within > > Administrative > > Tools, then you'd specify that datasource by name when creating your > > ODBC > > Socket datasource within CF. > > > >> On this particular machine, in the ODBC Data Source > >> Administrator I see three entries under 'User DSN' ... > > > > Go to the "System DSN" tab, and create your datasource there. User DSNs > > are > > only useful for the logged-in user. > > > I just mentioned it to say that's all I see under the system's ODBC > Administtrator. When I attempt to add a System DSN the only driver listed > > is a SQLServer driver. When I reinstall the MDAC from the OS installation > disk I can see that all the driver files are being copied, but no registry > entries are being made under HKLM\Software\ODBC\ODBCINST.INI, where I'd > expect them. > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Server/message.cfm/messageid:6439 Subscription: http://www.houseoffusion.com/groups/CF-Server/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.10
