You might want to revisit the JDBC drivers at some point--you'll get a lot better performance than with the ODBC socket. As long as I use the MySQL JDBC driver (the one you get from the MySQL web site) I've never had any trouble connecting.
Matt On Sun, 30 Jan 2005 18:06:48 -0600, Chris Gomez <[EMAIL PROTECTED]> wrote: > Ok, the problem's resolved. MySQL.com recently released a patch for > MyODBC3.51. Once I installed that, I was able to create an ODBC Socket > connection in CF Administrator. woohoo! I can see my data now! LOL > > On Sun, 30 Jan 2005 09:16:36 -0600, Chris Gomez <[EMAIL PROTECTED]> wrote: > > I'm making a little progress, I think. the link is similar to the one > > I used last night. now, I'm getting the following error: > > > > Connection verification failed for data source: dev > > []java.lang.NoClassDefFoundError: java/sql/Savepoint > > The root cause was that: java.lang.NoClassDefFoundError: java/sql/Savepoint > > > > I've tried adding the .jar class to the Java and JVM page in CF Admin, > > but still get the error. > > > > I use w2k and am able to run MySQL 4.1.7 and the MySQL Administrator > > and Query Builder without any problems. When I try to add the DSN, CF > > Admin automatically populates the id/pw fields. I guess it's getting > > the info from the mysql server. > > > > What I'm trying to do is create a DSN so I can extract data from a > > Access 2000 db and place it in a MySQL db using cfquery and cfinsert. > > > > Chris > > > > On Sun, 30 Jan 2005 07:58:37 -0600, Adrian J. Moreno > > <[EMAIL PROTECTED]> wrote: > > > Chris, > > > > > > is this the article you followed from Macromedia? > > > > > > How to use MySQL 4.1 with ColdFusion MX > > > http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253 > > > > > > I followed these steps on my Win2k machine without any problem. What OS > > > are you running? > > > > > > Try entering 127.0.0.1 instead of "localhost". > > > > > > How are the ID and PWD "automatically populated"? Do you plan to pass > > > them in via <cfquery>? If you didn't enter them in the Datasource form > > > fields, then CF Admin can't verify the connection. > > > > > > You can verify user access privileges by downloading MySQL > > > Administrator: http://www.mysql.com/products/administrator/ > > > > > > See if you can connect to your database using that ID/PWD with MySQL > > > Query Browser: http://www.mysql.com/products/query-browser/ > > > > > > HTH, > > > > > > Adrian > > > > > > Chris Gomez wrote: > > > > I am trying to set up a MySQL 4.1.7 DSN connection, but i keep getting > > > > the following error: > > > > > > > > Connection verification failed for data source: dev > > > > []java.sql.SQLException: SQLException occurred in JDBCPool while > > > > attempting to connect, please check your username, password, URL, and > > > > other connectivity info. > > > > The root cause was that: java.sql.SQLException: SQLException occurred > > > > in JDBCPool while attempting to connect, please check your username, > > > > password, URL, and other connectivity info. > > > > > > > > I have loaded the latest ODBC and JDBC drivers from the MySQL site. I > > > > selected MySQL as the driver, then entered the DSN name, schema name > > > > and server (localhost, in this case). The user id/pw are > > > > automatically populated. > > > > > > > > I checked Macromedia's site and tried using the Other ODBC driver and > > > > configured it with the JDBC URL and Class data. However, I get the > > > > same authentication error. > > > > > > > > I've also tried to create a DSN for the mysqltest schema and created a > > > > connection for it, either. > > > > > > > > any help appreciated. > > > > > > > > Thanks, > > > > > > > > Chris > > > ---------------------------------------------------------- > > > To post, send email to [email protected] > > > To unsubscribe: > > > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > > > To subscribe: > > > http://www.dfwcfug.org/form_MemberRegistration.cfm > > > > > > > > > ---------------------------------------------------------- > To post, send email to [email protected] > To unsubscribe: > http://www.dfwcfug.org/form_MemberUnsubscribe.cfm > To subscribe: > http://www.dfwcfug.org/form_MemberRegistration.cfm > > -- Matt Woodward [EMAIL PROTECTED] http://www.mattwoodward.com ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
