MySQL Connector / J 3.1.0 Alpha
I thought this is the most popular jdbc driver for mySql.
I have been using this for my project in Win2000 environment. But today I tested my application in winXP, and I was shocked. Somehow it just failed when retrieving a resultset from mySQL and the field names are all corrupted.
This does not happen in win2k environment. Is this a bug?
Anyway, what is the alternative driver or is there any recommendation?
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
To Use MySQL 5.0.1. Alpha?
I am creating my first web app using MySQL database and would like to use stored procedures. As far as I know this is a future only in MYSQL 5. My question is if the server is enough stable for serious use? Are there any problem?
PHP 4.3.9 And MySQL 5.0 Alpha
Are they compatible at all? I got PHP 4.3.9 up and running on my XP box using Apache, but when I try to setup phpmyadmin, I keep getting authentication Errors Message. 1250 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
Mysql 5.0.1 Alpha
i just installed 5.01. alpha for my class coz we have to use stored procedures. i cant startthe server. there is not mysqld.exe i triend mysqld-max --install but it tells me that service is running.
MyODBC 3.51 To MySQL 5.0 Alpha
I am recently testing out MySQL 5.0.0_2 Alpha on a FreeBSD 5.2 server. Also, I am experimenting with MS Windows connectivity, and although the MySQL Administrator application works beautifully, I seem unable to establish an ODBC DSN to the database. I installed MyODBC 3.51.06 but it fails upon authentication with the following message: [MySQL][ODBC 3.51 Driver] Client does not support authentication protocol requested by server; consider upgrading MySQL client And am I considering, but it doesn't help. Any good suggestions or is it not yet possible to connect through ODBC
MySQL 5.0.2 (Alpha) Released
A new version of the MySQL database, version 5.0.2, has been released. This is an alpha release for the current MySQL development branch, and it is now available in source and binary form from the MySQL 5.0 Snapshot download.
Compiling Mysql In Alpha With Tru64Unix V5.1
I try to compiling Mysql V4.0 in the Alpha/Tru64 Unix V5.1a. I have installed in the Alpha C++ and C version 6.5, and gcc 3.3 and GNU MAKE 3.8. Follow the Steps. 1- Dowload from http://www.mysql.com/downloads/mysql-4.0.html in the SOURCE DOWNLOADS >> Tarball(tar.gz) 2- I saved in the /usr/local/ 3-Gunzip mysql-4.0xx.tar.gz 4-Tar mysqlxxxx 5-CC=cc CFLAGS=-O CXX=gcc CXXFLAGS=-O3 ./configure --prefix=/usr/local/mysql 6-Make # make No suffix list. make all-recursive No suffix list. Making all in . No suffix list. Making all in include No suffix list. Make: % rule can only use a single ':'. Stop. *** Exit 1 Stop. *** Exit 1 Stop.
Enable Unicode In MySQL 4.1.0-alpha
I have read that Unicode (UTF-8) was not enabled by default in the mysql-4.1.0-alpha binaries. How can I enable it? What should I change in the code to do so?
Problems Compiling Mysql In Alpha With Tru64Unix V5.1
------=_NextPart_000_0019_01C2D0F9.BFBD6610 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hello There, I try to compiling Mysql V4.0 in the Alpha/Tru64 Unix V5.1a. I have installed in the Alpha C++ and C version 6.5, and gcc 3.3 and GNU MAKE 3.8. Follow the Steps. 1- Dowload from http://www.mysql.com/downloads/mysql-4.0.html in the SOURCE DOWNLOADS >> Tarball(tar.gz) 2- I saved in the /usr/local/ 3-Gunzip mysql-4.0xx.tar.gz 4-Tar mysqlxxxx 5-CC=cc CFLAGS=-O CXX=gcc CXXFLAGS=-O3 ./configure --prefix=/usr/local/mysql 6-Make # make No suffix list. make all-recursive No suffix list. Making all in . No suffix list. Making all in include No suffix list. Make: % rule can only use a single ':'. Stop. *** Exit 1 Stop. *** Exit 1 Stop. ------=_NextPart_000_0019_01C2D0F9.BFBD6610--
MySql 4.0.2 Connector
I need a recommendation for the most stable/tested version of Connector for MySQL V4.0.2. My web host is running V4.0.2 and I'm having problems with connections. I am currently running V1.0.7 of connector. Is that the best version? I apparently have problems with connection pooling not working quite right, so that intermittently I have problem getting a connection because the pool is exhausted.
Mysql-connector
what is the difference between "mysql-connector-java-3.1.9-bin-g.jar" and "mysql-connector-java-3.1.9-bin.jar"?
Connector/J 2.0.14 And MySQL 4.1.15,
I wish to connect the database with this old version of the Connector. I need it because I use JDK 1.1.8, and the newest Connector requires a newer JDK. This is all I get. java.sql.SQLException: Cannot connect to MySQL server on ourserver:correctport. Is there a MySQL server running on the machine/port you are trying to connect to? (java.lang.NumberFormatException) With the lastest 3.0.x Connector/J and JDK 1.5 I can communicate with the database without problems.
MySql Connector NET
When I try to create and Fill DataAdapter in VisualStudio with MySqlCommand (which is a stored procedure with SELECT statement) I got an error about invalid key constraint. Can anyone send me example how to execute stored procedure (only got SELECT statement) in VisualStudio and fill DataAdapter?
MySql Connector/NET Pooling
I am trying to configure my asp.net application to work with MySQL using Connector/NET and I wish to use connection pooling. What is the best way to do this? This is what I have so far: MySqlConnection myConnection; MySqlDataAdapter myDataAdapter; DataSet myDataSet; String strSql; myConnection = new MySqlConnection("server=localhost; user id = testuser; password=abc123; database=test;pooling=false;"); strSql = "Select * From Users;"; myDataAdapter = new MySqlDataAdapter(strSql, myConnection); myDataSet = new DataSet(); myDataAdapter.Fill(myDataSet, "mytable"); DataGrid1.DataSource = myDataSet; DataGrid1.DataBind(); Now, I was thinking about putting the connection string in the web.config file with pooling=true, but I a not sure what that would do. I checked the documentation for Connection/NET and it doesn't give any information on the pooling parameter. What happens if I set it to true? Where do I specify the size of the pool? Do I need to make any changes on IIS or MySQL itself?
MySql Obdc Connector
I'm newbie using mysql with visual basic .net I'm trying to connect to the mysql and I've got the message "Unable to get the catalog" I have installed the obdc driver as shown in the mysql web, I have the OBDC.NET driver from microsoft too... I have created the obdc source... mysql is running and I can connect it by php, and admin tools
MySQL And VB .Net 2003 - Connector
I need to connect to a client's SQL server to create a custom GIU. While browsing through the connector downloads pages, I found the following connectors: MySQL Connector/ODBC 3.51 Download Connector/Net 5.1 Can you please let me which connector to use which VB .Net 2003?
MySQL Connector/j Version
I need to have a version of the connector/j which supports callableStatement, as to return a resultset from a stored procedure. I am using a JDBC and java programming to connect to mysql which uses sqlyog interface. My current version of connector/j gives me an error saying callablestatements not supported. Which is the best one to use? Another quick question what is the difference between source and binaries (tar.gz and zip), maybe a stupid question. I have noticed there is connector/j 5.0.3 and connector/j 3.1.13. I am not sure which 1 i have currently. Is there a way to verify which one I have.
MySQL Connector/J License.
I have a question about the license for MySQL Connector/J. If I write an aplication that uses MySQL Connector/J, can I sell it? Can I distribute the MySQL Connector/J jar file with my aplication?
Php/mysql Connector For Solaris
I recently installed mysql 5 standard package for solaris on a solaris 9 machine. I also have an apache2/php5 installed and operating on a solaris 9 machine. I'm trying to connect to mysql server via php. I already granted the apache2/php5 server permission to access the database, but I'm still getting denied (Could not connect: Host 'apache2php5_server' is not allowed to connect to this MySQL server). Do I need to install some module in order to accomplish my task? Is there a php/mysql connector I need to install? If so, is there a solaris version?
MS Access And MySQL Connector
I have just installed MySQL on a test box and are testing it by moving our old Access database to MySQL, but keeping the forms and reports front end in Access for now until we migrate them to ColdFusion. The problem is whenever we try to link across the network to the MySQL tables from within Access 2002, it crashes. I have tried to connect by creating a User database, and it connects when I test it, it sees the databases during setup, etc. But once the link starts from within Access, Access crashes. I have tried making a System database, and again it connects and tests fine, can connect through the data query in Excel 2002 and see all the tables, but crashes in Access when I try to link. I have updated the MDAC to version 2.8, I have applied the JetEngine 4.0 Pack 8, I have tried the version two of the MySQL connector 3.51.12-2, I have checked all the permissions and the test user we created has full access to the database and tables. We are operating MS Access 2002 SP3, on Windows 2000 SP4 all fully patched. This is happening on multiple PC's and hampering my selling this database as the way to go.
Cannot Connect MySql 5.0 By Connector/NET 1.0
I try to connect mysql by this code: string connStr = "database=mtg;server=wdev057;user id=root;Password=; pooling=false" MySqlConnection c = new MySqlConnection( connStr ); c.Open(); but Error "An unhandled exception of type 'System.AgumentException' occurred in mysql.data.dll Additional information: Item has already been added. Key in dictionary:"read_only" Key being added:"read_only" " please tell me howto slove my problem.
MySQL Caching And .NET Connector
" It was issued as a prepared statement, even if no placeholders were employed. For example, the query used here is not cached:" Would parameterized queries made through the .NET Connector be available to be cached? My guess is no but would like clarification.
Mysql Connector Java JAR
I am making a Java Applet connects to mysql database, it works well in application mode. When I run it in applet mode, obviously the client running the applet should have the mysql connector file (mysql-connector-java-3.0.8-stable-bin.jar). So the question is how to bundle this mysql jar file with my applet jar file. I've tried to make both 2 files together in the html file: archive="PCMApplet.jar;mysql-connector-java-3.0.8-stable-bin.jar" the GUI shows up but the connection call to database is failed: java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver It seems to me that the mysql-blah.jar is not being used.
Mysql-connector-java-3.1.13-bin
I've MYSQL 5 installed and I want to connect to MYSQL using BIE JBOSS . I had put the jar file mysql-connector-java-3.1.13-bin.jar in the deploy/jboss/bie.sar folder and in windows environment I was able to connect to the MYSQL DB. But when I try doing the same in LINUX environment , I get the following error , Could not create connection; - nested throwable: (java.sql.SQLException: Cannot connect to MySQL server on <IP>:3306. Is there a MySQL server running on the machine/port you are trying to connect to? (java.net.NoRouteToHostException)); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Cannot connect to MySQL server on <IP>:3306. Is there a MySQL server running on the machine/port you are trying to connect to? (java.net.NoRouteToHostException)))
Handheld And Mysql Connector/j Driver
can i use mysql connector /j driver in hanheld devices for connecting my handheld database through java application to the mySQl server database which is residing on desktop. Code:
Can't Connect To Mysql Server With J Connector.
I can't connect to mysql server using the mysql-connector-java-3.0.11. I was able to run the same program when I was running Suse 9.0 but since I install Suse 9.1, I can't connect. The error message is: java.sql.SQLException: Unable to connect to any hosts due to exception: java.net.ConnectException: Connection refused I'm using mysql-standard-4.0.14 and able to get in the mysql server by typing: Code:
How To Ship Mysql Connector Java JAR
I am making a Java Applet connects to mysql database, it works well in application mode. When I run it in applet mode, obviously the client running the applet should have the mysql connector file (mysql-connector-java-3.0.8-stable-bin.jar). So the question is how to bundle this mysql jar file with my applet jar file. I've tried to make both 2 files together in the html file: archive="PCMApplet.jar;mysql-connector-java-3.0.8-stable-bin.jar" the GUI shows up but the connection call to database is failed: java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver It seems to me that the mysql-blah.jar is not being used.
Install Error MySQL Connector
I tried to install the ADO connector on Win XP and recieved the following error: InstallUtilLib.dll: Unknown error in CorBindToRunTimeHost (0x80131700). Another user reported this error and said it was resolved but did not say how it was resolved.
Ship Mysql Connector Java JAR
I am making a Java Applet connects to mysql database, it works well in application mode. When I run it in applet mode, obviously the client running the applet should have the mysql connector file (mysql-connector-java-3.0.8-stable-bin.jar). So the question is how to bundle this mysql jar file with my applet jar file. I've tried to make both 2 files together in the html file: archive="PCMApplet.jar;mysql-connector-java-3.0.8-stable-bin.jar" the GUI shows up but the connection call to database is failed: java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver It seems to me that the mysql-blah.jar is not being used.
Can't Connect To Mysql Server With J Connector.
I can't connect to mysql server using the mysql-connector-java-3.0.11. I was able to run the same program when I was running Suse 9.0 but since I install Suse 9.1, I can't connect. The error message is: java.sql.SQLException: Unable to connect to any hosts due to exception: java.net.ConnectException: Connection refused I'm using mysql-standard-4.0.14 and able to get in the mysql server by typing: bin/mysql -uroot -ptest The /etc/my.cnf file is the default one from support-files/my-medium.cnf The #skip-networking is comment out. Try to telnet localhost 3306 and it display the following text: Trying 127.0.0.1... Connected to localhost. Escape character is '^]'. 4 4.0.14-standard-log|0x-qw$E,Connection closed by foreign host.
MySQL ODBC Connector Username Issue
I am having trouble connecting to a MySQL db using the ODBC Connector. I've tried 2.5, 3.51, and even an alpha of v5 and all get the same error. The error says [MySQL][ODBC 3.51 Driver]Domain (xxx@xxxxxxxxxx.x) not found Disconnecting. It appears that the username only accepts 16 characters. I am trying to connect to a hosted db and I can't control the username. I've seen this happen on some machines but not others. What is going on and how can I get connected?
5.0.2 Alpha On XP
Is ANYONE able to run 5.0.2 alpha on Windows 2000 / XP? Specifically, I am referring to the seemingly still-unresolved critical bug http://bugs.mysql.com/bug.php?id=7475 Does anyone know where I might be able to find Windows binaries for 5.0.1?
Where <field> Is Not Alpha
I have a companies table and I need to sort the names using PHP. From A-Z is fine cause I have each link pointing to the right letter. But there are some companies that start with numeric numbers or even # @ other charecters. My question is how do I make a Select query to get all that dosen't start with a letter? select * from companies where name not like 'alpha%'; its the only thing i though about. and I actualy cant search the mysql manual cause I don't know how to call this problem.
Views Support In 5.0.0-alpha
from 1.8.5.6 Views: "Views are currently being implemented, and will appear in the 5.0 or 5.1 version of MySQL Server." i see the stored functions/procedures being added to the 5.0.0-alpha release but i do not see any support for views still. are they going to appear later in 5.0 or we would have to wait till 5.1 ?
Can't Connect From Localhost With 4.1.1 Alpha
I can connect from SQLYog,MySqlCC,jdbc from remote with no problem. However, when I try to connect(mysql -u root) from localhost, then I get access denied. Checked the user table and root can connect from anywhere(%). I am running 4.1.1 alpha on Red Hat with the --old-password option. TIA.
Dump Problem With 5.0.2 Alpha
I've just installed mysql 5.0.2 alpha on Windows 2000 I've tried to make a dump of one my DB shell> mysqldump db_name > myDump.sql I've an Exception with access violation.
Can't Connect From Localhost With 4.1.1 Alpha
I can connect from SQLYog,MySqlCC,jdbc from remote with no problem. However, when I try to connect(mysql -u root) from localhost, then I get access denied. Checked the user table and root can connect from anywhere(%).
MySql Problem With Unicode, MySql Connector/Net And C#
I have a problem regarding unicode characters and MySql. I am using MySql 4.1 and MySql Connector/NET together with C#. My question is whether I' am making a silly mistake (or not), by not being able to store unicode characters in a simple table. The database I have created is supposed to be in unicode: 'CREATE DATABASE test CHARACTER SET utf8'. Now, connecting from C#, i am trying to write into a simple table, with one column, the value 'u0120u0121u0125u0411' but when I am retrieving the value from the table, '????' is returned as a result. I don't know if its relevant, but i have checked that the server and connection are using unicode encoding: SHOW VARIABLES LIKE 'character_set_server' which returns 'utf8' as a result. also: SHOW VARIABLES LIKE 'character_set_connection' returns 'utf8' as a result.
URGENT: Error 1316 On Install Of MySQL Connector/ODBC Driver 3.51
I have my Vice President's laptop and trying to install the ODBC drivers for reporting that he needs.. and am facing a time crunch. I'm getting the following error, which I've never run into before. I thought the setup file was corrupt, so I re-downloaded her from another mirror, but I get the same error. ERROR 1316. A network error occurred while attempting to read from the file C:DOCUME~1cbockLOCALS~1Tempmysql-connect or -odbc-3.51.12-win32.msi
Query Error With Alpha Input
I am trying to look for multiple values in a mySQL table. For example, I am trying to pull 3 records based on CPT (5 alpha numneric characters). For example, I am trying to pull: 99201 A0040 99205 If I use this select criteria, I get the first record but then nothing else:
2nd Request, Alpha & Numeric Queries
I am trying to pass through a string that I am exploding into individual values to use in a query. For example, I want to pull the following three values through a query: 99201 A0040 99211 When I run it through the following query (it's missing some html tages, just trying to do a dry run) i twill run the first value through (regardless if it's a alpha based or numeric based), but after that it hits the else phase of the if (mysql_num_rows($mcalookup) >= '1') { code. Any clues what's going on? BTW< if I strip off the ' ' around the variable, it dies when it hits the alpha based variable. Code:
Selecting Entries That Begin With Non-alpha Characters
I'm sure this has been answered before, but I had a tough time composing a search for this on google or here ... Basically what I'm attempting to do is formulate a MYSQL query that will select all entries begining with non-alpha characters, primarily all those that begin with numbers. Is there a better option than just a bunch of co-joined statements ... like Ɔ%' OR like Ƈ%'
J Connector Jdk / Jre
My application uses J Connector's 'mysql-connector-java-3.1.6-bin.jar' file with jdk 1.5 on my Win 2000 system to connect to MySQL running on a Linux machine on my LAN and it works fine from within JDK. However it does not work (does not register the 'MySQL J Connector' driver) if I run my application's jar file using JRE 1.5 which is also installed on my Win 2000 system. Can J Connector's 'mysql-connector-java-3.1.6-bin.jar' somehow be built into my application's jar file? Or should it just be placed somewhere in the JRE directory tree and, if so, then where?
.net 2.0 Connector
About to develop an asp .net site on a windows 2003 server. I am using Visual Basic .net 2005 to constuct the site. What type of connection to mySQL should I use - e.g. ODBC or mySQL's .net connector?
PHP Connector
I have MySQL, Apache, and PHP5 installed. The last thing I need to do is to install the PHP connector, but when I go to the http://dev.mysql.com/downloads/connector/php/ link, the directory does not exist :( Does anyone know of another way to obtain and install the PHP connector for MySQL? I am just setting things up on my local system to start learning PHP development, but without the connector I am sort of stuck.
ASP Connector
I have set up a DSN connection on my local server. The test connections works fine. It is connecting to an external mysql database. However when I try to connect using a script it gives me a connection error I am using asp 2.0 and the latest mysql driver for ODBC The code is as follows: Code:
Connector/J Using JSP
we've installed MySQL on a Windows XP machine, but cannot connect to it using JSP/Servlet. An error message comes up saying: java.sql.SQLException: General error, message from server: "Incorrect database name 'water'" The database water exists on the server. Class.forName( "com.mysql.jdbc.Driver" ).newInstance(); con = DriverManager.getConnection("jdbc:mysql://localhost/water ?user=root&password="); yes, we've tried different databases and the error persists; yes, we've tried different users and passwords and the error persists; yes, we looked at the Connector/J documentation and sintax and it is OK yes, we used google and search for errors but no luc. Code:
What Connector To Use
What is the best choice for establishing a connection between the asp.net web site and the mySQL database? I will be using asp .net 2.0, and IIS 6.0. The server will be used for multiple web sites with product databases. I am aware of the issues with a release of the new .net connector version, but I am also aware that compiling the old 1.0.7 connector under .net 2.0 seems to cure any issues (?). Either way, whats the best choice - ODBC or .net Connector?
|
TRACKER
