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
