RE: SQL_CALC_FOUND_ROWS using ODBC driver

2007-02-19 Thread Bonnett, John
: SQL_CALC_FOUND_ROWS using ODBC driver Hi, I've used PHP with MySQL and I was able to count the rows of a table by using the following code: SELECT SQL_CALC_FOUND_ROWS * FROM MyTableName; SELECT FOUND_ROWS(); However, I would like to do the same thing using Visual Basic 6... When I set the RS.Source t

Re: SQL_CALC_FOUND_ROWS using ODBC driver

2007-02-16 Thread Nuno Vaz Oliveira
27;t figured this out because using the debug features of VB6 it only show Fields 1 to 38 with the values of my first record (I was using LIMIT 1). Jess Balint wrote: Since you are asking for the row count from the database and not the driver, you have to treat it like a normal result. So rs.Fie

Re: SQL_CALC_FOUND_ROWS using ODBC driver

2007-02-15 Thread Jess Balint
RecordsCount = 1 > > How can I work this out? Since you are asking for the row count from the database and not the driver, you have to treat it like a normal result. So rs.Fields(1) should contain the row count. Jess -- MySQL General Mailing List For list archives: http://lists.mysql

Re: SQL_CALC_FOUND_ROWS using ODBC driver

2007-02-15 Thread Nils Meyer
Nils Meyer wrote: > SELECT SQL_CALC_FOUND_ROWS doesn't make much sense without a where clause by the way. LIMIT, not where. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SQL_CALC_FOUND_ROWS using ODBC driver

2007-02-15 Thread Nils Meyer
Hi, Nuno Oliveira wrote: When I set the RS.Source to the first SELECT statement and open it, it run OK but I need to close the RS and open it again using the second SELECT statement. After any of this operations I get a Recordset->RecordsCount = 1 That is actually a correct figure, SELECT F

SQL_CALC_FOUND_ROWS using ODBC driver

2007-02-14 Thread Nuno Oliveira
Hi, I've used PHP with MySQL and I was able to count the rows of a table by using the following code: SELECT SQL_CALC_FOUND_ROWS * FROM MyTableName; SELECT FOUND_ROWS(); However, I would like to do the same thing using Visual Basic 6... When I set the RS.Source to the first SELECT statement

Re: mysql driver for C++

2006-09-12 Thread Nzer Zaidenberg
check out mysql++ I dont think there is a package but configure, make, makeinstall works for me (on FC5, with mysql++ 1.7.40 and 2.1.1) - Original Message From: Shain Lee <[EMAIL PROTECTED]> To: MySql Sent: Tuesday, September 12, 2006 11:31:02 AM Subject: mysql driver for C+

mysql driver for C++

2006-09-12 Thread Shain Lee
Hi , Could you please tell me , how can i install C++ , mysql driver in Fedora core 5 ? Is that available for any platforms ? does YUM supports for install mysql c++ ? please help me , its really urgent . Thank you, Shaine. - Yahoo! Cars NEW

Re: EOFException with jdbc driver

2005-09-15 Thread Stefan Kuhn
Hi Mark, thanks for your answer. See comments. > > Stefan, > > Something is closing the network connection abrubtly between JDBC and > your MySQL server. Things to check are: > > 1) Connections don't sit longer than 'wait_timeout' on the server. I am actually using connection pooling (the torque sy

Re: EOFException with jdbc driver

2005-09-15 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan Kuhn wrote: > Hi all, > I have a Java webapp using a mysql database. It all used to run well, but I > now frequently get the following error: > > 2005-09-15 11:33:32,115 [Thread-23] ERROR rotation - > com.mysql.jdbc.CommunicationsException: C

EOFException with jdbc driver

2005-09-15 Thread Stefan Kuhn
Hi all, I have a Java webapp using a mysql database. It all used to run well, but I now frequently get the following error: 2005-09-15 11:33:32,115 [Thread-23] ERROR rotation - com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCE

Re: URGENT --- OSX 10.4 ODBC driver error

2005-09-11 Thread Josh Chamas
it was reopened, max OSX and other applications are not effected etc. etc." its version : 3.51.11-1 so this ODBC driver will not work on the 10.4 machine? as right next to the download it states OSX v10.3 (installing on 10.3 works no problem) Sorry, I can't help here, but noted t

URGENT --- OSX 10.4 ODBC driver error

2005-09-06 Thread Andrew stolarz
OSX and other applications are not effected etc. etc." its version : 3.51.11-1 so this ODBC driver will not work on the 10.4 machine? as right next to the download it states OSX v10.3 (installing on 10.3 works no problem) many thanks Andrew

Re: myodbc driver araise full table scan

2005-08-08 Thread Gleb Paharenko
Hello. Please, provide more information about your software and oprating system. Include versions of MySQL and MyODBC. See: http://dev.mysql.com/doc/mysql/en/bug-reports.html http://dev.mysql.com/doc/mysql/en/myodbc-bug-report.html "chenwei" <[EMAIL PROTECTED]> wrote: >i

myodbc driver araise full table scan

2005-08-08 Thread chenwei
mysql,您好!  i use myodbc to connect to a big table, to my surprise, myodbc araise full table scan and crash. could anybody help me with that?  致 礼!   chenwei [EMAIL PROTECTED]  2005-08-08

Re: Problem with datetime values and MyODBC driver

2005-08-05 Thread Gleb Paharenko
Hello. I was unable to find similar bug in bugs database, but there were several problems with datetime. Some of them were solved by choosing different versions of software. Check if your problem exists on MySQL 4.1.13. Maybe ODBC tracing help you to localize the problem. If you have a repro

Re: Problem with datetime values and MyODBC driver

2005-08-05 Thread Dušan Pavlica
(and different ODBC drivers). And thus I must set query parameters to their correct data types and ODBC driver should do the conversions. And that is what is not working. I will probably fill a bug report and will see. Dusan - Original Message - From: Dwi Putra L To: Dušan Pavlica

Problem with datetime values and MyODBC driver

2005-08-04 Thread Dušan Pavlica
Hello, I'm working in C++ Builder 6.0 and I'm trying to create application which could connect through ADO components to different databases using ODBC drivers. If I create TADOQuery object which has datetime parametr and I fill this parametr with valid datetime value then I can see in MYSQL's qu

Re: JDBC driver problem with sql LIMIT

2005-03-30 Thread Mark Matthews
eption in thread "AWT-EventQueue-0" java.lang.OutOfMemoryError: Java heap > space > Exception on Toolkit thread: java.lang.OutOfMemoryError: Java heap space > java.lang.OutOfMemoryError: Java heap space > > Is LIMIT supported with the JDBC driver? > thank you everygody

JDBC driver problem with sql LIMIT

2005-03-30 Thread l'eau
emoryError: Java heap space java.lang.OutOfMemoryError: Java heap space Is LIMIT supported with the JDBC driver? thank you everygody Laurie -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL Driver

2005-03-21 Thread Ed
Does anyone know anything about the MySQL (3.x) Driver that comes installed with coldfusion? No luck with yahoo search or coldfusion documentation. Hi all, I am trying to create a datasource for mysql database. I tried using the mysql (3.x) driver but i got this error: Connection verification

Re: driver question

2005-03-07 Thread Mark Matthews
Anyway what I found was a problem. When > using the driver, and I say select * from foo, I get the following error, > which makes sense, because it says it cannot convert 00 which is > null of course. Scott, '00' is _not_ NULL. It's an invalid

driver question

2005-03-07 Thread Scott Purcell
into foo, I insert the create_date of course when new foo records are inserted. But I do not insert anything for the approved_date, because the foo is not known yet. Anyway what I found was a problem. When using the driver, and I say select * from foo, I get the following error, which makes sense

Re: JDBC driver support

2005-01-11 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Manish wrote: > We're having some problems in getting MySQL 4.1.8 to work with JDBC drivers > in - > mysql-connector-java-2.0.14-bin.jar > > Do these drivers work with MySQL 4.1.8? hey seem to be working fine with > 4.0.14 version of MySQL. > Is there

Re: JDBC driver support

2005-01-11 Thread Stephen Moretti
Manish wrote: We're having some problems in getting MySQL 4.1.8 to work with JDBC drivers in - mysql-connector-java-2.0.14-bin.jar Do these drivers work with MySQL 4.1.8? hey seem to be working fine with 4.0.14 version of MySQL. Is there any compatibility data available for all these JDBC drivers a

JDBC driver support

2005-01-10 Thread Manish
We're having some problems in getting MySQL 4.1.8 to work with JDBC drivers in - mysql-connector-java-2.0.14-bin.jar Do these drivers work with MySQL 4.1.8? hey seem to be working fine with 4.0.14 version of MySQL. Is there any compatibility data available for all these JDBC drivers and MySQL vers

RE: No suitable driver

2004-06-30 Thread Schalk
Try changing driver to Driver Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Development.Multimedia.Branding emotionalize.conceptualize.visualize.realize Tel: +27125468436 Fax: +27125468436 email:[EMAIL PROTECTED] web: www.volume4.co.za This

No suitable driver

2004-06-30 Thread Sridevi Salagrama
Hi, I have just down loaded the mysql connector/j version 3.0.14- production. I have set the classpath for the jar file and the url that I am using for the driver is com.mysql.jdbc.driver. I have not been succesful. Can any body please tell me what i might be doing wrong. Thanks

Re: Error in JDBC retrieval of mediumint column (mysql4.1.2b-alpha-win and java-3.1.2-alpha driver)

2004-06-28 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Oliver Chua wrote: > To be able to use subqueries, I'm now using mysql-4.1.2b-alpha-win.zip > I'm using mysql-connector-java-3.1.2-alpha.zip as my jdbc driver to connect > to the db... > > I'm selecting some columns fr

RE: SQLException when retrieving resultset containing mediumint ( 4.1.2b-alpha-win db and java-3.1.2-alpha driver)

2004-06-28 Thread Victor Pendleton
driver) I'm using mysql-4.1.2b-alpha-win.zip and mysql-connector-java-3.1.2-alpha.zip to access db via JDBC. The column is mediumint(9) It was created using type mediumint, somehow it was changed to mdiumint(9) I think there may be a problem in the size... java.sql.SQLException: Unknown type

SQLException when retrieving resultset containing mediumint (4.1.2b-alpha-win db and java-3.1.2-alpha driver)

2004-06-28 Thread Oliver Chua
I'm using mysql-4.1.2b-alpha-win.zip and mysql-connector-java-3.1.2-alpha.zip to access db via JDBC. The column is mediumint(9) It was created using type mediumint, somehow it was changed to mdiumint(9) I think there may be a problem in the size... java.sql.SQLException: Unknown type '9 in column

Error in JDBC retrieval of mediumint column (mysql4.1.2b-alpha-win and java-3.1.2-alpha driver)

2004-06-28 Thread Oliver Chua
To be able to use subqueries, I'm now using mysql-4.1.2b-alpha-win.zip I'm using mysql-connector-java-3.1.2-alpha.zip as my jdbc driver to connect to the db... I'm selecting some columns from a table where the column is created using mediumint. Somehow, after creation, it beco

Re: ADO driver?

2004-04-13 Thread Giulio
ng it succesfully on some applications on VB 6, without problems. Thanks for the message... but, I'm not using VB... Can this project be used in place of an ADO driver? I guess not, right? Well, I think yes, It should follow quite well standard ADO methods and functions, You must test it. anyway

Re: ADO driver?

2004-04-13 Thread Martijn Tonies
applications on > VB 6, without problems. Thanks for the message... but, I'm not using VB... Can this project be used in place of an ADO driver? I guess not, right? With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene P

ADO driver?

2004-04-13 Thread Martijn Tonies
Hi all, Is there an ADO (NOT ADO.NET) driver for MySQL? If so, where? Thanks in advance. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For

is XA Driver available

2004-02-27 Thread Elsan
Hi, Does MySQL support distributed transaction using weblogic app server? If yes, please let me know from where should I download the XA driver? It is urgent, please reply as soon as possible. Regards, Elsan. __ Do you Yahoo!? Get better spam protection with

Re: unsupported driver trouble

2004-01-21 Thread Moritz von Schweinitz
with os10.3.2 server, mysql v4.0.16, and MoveableType 2.6 I'm trying to initialise the moveabletype system by running mt-load.cgi and am recieving the following error: "Unsupported driver MT::ObjectDriver::DBI::mysql: Can't locate DBI.pm in @INC..." I've checked in m

unsupported driver trouble

2004-01-20 Thread tait sanders
g the following error: "Unsupported driver MT::ObjectDriver::DBI::mysql: Can't locate DBI.pm in @INC..." I've checked in my mt.cfg file and I have added: "ObjectDriver DBI::mysql Database /var/mysql/mtweblog DBUser labadmin" so I don't understand what's going on.

No Suitable Driver

2003-10-27 Thread candy b
This is the SQLException that I get when I try to run my Java code. Since this is a program that has worked in the past, I think that problem is how I'm linked to MYSQL. Any ideas on what could be wrong? Candy _ Surf and talk on

Re: not found driver 3.51 not found

2003-10-16 Thread Director General: NEFACOMP
Maybe installing MyODBC 3.51.06 will solve the problem. I am not sure. Thanks Emery - Original Message - From: "miguel solorzano" <[EMAIL PROTECTED]> To: ".eric" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, October 16, 2003 05:16 Subjec

Re: not found driver 3.51 not found

2003-10-15 Thread miguel solorzano
At 20:03 15/10/2003 -0500, .eric wrote: Hi, okay this is strange. every time i try to start mysql via WinMySQLadmin, i get the error message in the MyODBC box containing the following error: Not Found The above should be for drive MyODBC 2.50 Driver 3.51 Not Found Well on my machine the above

not found driver 3.51 not found

2003-10-15 Thread .eric
okay this is strange. every time i try to start mysql via WinMySQLadmin, i get the error message in the MyODBC box containing the following error: Not Found Driver 3.51 Not Found ive uninstalled completly and reinstalled mysql twice and i cant seem to get mysql running again. i even uninstalled

RE: Error: "unable to execute query" - Problems using Win32 MySQL ODBC driver

2003-10-09 Thread Fortuno, Adam
Pako, That blows my theory. Regards, Adam -Original Message- From: Pakó Géza [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 2:32 PM To: Fortuno, Adam Subject: Re: Error: "unable to execute query" - Problems using Win32 MySQL ODBC driver i dont use odbc. i

RE: Error: "unable to execute query" - Problems using Win32 MySQL ODBC driver

2003-10-09 Thread Fortuno, Adam
). You're getting the same issue going from Win32 to Linux via ODBC. I wonder if its a bug with the ODBC driver? What version are you using? Anyone else have this problem? Regards, Adam -Original Message- From: Pakó Géza [mailto:[EMAIL PROTECTED] Sent: Thursday, October 09, 2003 2:22

Re: jdbc-Driver - foreignkeys - OOo

2003-09-21 Thread Dieter Kroemer
(and has for quite some time). What version of MySQL are you > using? I installed yesterday mysql 4.0.15 (and if I start phpMyAdmin I see this number in the Browser) > The most recent two releases (4.0.14 and 4.0.15) have changed the > output format for the metadata that the JDBC dri

Re: jdbc-Driver - foreignkeys - OOo

2003-09-21 Thread Mark Matthews
t with MySQL I could do > all my jobs in schools with only _one_ database). > Till now, I thought mysql can't work with foreign keys, but I read, that > tables in the innodb-format can do this. But if I work with the jdbc-driver > and OOo, OOo doesn't support the foreignkey

jdbc-Driver - foreignkeys - OOo

2003-09-21 Thread Dieter Kroemer
ought mysql can't work with foreign keys, but I read, that tables in the innodb-format can do this. But if I work with the jdbc-driver and OOo, OOo doesn't support the foreignkeys-gui :-(( (the cause is the jdbc-Driver) Does anybody know, if a future version of the jdbc-Driver wi

Fw: Borland may have fixed the dbExpress driver for MySQL transactions

2003-08-24 Thread Heikki Tuuri
Hi! Many people have complained over years that Borland's dbExpress driver does not work with MySQL and transactions, because it disconnects from mysqld after each SQL statement. The postings below suggests that this problem might now be fixed by Borland. Best regards, Heikki Tuuri Innoba

Re: Suitable Driver Error

2003-08-22 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Luong Phan wrote: > Hi all, > > In my web application, I use mysql supported by Redhat Linux 7.3 to store database, jakarta-tomcat-3.2.4, > mysql-connector-java-3.0.6-stable-bin.jar, and JSP. > > Every time, I run the program: > > import java.io.IOExc

Suitable Driver Error

2003-08-22 Thread Luong Phan
ager.getConnection(url,username,password); statement=connection.createStatement(); }catch(ClassNotFoundException e){ System.err.println("Failed to load JDBC/ODBC driver."); e.printStackTrace(); }catch(SQLException e){

RE: deleting old odbc driver

2003-07-30 Thread Bill J. Vallance
Gustavo, At this moment this is the only way I know how to remove the old ODBC driver. Run regedit go to "My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI". Find the folder with the old MySQL driver name (most likely just MySQL). Open up that folder and you should see a co

deleting old odbc driver

2003-07-30 Thread Gustavo A. Baratto
I want to remove the old 2.50 myodbc driver. I installed a new version of myodbc, and the old driver is still being diplayed in the list... I know this is not really a mysql problem, but I'm not much of a windows user and google didn't return good results this time... maybe someone

RE: Driver 3.51 Not Found

2003-06-23 Thread Mike Hillyer
That would be because you have not installed it. MyODBC does not install by default, and you may not need it. If you are going to be accessing your new database through ODBC, then go to http://www.mysql.com/downloads/api-myodbc-3.51.html where you can download the latest driver. If you will not be

RE: Driver 3.51 Not Found 2

2003-06-23 Thread Mike Hillyer
For automated setup under windows, the MyODBC-3.51.06.exe file should be downloaded. Regards, Mike Hillyer www.vbmysql.com > -Original Message- > From: Ellen Cain [mailto:[EMAIL PROTECTED] > Sent: Saturday, June 21, 2003 4:37 PM > To: [EMAIL PROTECTED] > Subject: Driver

Re: Driver 3.51 Not Found 2

2003-06-23 Thread Egor Egorov
"Ellen Cain" <[EMAIL PROTECTED]> wrote: > > I downloaded MyODBC-3.51.06.zip , unzipped it, and there isn't a setup.exe file - > only 'setup.c' > Should MyODBC-3.51.06.exe be downloaded? Did you download MyODBC from MySQL site? Please, download MyODBC-3.51.06.exe from one of the mirrors:

Driver 3.51 Not Found 2

2003-06-21 Thread Ellen Cain
I downloaded MyODBC-3.51.06.zip , unzipped it, and there isn't a setup.exe file - only 'setup.c' Should MyODBC-3.51.06.exe be downloaded?

Driver 3.51 Not Found

2003-06-21 Thread Ellen Cain
Hello, I'm new to mySQL. In Windows, after clicking winmysqladmin.exe in Explorer, I get the message - Driver 3.51 Not Found. Any help would be greatly appreciated. Ellen

Query cache not working with JDBC driver?

2003-06-09 Thread Greg
I have the query cache on MySQL 4.0.13-standard running and working fine, with a large amount of memory allocated to it. But it doesn't appear to be working with the MySQL JDBC driver access. I have used versions 2.0 and 3.0 of the JDBC driver. Although it will cache a query from the

Re: MySQL JDBC driver problem

2003-03-17 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Shu-Ping Lin wrote: > Hi, How are you? > > I have a problem to jdbc driver. My paltform is win2000 professional and > MySQL Server's version is 3.23.55. > > I use jdbc driver of mysql-connector-java-3.0.6-stable.jar and i

MySQL JDBC driver problem

2003-03-16 Thread Shu-Ping Lin
Hi, How are you? I have a problem to jdbc driver. My paltform is win2000 professional and MySQL Server's version is 3.23.55. I use jdbc driver of mysql-connector-java-3.0.6-stable.jar and i find some problems to this jdbc driver version. When i use some method about setting or getting S

Re: Websphere 4 JDBC Provider driver

2003-03-12 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Garth Dahlstrom wrote: Hi all, I'm wondering if anyone has configured IBM Websphere 4.0 to use MySQL as a JDBC Provider for Entity Beans (EJBs). The configuration is not anything like servlet config where you throw the MM driver in the WEB-IN

Websphere 4 JDBC Provider driver

2003-03-12 Thread Garth Dahlstrom
Hi all, I'm wondering if anyone has configured IBM Websphere 4.0 to use MySQL as a JDBC Provider for Entity Beans (EJBs). The configuration is not anything like servlet config where you throw the MM driver in the WEB-INF/lib directory. I haven't been able to find any indication t

Re: JDBC Driver Bug, does not appear to support auto commit off-selectionsnot detected in while loop if new insertions

2003-02-28 Thread Mark Matthews
select! This presents awkwardness with multi-threading and I have to do work-around such as not committing if a flag is set which should not be necessary. I have tried afew versions of you JDBC driver and it always performs the same. You should be able to make simple selects without having to commit

JDBC Driver Bug, does not appear to support auto commit off-selections not detected in while loop if new insertions

2003-02-28 Thread Emma Wansbrough
do work-around such as not committing if a flag is set which should not be necessary. I have tried afew versions of you JDBC driver and it always performs the same. You should be able to make simple selects without having to commit, the c api does exactly that! Here is some example java code to

MM driver / connector support for DB Acrhive

2003-02-10 Thread Ahmed S K Anis
HI, I would like to know if MM driver / Connector J for MySQL gives any facility to archive a database. Not sure if JDBC covers this. I have seen the mysqldump/ mysqlexport options but, i need to invoke the Archive and Restore from a Java program. Any bright ideas or solutions to this

MM driver / connector support for DB Acrhive

2003-02-10 Thread Ahmed S K Anis
HI, I would like to know if MM driver / Connector J for MySQL gives any facility to archive a database. Not sure if JDBC covers this. I have seen the mysqldump/ mysqlexport options but, i need to invoke the Archive and Restore from a Java program. Any bright ideas or solutions to this

Re: PROBLEM with your JDBC driver - mysql connector.

2003-02-02 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mufaddal wrote: PROBLEM with your JDBC driver - mysql connector. I am developing using jdk1.4.1 on Mac OS X. I am using the mysql driver - mysql connector java 2.0.14. I am creating a table in mysql thru java ... the code to do this

PROBLEM with your JDBC driver - mysql connector.

2003-02-01 Thread Mufaddal
PROBLEM with your JDBC driver - mysql connector. I am developing using jdk1.4.1 on Mac OS X. I am using the mysql driver - mysql connector java 2.0.14. I am creating a table in mysql thru java ... the code to do this is below: try

re: ODBC Driver?

2003-01-24 Thread Egor Egorov
On Friday 24 January 2003 01:29, Jeffrey Powell wrote: > I am preparing to migrate a client from using a large MS-ACCESS database to > using a linux hosted MySql as the datasource. Or at least I'd like to be > able to export tables as a backup. > > Please tell me where I can g

Re:ODBC Driver?

2003-01-24 Thread Nasser Ossareh
charset="us-ascii" From: Jeffrey Powell <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Organization: Yonezawa English School To: [EMAIL PROTECTED] Subject: ODBC Driver? Date: Fri, 24 Jan 2003 08:29:35 +0900 User-Agent: KMail/1.4.3 MIME-Version: 1.0 Content-Transfer-Encoding: quo

ODBC Driver?

2003-01-23 Thread Jeffrey Powell
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I am preparing to migrate a client from using a large MS-ACCESS database to using a linux hosted MySql as the datasource. Or at least I'd like to be able to export tables as a backup. Please tell me where I can get a driver. Thanks, - --

Re: No suitable driver ..... urgent..

2003-01-23 Thread Henning Heil
hello . . . did you install the necessary mysql driver you call in your jsp "ClassForName"-statement? you can find mm.mysql at sorceforge.net regards, henning nitsy wrote: Hello, I'm using MySQL 4.0.1 with Tomacat 3.3 & JSP. I'm getting this error every t

No suitable driver ..... urgent..

2003-01-23 Thread nitsy
Hello, I'm using MySQL 4.0.1 with Tomacat 3.3 & JSP. I'm getting this error every time i access my jsp page: "javax.servlet.ServletException: No suitable driver" Can anybody help me out.. i tried to download from download/J but it's not gettin opene

Re: JDBC driver / JBoss

2002-12-28 Thread miguel solórzano
At 11:57 29/12/2002 +1100, Greg Matthews wrote: Hi, If anyone has managed to get named pipes working under Windows XP with JBoss, would they be nice enough to forward the URL used? Only one note here: MySQL by default disables the named pipes. If you want the named pipes you must use at command

Re: JDBC driver / JBoss

2002-12-28 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Greg Matthews wrote: Mark, Version was 3.51.05. Hmmm, that looks like an ODBC driver version. MySQL Connector/J has two branches right now 2.0.x and 3.0.x, seeing as how you're using named pipes, you must be using 3.0.x something. &

Re: JDBC driver / JBoss

2002-12-28 Thread Greg Matthews
"Greg Matthews" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, December 29, 2002 11:27 AM Subject: Re: JDBC driver / JBoss > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Greg Matthews wrote: > > All, > > > > The documention on

Re: JDBC driver / JBoss

2002-12-28 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Greg Matthews wrote: All, The documention on the JDBC driver (v0.87) shows that ampersands are used to delimit driver parameters. I'm curious as to where you get a version # of '0.87'. As far as I know neither MM.MySQL or Connec

JDBC driver / JBoss

2002-12-28 Thread Greg Matthews
All, The documention on the JDBC driver (v0.87) shows that ampersands are used to delimit driver parameters. JBoss (www.jboss.org) stores datasource definitions in XML files, and so using & seems a bit problematic. Is there any way that the supported delimiters can be extended to use a

FW: bug in JDBC driver

2002-12-16 Thread Dmitry Zakharov
Hi ! Some times my application is hang-up. The stack trace contains the following: at java.net.SocketInputStream.socketRead(Native Method) at java.net.SocketInputStream.read(SocketInputStream.java:86) at java.io.BufferedInputStream.fill(BufferedInputStream.java:186)

Re: JDBC driver: Buggy for DatabaseMetaData.getImported/Exportedkeys ?

2002-12-03 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 j.random.programmer wrote: Hi: I am using Connector/J 3.0.2 against MySQL 3.23.52-max. My default table type is set to InnoDB (since I always use innodb). The following methods are acting strangely: - DatabaseMetaData.getImportedKeys() - Database

JDBC driver: Buggy for DatabaseMetaData.getImported/Exported keys ?

2002-12-03 Thread j.random.programmer
mated tool that examines a database and generated a java dbobjects layer. It's quite possible that I am missing something here but it's also possible that the driver is buggy because the expected and actual values diverge significantly. Best r

Re: Is the mysql JDBC driver thread safe?

2002-11-13 Thread Mark Matthews
[EMAIL PROTECTED] wrote: Hi all, i'm planning on using servlets for an application I am building What I need to know is if there are any thread safe JDBC drivers? MySQL Connector/J is thread-safe, but even though the JDBC spec states that the driver itself must be thread-safe, mo

Re: JDBC J/Connect driver is seriously slow against InnoDB

2002-11-04 Thread Mark Matthews
nd specifically problems with network adapters 'autoconfiguring' for full-duplex (read 'misconfiguring'). Make sure that your network adapters/drivers have no unsolved issues running full-duplex, and make sure all ports in the network topology (client, hub/switch, server) are run

Re: JDBC J/Connect driver is seriously slow against InnoDB

2002-11-04 Thread j.random.programmer
ur > code here on my > desktop runnin Linux, which is known not to have the > fastest java > support, to my test server (100 mbit private > network), and it takes 30 > seconds, > which is 5 seconds longer than 100,000 inserts using > DBI (which is using > native code to ac

Re: JDBC J/Connect driver is seriously slow against InnoDB

2002-11-03 Thread Mark Matthews
achine, read on for more CREATE TABLE T1 (A INT NOT NULL AUTO_INCREMENT, B INT, PRIMARY KEY(A)) TYPE=INNODB; CREATE TABLE T2 (A INT NOT NULL, B INT, PRIMARY KEY(A)) TYPE=INNODB; Now run the java driver (source shown at the end of this message). This takes a long time. The innodb benc

JDBC J/Connect driver is seriously slow against InnoDB

2002-11-03 Thread j.random.programmer
http://www.innodb.com/bench.html I am finding this to be more like 300-400 seconds. Try this: CREATE TABLE T1 (A INT NOT NULL AUTO_INCREMENT, B INT, PRIMARY KEY(A)) TYPE=INNODB; CREATE TABLE T2 (A INT NOT NULL, B INT, PRIMARY KEY(A)) TYPE=INNODB; Now run the java driver (source shown at the end of

Re: Questions on MySQL 3.23.36 and MM.MySQL JDBC Driver

2002-10-30 Thread Mark Matthews
Tan Phooi San wrote: Hi, I got some questions regarding MySQL 3.23.36 and MM.MySQL JDBC Driver. Hope you could help me on this. 1. Can both products mentioned above working in Red Hat Linux 7.3 or 8.0? You don't mention what version of MM.MySQL you're interested in, but sin

Questions on MySQL 3.23.36 and MM.MySQL JDBC Driver

2002-10-30 Thread Tan Phooi San
Hi, I got some questions regarding MySQL 3.23.36 and MM.MySQL JDBC Driver. Hope you could help me on this. 1. Can both products mentioned above working in Red Hat Linux 7.3 or 8.0? 2. What are the latest version of both products? 3. What are the differences between the latest version and both

FW: The request properties can not be supported by this ODBC Driver.

2002-10-21 Thread Alan McDonald
SQL ASP I can't seem to find any examples of saving text area form inputs to TEXT type fields. They all seem to be text inputs or strings being saved to varchar fields... Can someone point me to an example of saving large text quantities to a TEXT Type field in ASP? Thanks Alan McDonald http://www

RE: Need Driver to connect Unix SCO 5.2 Open Server to MySQL DB?

2002-10-03 Thread Chris Couture
is Couture Subject: RE: Need Driver to connect Unix SCO 5.2 Open Server to MySQL DB? Chris, If I understood you correctly, you have a Unix server that creates text string when an invoice is processed. That string of data is to be inserted into the MySQL database. Then you have a Windows application tha

RE: Need Driver to connect Unix SCO 5.2 Open Server to MySQL DB?

2002-10-03 Thread Chris Couture
This is what I thought. Thanks. I think we are almost there! Chris -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 8:51 AM To: Chris Couture Cc: [EMAIL PROTECTED] Subject: Re: Need Driver to connect Unix SCO 5.2 Open Server to MySQL

Re: Need Driver to connect Unix SCO 5.2 Open Server to MySQL DB?

2002-10-03 Thread gerald_clark
future. > >Thanks again for the help. > >Chris > > >-Original Message- >From: gerald_clark [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, October 02, 2002 9:12 AM >To: Chris Couture >Cc: [EMAIL PROTECTED] >Subject: Re: Need Driver to connect Unix SCO 5.2

RE: Need Driver to connect Unix SCO 5.2 Open Server to MySQL DB?

2002-10-02 Thread Chris Couture
elp. Chris -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 9:12 AM To: Chris Couture Cc: [EMAIL PROTECTED] Subject: Re: Need Driver to connect Unix SCO 5.2 Open Server to MySQL DB? Chris Couture wrote: >Thanks for the info. Le

Re: Need Driver to connect Unix SCO 5.2 Open Server to MySQL DB?

2002-10-02 Thread gerald_clark
com. > >Thanks so much for the help! > >Chris > You are welcome. > >-Original Message- >From: gerald_clark [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, October 01, 2002 3:16 PM >To: Chris Couture >Cc: [EMAIL PROTECTED] >Subject: Re: Need Driver to co

RE: Need Driver to connect Unix SCO 5.2 Open Server to MySQL DB?

2002-10-01 Thread Chris Couture
gerald_clark [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 3:16 PM To: Chris Couture Cc: [EMAIL PROTECTED] Subject: Re: Need Driver to connect Unix SCO 5.2 Open Server to MySQL DB? You need the client 'mysql' on the unix machine to talk to the server 'mysqld' on whatev

Re: Need Driver to connect Unix SCO 5.2 Open Server to MySQL DB?

2002-10-01 Thread gerald_clark
he MySQL server and it >has been up and running for 3 weeks now and seems stable. I have >installed MyODBC on the shipping computers and they connect. My >question is what type of driver do I need to put on the Unix machine t

Need Driver to connect Unix SCO 5.2 Open Server to MySQL DB?

2002-10-01 Thread Chris Couture
stable. I have installed MyODBC on the shipping computers and they connect. My question is what type of driver do I need to put on the Unix machine to make it where it can write insert statements directly to the database? Than

Re: Creating/droping database using mySQL JDBC driver

2002-09-30 Thread Clayburn W. Juniel, III
On Monday, September 30, 2002, at 03:53 24h, Slava Imeshev wrote: > Hello All, > > Could anyone help me with this issue? Is it > possible to create/drop database using mySQL > JDBC driver? > Yes. -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-77

Problem with ODBC Driver and Office XP

2002-09-23 Thread he
Hello, I m using WinXP / Office XP and need odbc support to create a circular letter. I have installed mysql, etc. all works fine. But I cant get Word to work with odbc drivers. They seem to work, they get connection To my database but word says something like this : "couldn't obtain table lists

Re: JDBC 3.0 Driver

2002-08-27 Thread Mark Matthews
Mike Duffy wrote: > Does anyone know if there is a good JDBC 3.0 Driver for MySQL? > > I would like to use the "getGeneratedKeys()" method. > > Thanks. > > Mike > > __ > Do You Yahoo!? > Yahoo!

  1   2   3   >