MySQL Connector/ODBC 5.3.13 has been released

2019-04-29 Thread Hery Ramilison
Dear MySQL users, MySQL Connector/ODBC 5.3.13, a new version of the ODBC driver for the MySQL database management system, has been released. The available downloads include both a Unicode driver and an ANSI driver based on the same modern codebase. Please select the driver type you need based

MySQL Connector/ODBC 8.0.16 has been released

2019-04-25 Thread Hery Ramilison
Dear MySQL users, MySQL Connector/ODBC 8.0.16 is a new version in the MySQL Connector/ODBC 8.0 series, the ODBC driver for the MySQL Server. The available downloads include both a Unicode driver and an ANSI driver based on the same modern codebase. Please select the driver type you need

MySQL Connector/ODBC 5.3.12 has been released

2019-01-27 Thread Balasubramanian Kandasamy
Dear MySQL users, MySQL Connector/ODBC 5.3.12, a new version of the ODBC driver for the MySQL database management system, has been released. The available downloads include both a Unicode driver and an ANSI driver based on the same modern codebase. Please select the driver type you need based

MySQL Connector/ODBC 8.0.14 has been released

2019-01-21 Thread Hery Ramilison
Dear MySQL users, MySQL Connector/ODBC 8.0.14 is a new version in the MySQL Connector/ODBC 8.0 series, the ODBC driver for the MySQL Server. The available downloads include both a Unicode driver and an ANSI driver based on the same modern codebase. Please select the driver type you need

MySQL Connector/ODBC 8.0.13 has been released

2018-10-22 Thread Kent Boortz
Dear MySQL users, MySQL Connector/ODBC 8.0.13 is a new version in the MySQL Connector/ODBC 8.0 series, the ODBC driver for the MySQL Server. The available downloads include both a Unicode driver and an ANSI driver based on the same modern codebase. Please select the driver type you need based

MySQL Connector/ODBC 5.3.11 has been released

2018-07-30 Thread Kent Boortz
Dear MySQL users, MySQL Connector/ODBC 5.3.11, a new version of the ODBC driver for the MySQL database management system, has been released. The available downloads include both a Unicode driver and an ANSI driver based on the same modern codebase. Please select the driver type you need based

MySQL Connector/ODBC 8.0.11 GA has been released

2018-04-19 Thread Kent Boortz
Dear MySQL users, MySQL Connector/ODBC 8.0.11 is the first GA version of the MySQL Connector/ODBC 8.0 series, the ODBC driver for the MySQL database management system. The available downloads include both a Unicode driver and an ANSI driver based on the same modern codebase. Please select the

MySQL Connector/ODBC 5.3.8 has been released

2017-05-01 Thread Hery Ramilison
Dear MySQL users, MySQL Connector/ODBC 5.3.8, a new version of the ODBC driver for the MySQL database management system, has been released. The available downloads include both a Unicode driver and an ANSI driver based on the same modern codebase. Please select the driver type you need based on

MySQL Connector/ODBC 5.3.6 has been released

2016-03-19 Thread karen langford
Dear MySQL users, MySQL Connector/ODBC 5.3.6, a new version of the ODBC driver for the MySQL database management system, has been released. The available downloads include both a Unicode driver and an ANSI driver based on the same modern codebase. Please select the driver type you need based on

MySQL Connector/ODBC 5.3.4 has been released

2014-07-18 Thread Hery Ramilison
Dear MySQL users, MySQL Connector/ODBC 5.3.4, a new version of the ODBC driver for the MySQL database management system, has been released. The available downloads include both a Unicode driver and an ANSI driver based on the same modern codebase. Please select the driver type you need based on

MySQL Connector/ODBC 5.2.7 has been released

2014-05-13 Thread Hery Ramilison
Dear MySQL users, MySQL Connector/ODBC 5.2.7, a new version of the ODBC driver for the MySQL database management system, has been released. The available downloads include both a Unicode driver and an ANSI driver based on the same modern codebase. Please select driver type you need based on the

MySQL Connector/ODBC 5.3.2 GA has been released

2014-04-07 Thread Hery Ramilison
Dear MySQL users, MySQL Connector/ODBC 5.3.2 GA, a new version of the ODBC driver for the MySQL database management system, has been released. The available downloads include both a Unicode driver and an ANSI driver based on the same modern codebase. Please select driver type you need based on

no binary and source code of MySQL ODBC Connector 5.2.5 for AIX plarform

2014-04-02 Thread Shen, Tingting
Hi, I want to install MySQL ODBC Connector 5.2.5 on AIX 7.1 platform. But I cannot find any binary for installation on AIX platform. In addition, I also tried to build my own installation binary from source code , but found no source code for AIX platform. http://downloads.mysql.com/archives/c

Re: ODBC connector and MySQL Enterprise Edition

2014-02-17 Thread shawn l.green
Hello Femitha, On 2/17/2014 12:16 AM, Femitha Majeed wrote: Hi, Please help me by answering this question. Currently we've a database link between Oracle database and MySQL database using mysql-connector-odbc-5.1.8, will this connector work if I change my MySQL to enterprise edition ?

ODBC connector and MySQL Enterprise Edition

2014-02-16 Thread Femitha Majeed
Hi, Please help me by answering this question. Currently we've a database link between Oracle database and MySQL database using mysql-connector-odbc-5.1.8,  will this connector work if I change my MySQL to  enterprise edition ? Thank you.

MySQL Connector/ODBC 5.3.1 beta has been released

2013-11-27 Thread Hery Ramilison
Dear MySQL users, MySQL Connector/ODBC 5.3.1 beta, a new version of the ODBC driver for the MySQL database management system, has been released. The available downloads include both a Unicode driver and an ANSI driver based on the same modern codebase. Please select driver type you need based

MySQL Connector/ODBC 5.3.0 alpha has been released

2013-10-24 Thread Kent Boortz
Dear MySQL users, MySQL Connector/ODBC 5.3.0 alpha, a new version of the ODBC driver for the MySQL database management system, has been released. The available downloads include both a Unicode driver and an ANSI driver within the same package. Server-side prepared statements are enabled by

Re: MySQL Connector/ODBC 5.2.6 has been released

2013-10-10 Thread Shawn Green
Hello Saquib, On 10/9/2013 7:17 PM, Saqib N Ali wrote: no binaries for AIX? -- saqib http://hivemined.net The last ODBC package built for AIX was 5.1.8 released Oct 2010 http://downloads.mysql.com/archives.php?p=mysql-connector-odbc-5.1&o=aix This is inline with our EOL announcem

Re: MySQL Connector/ODBC 5.2.6 has been released

2013-10-09 Thread Saqib N Ali
no binaries for AIX? -- saqib http://hivemined.net On Wed, Oct 9, 2013 at 3:02 PM, Kent Boortz wrote: > > Dear MySQL users, > > MySQL Connector/ODBC 5.2.6, a new version of the ODBC driver for the > MySQL database management system, has been released. > > The availa

MySQL Connector/ODBC 5.2.6 has been released

2013-10-09 Thread Kent Boortz
Dear MySQL users, MySQL Connector/ODBC 5.2.6, a new version of the ODBC driver for the MySQL database management system, has been released. The available downloads include both a Unicode driver and an ANSI driver based on the same modern codebase. Please select driver type you need based on the

MySQL Connector/ODBC 5.2.4 has been released

2013-02-05 Thread Kent Boortz
Dear MySQL users, MySQL Connector/ODBC 5.2.4, a new version of the ODBC driver for the MySQL database management system, has been released. The available downloads include both a Unicode driver and an ANSI driver based on the same modern codebase. Please select driver type you need based on the

MySQL Connector/ODBC 5.1.12 has been released

2013-02-05 Thread Kent Boortz
Dear MySQL users, MySQL Connector/ODBC 5.1.12, a new version of the ODBC driver for the MySQL database management system, has been released. This release is the latest release of the 5.1 series and is suitable for use with any MySQL version since 4.1 (It will not work with 4.0 or earlier

MySQL Connector/ODBC 5.2.3 has been released

2013-01-05 Thread Kent Boortz
Dear MySQL users, MySQL Connector/ODBC 5.2.3, a new version of the ODBC driver for the MySQL database management system, has been released. The available downloads include both a Unicode driver and an ANSI driver based on the same modern codebase. Please select driver type you need based on the

MySQL Connector/ODBC 5.2.2 has been released

2012-09-21 Thread Kent Boortz
Dear MySQL users, MySQL Connector/ODBC 5.2.2, a new version of the ODBC driver for the MySQL database management system, has been released. This is the first GA release for the Connector/ODBC 5.2.x series. Now the available downloads include both a Unicode driver and an ANSI driver based on the

MySQL Connector/ODBC 5.2.1 beta has been released

2012-08-10 Thread Kent Boortz
Dear MySQL users, MySQL Connector/ODBC 5.2.1 beta, a new version of the ODBC driver for the MySQL database management system, is available for download. The 5.2 driver series is suitable for use with any MySQL server version since 4.1. (It will not work with 4.0 or earlier releases.) This new

Managing ODBC on Linux? What Happened to myodbc3i?

2012-04-17 Thread Robinson, Eric
We usually manage ODBC data sources on Linux using the myodbc3i utility that came with mysql-connector-odbc-3.51.30-1.rhel5.i386.rpm. When we upgraded to mysql-connector-odbc-5.1.10-1.rhel5.i386.rpm, it removed the myodbc3i utility. What GUI tool is now recommended to managing ODBC connections

Re: MySQL Connector/ODBC won't connect to internal network

2012-01-11 Thread Monte Milanuk
Sheesh... I knew it had to be something simple. Opened up phpMyAdmin as mysql/root and changed the privileges for the ijdb user to allow connecting from any host, not just localhost. Problem solved. Thanks! Monte -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: MySQL Connector/ODBC won't connect to internal network

2012-01-11 Thread Johan De Meersman
- Original Message - > From: "Monte Milanuk" > > Again, I *don't* want to connect to 192.168.56.1 - I want to connect > to 192.168.56.20 - so why the heck is mysql refusing to do that. Yes. Now take a deep breath and read what I said again. You can perfectly connect to .20 - as proven b

Re: MySQL Connector/ODBC won't connect to internal network

2012-01-11 Thread Monte Milanuk
is mysql refusing to do that. I can connect to that host via http/https/ssh, but not ODBC - and apparently not via the regular myql cli client either. I thought I could earlier, but I think I mistook connecting via ssh *then* the mysql client, not straight from the Windows host to the LAMP guest v

Re: MySQL Connector/ODBC won't connect to internal network

2012-01-11 Thread Johan De Meersman
- Original Message - > From: "Monte Milanuk" > 'Connection Failed: [HY000][MySQL][ODBC 5.1 Driver] Access denied for > user 'ijdb'@'192.168.56.1' (using password: YES)' The connector is not trying to connect to the host address; it'

MySQL Connector/ODBC won't connect to internal network

2012-01-11 Thread Monte Milanuk
I've got MySQL Connector/ODBC 5.1 installed on my Windows Vista laptop. I have MySQL 5.5.19 installed on the laptop, and was able to connect to it via the Windows Data Source Administrator app and the MySQL Connector/ODBC using a TCP/IP connection to 'localhost'. I could conne

Good ODBC Reference? [was RE: Replacing MS SQL with MySql]

2011-02-11 Thread Jan Steinman
> From: David Brian Chait > > No, what he is suggesting is that you use Access or MSSQL, and link Mysql to > either platform via ODBC so that you can use it indirectly. Can someone recommend a good ODBC tutorial or reference? I've tried a couple times to tie things toge

Re: invalid string bugfix for ODBC/Connector 5.1.7

2010-10-29 Thread Johan De Meersman
hem having more important things to do than fix a minor annoyance in a connector - like, say, fixing actual database bugs ? If you do happen to have a support contract, however, this is still entirely the wrong place to complain. On Fri, Oct 29, 2010 at 9:59 AM, wrote: > HI all, > > the

invalid string bugfix for ODBC/Connector 5.1.7

2010-10-29 Thread wim . delvaux
HI all, the c/c++ ODBC/Connector 5.1.7 has a critical bug that you cannot edit the ODBC setting anymore once entered. A fix is known and committed. why does it take so long for the 5.1.8 to be released ? Surely this bug merits expedient treatment. Quid ? W -- MySQL General Mailing List For

RE: OpenOffice, Go-OO, ODBC, Offline Data Entry

2010-08-19 Thread Lord_Devi
> >> Is this foolproof? Absolutely not, if there are conflicts between the > >> changes > >> by different users. You'll be stuck with "He who write last, writes best"; > >but > >> I think that's as good as it's going to get for you. > > > >AIUI, you could prevent that by having a second timestamp,

RE: OpenOffice, Go-OO, ODBC, Offline Data Entry

2010-08-19 Thread Jerry Schwartz
>-Original Message- >From: Joerg Bruehe [mailto:joerg.bru...@oracle.com] >Sent: Thursday, August 19, 2010 7:25 AM >To: mysql@lists.mysql.com >Cc: Jerry Schwartz; 'Lord_Devi' >Subject: Re: OpenOffice, Go-OO, ODBC, Offline Data Entry > >Hi! > >

Re: OpenOffice, Go-OO, ODBC, Offline Data Entry

2010-08-19 Thread Joerg Bruehe
Hi! Jerry Schwartz wrote: > I deal with a somewhat similar situation. Even though we have fast VPN > connections among our various offices, each has been afflicted with a > different database structure (and software) which they cannot change. > > What I suggest you do is use the kind of "pseud

RE: OpenOffice, Go-OO, ODBC, Offline Data Entry

2010-08-18 Thread Jerry Schwartz
796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com >-Original Message- >From: Lord_Devi [mailto:lordd...@gmail.com] >Sent: Wednesday, August 18, 2010 1:43 AM >To: mysql@lists.mysql.com >Subject: OpenOffice, Go-OO, ODBC, Offline Data Entry > >Hello, &g

OpenOffice, Go-OO, ODBC, Offline Data Entry

2010-08-17 Thread Lord_Devi
Hello, I am new to the mailing list here, so I'd like to introduce myself quickly. My name is Casey Quibell, and I am also rather new to the concept of programming a database (Or in this case, more specifically using an ODBC connector to tie OpenOffice into it.) Just a bit of tech

when will version 5.1.6 of the odbc connector become available ?

2010-06-07 Thread wim . delvaux
I need some bugs fixed W -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

HOW TO INSTALL MYSQL ODBC ON AIX 5.3 ?

2010-05-06 Thread sun . yan5
FOLLOW ARE SOME MY OPERATOR STEPS,HOW WILL I TO DO IT? p570a:/mysql/mysql-connector-odbc-5.1.6-aix5.3-powerpc-64bit/bin >./myodbc-installer exec(): 0509-036 Cannot load program ./myodbc-installer because of the following errors: 0509-150 Dependent module libodbc.so could not be loa

odbc connector

2010-02-10 Thread wim . delvaux
The odbc connector of mysql reports it does not support LAST_INSERT_ID nor does it seem to report back that it supports unicode. For the last_insert_id I have a workaround by issuing a Select last_insert_id() after an insert, however for working with unicode I have not found a solution. this

odbc connector 5.1 for windows unicode support

2010-02-04 Thread wim . delvaux
Hi, I have a database with UTF8 characters. These are shown correctly by the query browser. I installed the odbc/connector 5.1 and tried to access the same table using OpenOffice base and a Qt application I wrote myself. In both clients the UTF8 character so not show up properly as if the

Connection timeout supported ? MySQL ODBC 5.5

2010-01-04 Thread Tompkins Neil
Hi Can anyone confirm if there are any connection time out values I can specify in my application (ASP (VBScript) for the MySQL ODBC connection. Cheers Neil

Re: Fwd: ODBC MySQL Password as plain text

2009-11-20 Thread Tompkins Neil
Don Thanks for your response. The issue I have is that the password for our database is stored either in the ODBC registry or within our ASP page as plain text. One option I have is to encrypt the password in the database connnection string and have a function with a key in a external file that

Re: Fwd: ODBC MySQL Password as plain text

2009-11-20 Thread Tompkins Neil
I wondered if anyone else had any thoughts on this issue ? Cheers Neil On Thu, Nov 19, 2009 at 12:40 PM, Jay Ess wrote: > Tompkins Neil wrote: > >> Following my previous email. I've now configured my database connection >> using a ODBC DNSLESS SSL connection. However th

Re: Fwd: ODBC MySQL Password as plain text

2009-11-19 Thread Tompkins Neil
PM, Jay Ess wrote: > Tompkins Neil wrote: > >> Following my previous email. I've now configured my database connection >> using a ODBC DNSLESS SSL connection. However the problem still remains, >> the >> password is stored in the ASP file in plain text. Does an

Re: Fwd: ODBC MySQL Password as plain text

2009-11-19 Thread Jay Ess
Tompkins Neil wrote: Following my previous email. I've now configured my database connection using a ODBC DNSLESS SSL connection. However the problem still remains, the password is stored in the ASP file in plain text. Does anyone have any recommendations on how to overcome this

Fwd: ODBC MySQL Password as plain text

2009-11-19 Thread Tompkins Neil
Following my previous email. I've now configured my database connection using a ODBC DNSLESS SSL connection. However the problem still remains, the password is stored in the ASP file in plain text. Does anyone have any recommendations on how to overcome this issue ? Cheers

ODBC MySQL Password as plain text

2009-11-18 Thread Tompkins Neil
Hi The MySQL ODBC connection password is stored as plain text in the Windows registry. What is the best way to overcome this issue - to ensure the password is saved securely Thanks, Neil

RE: Difference between MySQL Connector/ODBC 3.51 and ODBC 5.1

2009-10-26 Thread Jerry Schwartz
>-Original Message- >From: Tompkins Neil [mailto:neil.tompk...@googlemail.com] >Sent: Monday, October 26, 2009 5:29 AM >To: Jerry Schwartz >Cc: [MySQL] >Subject: Re: Difference between MySQL Connector/ODBC 3.51 and ODBC 5.1 > >Thanks for the response Jerry. I sup

Re: Difference between MySQL Connector/ODBC 3.51 and ODBC 5.1

2009-10-26 Thread Tompkins Neil
Thanks for the response Jerry. I suppose my main question is it possible/recommended to run ODBC 3.51 which version 5 of MySQL - or is it highly recommended to use ODBC 5.1 ? Regards Neil On Fri, Oct 23, 2009 at 7:24 PM, Jerry Schwartz wrote: > The UTF-8 issue was the only thing that rea

RE: Difference between MySQL Connector/ODBC 3.51 and ODBC 5.1

2009-10-23 Thread Jerry Schwartz
860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com From: Tompkins Neil [mailto:neil.tompk...@googlemail.com] Sent: Friday, October 23, 2009 1:14 PM To: Jerry Schwartz Cc: [MySQL] Subject: Re: Difference between MySQL Connector/ODBC 3.51 and ODBC 5.1 Hi Thanks for your quick

Re: Difference between MySQL Connector/ODBC 3.51 and ODBC 5.1

2009-10-23 Thread Tompkins Neil
Hi Thanks for your quick response. Apart from the UTF-8 support, was there anything else we should consider. At the moment our system doesn't support UTF-8, so if this is the only concern/advantage of using ODBC 5.1, then maybe we should think about using MySQL 5 with ODBC 3.51. What are

RE: Difference between MySQL Connector/ODBC 3.51 and ODBC 5.1

2009-10-23 Thread Jerry Schwartz
.tompk...@googlemail.com] >Sent: Thursday, October 22, 2009 10:04 AM >To: [MySQL] >Subject: Difference between MySQL Connector/ODBC 3.51 and ODBC 5.1 > >Hi, > >We are currently running a early version of MySQL and are looking to upgrade >to the latest version 5. However

Difference between MySQL Connector/ODBC 3.51 and ODBC 5.1

2009-10-22 Thread Tompkins Neil
Hi, We are currently running a early version of MySQL and are looking to upgrade to the latest version 5. However, we have a number of external applications which use the MySQL Connector/ODBC 3.51. What are the differences between ODBC 3.51 and ODBC 5.1. For example do I need to use ODBC 5.1

RE: mysql odbc connection problem

2009-10-06 Thread John Daisley
1 AM To: mysql@lists.mysql.com Subject: mysql odbc connection problem Hi All We are experiencing some problems when trying to connect to a mysql database using ODBC. The settings have been configured and it seems to be getting to the DB but we getting the following error: [S1T00][unixODBC][MySQL][ODBC

mysql odbc connection problem

2009-10-06 Thread Machiel Richards
Hi All We are experiencing some problems when trying to connect to a mysql database using ODBC. The settings have been configured and it seems to be getting to the DB but we getting the following error: [S1T00][unixODBC][MySQL][ODBC 3.51 Driver]Access denied for user 'root'@'h

Configure error of mysql-connector-odbc-5.1.5r1144 (missing sqlext.h)

2009-09-26 Thread Peng Yu
Hi, I try to configure mysql-connector-odbc-5.1.5r1144, But I got the following error. Can somebody let me know where to download the package which includes sqlext.h? Regards, Peng checking whether the f95 linker (/home/pengy/utility/linux/bin/ld -m elf_x86_64) supports shared libraries... yes

Re: Inno Setup script for MySQL and MySQL ODBC?

2008-12-27 Thread Yves Goergen
#x27;t know about anyone else, but I don't know what you mean by "inno > setup script". Please be more specific. > Steve. I assume he means the files to be copied and actions to be performed to install the MySQL server and ODBC driver, in InnoSetup language. Use your favourit

Re: Inno Setup script for MySQL and MySQL ODBC?

2008-12-19 Thread Steve Holmes
2008/12/19 Menachem Bazian > Does anyone have an inno setup script so I can automatically install MySQL > with an application? > > > I don't know about anyone else, but I don't know what you mean by "inno setup script". Please be more spec

Inno Setup script for MySQL and MySQL ODBC?

2008-12-19 Thread Menachem Bazian
Does anyone have an inno setup script so I can automatically install MySQL with an application? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'

2008-10-04 Thread Varuna Seneviratna
;mysqladmin" -p root shutdown next the root password > was > > asked for,I entered the correct password, when I entered the password the > > below displayed error was the result > > > > mysqladmin: connect to server at 'localhost' failed > > error: 'Acc

Re: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'

2008-10-04 Thread Ian Simpson
sword was > asked for,I entered the correct password, when I entered the password the > below displayed error was the result > > mysqladmin: connect to server at 'localhost' failed > error: 'Access denied for user 'ODBC'@'localhost' (using pa

Re: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'

2008-10-04 Thread Andy Shellam
utdown MySQL service from the command line and ran the command "mysqladmin" -p root shutdown next the root password was asked for,I entered the correct password, when I entered the password the below displayed error was the result mysqladmin: connect to server at 'localhost'

Re: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'

2008-10-04 Thread Pintér Tibor
the result mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)' How can I correct this? Is this because of a firewall preventing access to port 3306?If a firewall is preventing access how w

mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'

2008-10-04 Thread Varuna Seneviratna
server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)' How can I correct this? Is this because of a firewall preventing access to port 3306?If a firewall is preventing access how was it able to ask for th

Re: Transactions with ODBC

2008-01-25 Thread Peter Brawley
is on the MySQL Forums but I have not gotten a response... Thanks for your help... I know this is probably a stupid question but I could use a nudge in the right direction. I would like to wrap my updates top MySQL in transactions. I am using ODBC as my means of communication (Visual FoxPro is the

Re: Transactions with ODBC

2008-01-25 Thread groups
my updates top MySQL in transactions. I am using ODBC as > my means of communication (Visual FoxPro is the front end) and passing SQL > statements off to the server one Execute at a time. > > I understand how I could do this with a stored procedure, or possibly even > ADO, but I would pref

Re: Transactions with ODBC

2008-01-25 Thread Peter Brawley
right direction. I would like to wrap my updates top MySQL in transactions. I am using ODBC as my means of communication (Visual FoxPro is the front end) and passing SQL statements off to the server one Execute at a time. I understand how I could do this with a stored procedure, or possibly even

Transactions with ODBC

2008-01-25 Thread groups
I apologize if you saw this on the MySQL Forums but I have not gotten a response... Thanks for your help... I know this is probably a stupid question but I could use a nudge in the right direction. I would like to wrap my updates top MySQL in transactions. I am using ODBC as my means of

Re: ODBC 3.51.22 problem - please help

2007-12-13 Thread Jim Winstead
On Wed, Dec 12, 2007 at 05:11:43PM -0800, Ed Reed wrote: > I've found a glaring problem with the latest ODBC connector. Data > types have been changed and data is no longer being read correctly. That's not quite correct -- data types are now actually being read correctly. They w

ODBC 3.51.22 problem - please help

2007-12-12 Thread Ed Reed
I've found a glaring problem with the latest ODBC connector. Data types have been changed and data is no longer being read correctly. I'm running MySQL 5.1.16 on Netware. My apps are VB6 and VBA using ADO. The following query produces different data types depending on the version of

calling stored procedure trough ODBC

2007-08-04 Thread C K
Hello, I am using MySQL 5.0.17 and MyODBC 3.51.14. I ma using MS Access 2003 as front-end Can I call stored procedures from Access ? how ? Also can we use ODBC driver for calling stored procedures or linking SP to Access? Please help Thanks CPK -- Keep your Environment clean and green.

RE: MySQL Connector/ODBC 3.51.17 fails to work with MS Access 2002

2007-07-18 Thread Jerry Schwartz
, July 18, 2007 10:08 AM > To: 'Jim Winstead' > Cc: mysql@lists.mysql.com; [EMAIL PROTECTED] > Subject: MySQL Connector/ODBC 3.51.17 fails to work with MS > Access 2002 > > I was unable to get 3.51.17 to work with MS Access 2002. I > installed it from > the msi bundle

MySQL Connector/ODBC 3.51.17 fails to work with MS Access 2002

2007-07-18 Thread Jerry Schwartz
I was unable to get 3.51.17 to work with MS Access 2002. I installed it from the msi bundle. The connector passes a test when creating or configuring a System DSN, but when I try to link tables from MS Access I get an error message: [MySQL][ODBC 3.51 Driver][mysqld-4.1.22-standard]Access denied

Re: MySQL and 'ODBC'@'localhost' error

2007-07-09 Thread kapil kaushik
Hi All, Thanks a lot for your help. The thing is working now. Although I would like to mention a couple of points: 1. mysql -u root -p test_dev wrote: You didn't specify a user or password on your mysql command line when you redirected your input to your .sql file, and for some reason the defa

RE: MySQL and 'ODBC'@'localhost' error

2007-07-09 Thread Jerry Schwartz
You didn't specify a user or password on your mysql command line when you redirected your input to your .sql file, and for some reason the default is [EMAIL PROTECTED] You need to use the -p and -u options on the command line. Regards, Jerry Schwartz The Infoshop by Global Information Incorporat

Re: MySQL and 'ODBC'@'localhost' error

2007-07-08 Thread Martin Gainty
You are attempting to login as ODBC If your scripts are using ODBC as the USER you will need to CREATE USER ODBC and GRANT necessary privs doc available at http://dev.mysql.com/doc/refman/5.0/en/adding-users.html M-- This email message and any files transmitted with it contain confidential

MySQL and 'ODBC'@'localhost' error

2007-07-08 Thread kapil kaushik
fected <0.01 sec> (this means that the mysql server is up and running) I then write a small create.sql file, in the child folder db/create.sql: drop table if exists products; create table products ( id int not null auto_increment, primary key (id) ); The problem now comes when i write the

RE: ODBC Drivers 3 and 5

2007-06-22 Thread Jerry Schwartz
Does that explain why, using ODBC 3.x, I can't retrieve Chinese characters with Access? I never noticed that there was no Unicode support, no wonder I've been beating my head against a wall. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave.

Re: ODBC Drivers 3 and 5

2007-06-19 Thread Jim Winstead
n version 5 will I > have less functions on my ASP server that is using ODBC version 3? > > Should I be using the same version? No, Connector/J has always supported Unicode. There's no reason to stay with Connector/J 3.x because you're using Connector/ODBC 3.51. Jim -- MySQL

Re: ODBC Drivers 3 and 5

2007-06-19 Thread Lucas . CTR . Heuman
So I guess the same thing goes with the JDBC connectors? http://dev.mysql.com/downloads/connector/j/5.0.html For example.. If I'm using Coldfusion to do jdbc calls in version 5 will I have less functions on my ASP server that is using ODBC version 3? Should I be

Re: ODBC Drivers 3 and 5

2007-06-19 Thread Jim Winstead
On Tue, Jun 19, 2007 at 10:24:11AM -0400, [EMAIL PROTECTED] wrote: > I have been looking online for an explanation of the differences between > ODBC drivers 3 and 5. I'm sure it is someplace simple to find. Does > anyone here know? Connector/ODBC 3.51 is an ODBC driver that sup

Re: ODBC Drivers 3 and 5

2007-06-19 Thread Martin Gainty
Good Morning Lucas From what i've been able to gather Type 3 is a bridging technology which accomplishes the ODBC-JDBC communication objective but is slower than native Type 4 thin client driver counterpart as there are a min of 3+ components which are used ODBC Bridge JDBC Best doc

ODBC Drivers 3 and 5

2007-06-19 Thread Lucas . CTR . Heuman
I have been looking online for an explanation of the differences between ODBC drivers 3 and 5. I'm sure it is someplace simple to find. Does anyone here know? Phone 609.485.5401

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
Nils Meyer wrote: SELECT SQL_CALC_FOUND_ROWS doesn't make much sense without a where clause by the way. LIMIT, not where. Thanks for the reply... That seems to make sense. I'm talking about the part of one record being returned containing a field with the number of records. About the LIMI

Re: SQL_CALC_FOUND_ROWS using ODBC driver

2007-02-15 Thread Jess Balint
On Thu, Feb 15, 2007 at 01:04:26AM +, Nuno Oliveira wrote: > 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 u

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: ODBC connector 3.51/5.0

2007-02-13 Thread Daniel Kasak
C K wrote: I HAVE TO TRY IT OUT. BUT THE PROBLEM IS THAT I HAVE MYSQL 5.0.17 AND I THINK 3.51.06 CAN NOT CONNECT TO 5.0.17. BUT I HAVE TO TRY. THANKS AND REGARDS CPK LESS CAPITALS THANKS. If you want to use MyODBC-3.51.x you should use 3.51.12.2. If that doesn't work for you, then you should

Re: ODBC connector 3.51/5.0

2007-02-13 Thread C K
. The way I resolved the problem was to rollback to MyODBC-3.51.06. It resolved the issue. I hope this helps. Ron -Original Message- From: C K [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 13, 2007 1:01 PM To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: ODBC connector 3.51/5.0 Dear

ODBC connector 3.51/5.0

2007-02-13 Thread C K
Dear developers from MySQL, can i know when the MySQL connector/ODBc 5.0 will be released. I am facing few major problems regarding 3.51.12 on windows as application crash and wrong data display. please reply thanks, CPK -- Keep your Environment clean and green.

ODBC - MySQL 5 bug!

2006-08-07 Thread David Blake
Good day, After a whole day of researching I finally found an answer for Ms Access not displaying the columns of more than one table in a MySQL 5 view... The bugfix was posted in a mysql forum here: http://forums.mysql.com/read.php?65,52721,100434#msg-100434 which contains a link to a download fi

New Connector/ODBC chapter on-line

2006-06-14 Thread Stefan Hinz
We have done a complete rewrite of the Connector/ODBC docs - making this one of the best chapters in the MySQL Reference Manual: - http://dev.mysql.com/doc/refman/5.1/en/myodbc-connector.html Some of the pages you should look at include: - http://dev.mysql.com/doc/refman/5.1/en/myodbc

Re: Help on VB and ODBC

2006-05-04 Thread C.R.Vegelin
s recordcount. The adUseClient returns the actual recordcount. Please also take a look at: http://dev.mysql.com/doc/refman/5.1/en/programs-known-to-work-with-myodbc.html HTH, Cor - Original Message - From: "Manuel Betanzos" <[EMAIL PROTECTED]> To: Sent: Thursday, May 04, 2

Help on VB and ODBC

2006-05-04 Thread Manuel Betanzos
if i do, when i change any value i receive the following message: Error '-2147217900 (80040e14) en tiempo de ejecucion: [MySQL][ODBC 3.51 Driver][mysqld-5.0.15]You have an error in your SQL syntax; check the manual that corresponds to your MySQL Server version for the right syntax t

MySQL ODBC UTF8 Problem

2006-04-19 Thread Hung Le
Hi all, I’m working in a project that use MySQL. The data is Vietnamese. So, I have used MS Access 2003 to test displaying this data. I have configured ODBC Initial Statement Option as “set names utf8”, and use MS Acccess link to the database. But, the data can’t display correctly. I’m

  1   2   3   4   5   6   7   >