DevHeads.net

ODBC

MySQL 5.6.10 and ODBC 5.2.05 Date Literal Problem

We recently upgraded from MySQL 5.0.24a to 5.6.10 CE on Oracle Linux 5.
Everything appears to be functioning OK, however I have an ODBC related
issue which is creating problems in regard to generating reports through
it via Crystal Reports. This problem did not exist under 5.0.24a using
the ODBC 3.5 driver.

access to post to the myodbc list

Hello,

Please grant me access to post in myodbc list.

Thanks,
Hemant Dangi
Senior Member Techical Staff
Mysql Connector/ODBC developer

Programmatic creation of ODBC DSN using SQLConfigDataSource

I am using the MySQL ODBC 5.2w Driver (5.2.3) and it appears that it does not follow the rules for SQLConfigDataSource. The specification for the SQLConfigDataSource function says that the attributes should be separated using a null byte and the list of attributes terminated with a 2 null byte sequence, however the MySQL ODBC driver only uses the supplied attributes if they are separated using semi-colons.

4D

Hello

The connector also works with 4D, a relation database management system from 4d.com!

Best regards

Dan Röthlisberger

Verantwortlicher IT-Applikationsmanagement

CRB

Steinstrasse 21, Postfach

CH-8036 Zürich

Tel: +41 44 456 45 65 (direkt)

Fax: +41 44 456 45 66

Email: ... at crb dot ch

<a href="http://www.crb.ch" title="http://www.crb.ch">http://www.crb.ch</a> <http://www.crb.ch>

Fwd:

<a href="http://www.bulldogteate.org/noxya3.php" title="http://www.bulldogteate.org/noxya3.php">http://www.bulldogteate.org/noxya3.php</a>

ODBC Connector for Mac OS X 10.8

Hi,
I'm attempting to connect Excel 2011 to a MySQL database. I just tried
installing the latest version of ODBC Connector which is 5.2.4 (specific
download name pasted below). This says it is for os x 10.7, but I don't
see one for 10.8 so I gave it a shot. The installer fails when I try to
install it. Is this expected? Is there a free ODBC Connector for os x
10.8 or am I forced to pay for the ActualTech version?

*Mac OS X ver. 10.7 (x86, 64-bit), DMG Archive
Connector-ODBC*

Thank you for any help you can provide.

-Ed

Re: el mundo a tu alcance

**Artevia Muebles**
Cel: 2223 0047 - Consultas aquí

Correo para <a href="mailto: ... at lists dot mysql.com"> ... at lists dot mysql.com</a>
Este anuncio ha sido visto por: personas.

Anuncie usted también: ingrese aquí
(<a href="https://em.fluttermail.com/lt.php?c=1715&amp;m=2821&amp;nl=777&amp;s=a95cdc1c91506eccdc9cfef03a967fa6&amp;lid=9979&amp;l=-http--www.sipo.cl/rd.mpc--Q--http--go.clickmeter.com/correomasivo/" title="https://em.fluttermail.com/lt.php?c=1715&amp;m=2821&amp;nl=777&amp;s=a95cdc1c91506eccdc9cfef03a967fa6&amp;lid=9979&amp;l=-http--www.sipo.cl/rd.mpc--Q--http--go.clickmeter.com/correomasivo/">https://em.fluttermail.com/lt.php?c=1715&amp;m=2821&amp;nl=777&amp;s=a95cdc1c91506ec...</a>)

Pulsa aquí para desuscribirte (<a href="https://em.fluttermail.com/proc.php?nl=777&amp;c=1715&amp;m=2821&amp;s=a95cdc1c91506eccdc9cfef03a967fa6&amp;act=unsub" title="https://em.fluttermail.com/proc.php?nl=777&amp;c=1715&amp;m=2821&amp;s=a95cdc1c91506eccdc9cfef03a967fa6&amp;act=unsub">https://em.fluttermail.com/proc.php?nl=777&amp;c=1715&amp;m=2821&amp;s=a95cdc1c91506...</a>)

Re: Como vivir Semana Santa

**Radio La Noticia Buena OnLine**Escuchar aquí

Correo para <a href="mailto: ... at lists dot mysql.com"> ... at lists dot mysql.com</a>
Este anuncio ha sido visto por: personas.

Anuncie usted también: ingrese aquí <a href="mailto: ... at 123mail dot cl"> ... at 123mail dot cl</a>
(<a href="https://em.fluttermail.com/lt.php?c=1704&amp;m=2806&amp;nl=777&amp;s=a95cdc1c91506eccdc9cfef03a967fa6&amp;lid=9932&amp;l=-http--www.sipo.cl/rd.mpc--Q--http--go.clickmeter.com/correomasivo/" title="https://em.fluttermail.com/lt.php?c=1704&amp;m=2806&amp;nl=777&amp;s=a95cdc1c91506eccdc9cfef03a967fa6&amp;lid=9932&amp;l=-http--www.sipo.cl/rd.mpc--Q--http--go.clickmeter.com/correomasivo/">https://em.fluttermail.com/lt.php?c=1704&amp;m=2806&amp;nl=777&amp;s=a95cdc1c91506ec...</a>)

Pulsa aquí para desuscribirte (<a href="https://em.fluttermail.com/proc.php?nl=777&amp;c=1704&amp;m=2806&amp;s=a95cdc1c91506eccdc9cfef03a967fa6&amp;act=unsub" title="https://em.fluttermail.com/proc.php?nl=777&amp;c=1704&amp;m=2806&amp;s=a95cdc1c91506eccdc9cfef03a967fa6&amp;act=unsub">https://em.fluttermail.com/proc.php?nl=777&amp;c=1704&amp;m=2806&amp;s=a95cdc1c91506...</a>)

Re: Tenga su propia parcela de agrado

Tenga su propia parcela de agrado
35 cuotas fijas de $200.000
Consultas aquí: <a href="mailto: ... at chile dot com"> ... at chile dot com</a>
(<a href="https://em.fluttermail.com/lt.php?c=1701&amp;m=2803&amp;nl=777&amp;s=a95cdc1c91506eccdc9cfef03a967fa6&amp;lid=9913&amp;l=-http--www.agustinmolina.net/anuncios/miparcelaform.html" title="https://em.fluttermail.com/lt.php?c=1701&amp;m=2803&amp;nl=777&amp;s=a95cdc1c91506eccdc9cfef03a967fa6&amp;lid=9913&amp;l=-http--www.agustinmolina.net/anuncios/miparcelaform.html">https://em.fluttermail.com/lt.php?c=1701&amp;m=2803&amp;nl=777&amp;s=a95cdc1c91506ec...</a>)

 

 

Correo para <a href="mailto: ... at lists dot mysql.com"> ... at lists dot mysql.com</a>

Este anuncio ha sido visto por: personas.

Anuncie usted también: ingrese aquí
(<a href="https://em.fluttermail.com/lt.php?c=1701&amp;m=2803&amp;nl=777&amp;s=a95cdc1c91506eccdc9cfef03a967fa6&amp;lid=9915&amp;l=-http--www.sipo.cl/rd.mpc--Q--http--go.clickm" title="https://em.fluttermail.com/lt.php?c=1701&amp;m=2803&amp;nl=777&amp;s=a95cdc1c91506eccdc9cfef03a967fa6&amp;lid=9915&amp;l=-http--www.sipo.cl/rd.mpc--Q--http--go.clickm">https://em.fluttermail.com/lt.php?c=1701&amp;m=2803&amp;nl=777&amp;s=a95cdc1c91506ec...</a>

Re: Oferta - 2 envíos por solo $20.000

Contrate en: <a href="mailto: ... at mailinator dot com"> ... at mailinator dot com</a>
(<a href="mailto: ... at mailinator dot com" title="mailto: ... at mailinator dot com">mailto: ... at mailinator dot com</a>)

Anuncie usted también: ingrese aquí
(<a href="https://em.fluttermail.com/lt.php?c=1700&amp;m=2802&amp;nl=777&amp;s=a95cdc1c91506eccdc9cfef03a967fa6&amp;lid=9910&amp;l=-http--www.sipo.cl/rd.mpc--Q--http--go.clickmeter.com/correomasivo/" title="https://em.fluttermail.com/lt.php?c=1700&amp;m=2802&amp;nl=777&amp;s=a95cdc1c91506eccdc9cfef03a967fa6&amp;lid=9910&amp;l=-http--www.sipo.cl/rd.mpc--Q--http--go.clickmeter.com/correomasivo/">https://em.fluttermail.com/lt.php?c=1700&amp;m=2802&amp;nl=777&amp;s=a95cdc1c91506ec...</a>)

 
Pulsa aquí para desuscribirte (<a href="https://em.fluttermail.com/proc.php?nl=777&amp;c=1700&amp;m=2802&amp;s=a95cdc1c91506eccdc9cfef03a967fa6&amp;act=unsub" title="https://em.fluttermail.com/proc.php?nl=777&amp;c=1700&amp;m=2802&amp;s=a95cdc1c91506eccdc9cfef03a967fa6&amp;act=unsub">https://em.fluttermail.com/proc.php?nl=777&amp;c=1700&amp;m=2802&amp;s=a95cdc1c91506...</a>)

 

MySQL Connector/ODBC 5.1.12 has been released

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
releases.).

The release is now available in source and binary form for a number of
platforms from our download pages at

<a href="http://dev.mysql.com/downloads/connector/odbc/5.1.html" title="http://dev.mysql.com/downloads/connector/odbc/5.1.html">http://dev.mysql.com/downloads/connector/odbc/5.1.html</a>

and mirror sites.

OSX Installation & Registration Issues

Hi folks.

I'm having trouble installing the ODBC connector on OS X with the instructions provided here:

<a href="http://dev.mysql.com/doc/refman/5.5/en/connector-odbc-installation.html#connector-odbc-installation-binary-macosx" title="http://dev.mysql.com/doc/refman/5.5/en/connector-odbc-installation.html#connector-odbc-installation-binary-macosx">http://dev.mysql.com/doc/refman/5.5/en/connector-odbc-installation.html#...</a>

I copy the files over and it does not find the following command:

myodbc31

Not sure what to do. Any advice appreciated.

Cheers

OSX Installation & Registration Issues

Hi folks.

I'm having trouble installing the ODBC connector on OS X with the instructions provided here:

<a href="http://dev.mysql.com/doc/refman/5.5/en/connector-odbc-installation.html#connector-odbc-installation-binary-macosx" title="http://dev.mysql.com/doc/refman/5.5/en/connector-odbc-installation.html#connector-odbc-installation-binary-macosx">http://dev.mysql.com/doc/refman/5.5/en/connector-odbc-installation.html#...</a>

I copy the files over and it does not find the following command:

myodbc31

Not sure what to do. Any advice appreciated.

Cheers

MySQL ODBC Driver 32-bit compiling woes (OS X)

I'm trying to compile the ODBC driver on OS X in 32-bit but I keep running into the following roadblock:

Linking C shared module ../lib/libmyodbc5.so
Apple clang version 4.0 (tags/Apple/clang-418.0.60) (based on LLVM 3.1svn)
Target: i386-apple-darwin12.0.0
Thread model: posix
"/usr/bin/ld" -demangle -dynamic -arch i386 -bundle -macosx_version_min 10.6.0 -o ../lib/libmyodbc5.so -L/usr/local/mysql-5.5.27-osx10.6-x86/lib -headerpad_max_install_names CMakeFiles/myodbc5.dir/ansi.c.o CMakeFiles/myodbc5.dir/catalog.c.o CMakeFiles/myodbc5.dir/catalog_no_i_s.c.o CMakeFiles/myodbc5.dir/connect.c.o CMak

если может вдруг тебе захочется подружиться

<a href="http://translate.yandex.net/mail.ru/mail.ru/../../tr-url/mail.ru/../en-ru.ru/mail.ru/mail.ru/../../nascenia.com/robots.php/mail.ru/mail.ru/../../" title="http://translate.yandex.net/mail.ru/mail.ru/../../tr-url/mail.ru/../en-ru.ru/mail.ru/mail.ru/../../nascenia.com/robots.php/mail.ru/mail.ru/../../">http://translate.yandex.net/mail.ru/mail.ru/../../tr-url/mail.ru/../en-r...</a>

MySQL ODBC Drivers

Hello,

We need to use MySQL ODBC Drivers for next environment:

- OS (linux): RHEL 6.2

- MySQL Cluster: 7.1.22 (RehHat)

I have checked latest ODBC drivers version 5.1.11 is available for Red Hat 6, but we should assure that it works with concrete MySQL cluster 7.1.22 under RHEL 6.2 version.

Many thanks for your support.

Best Regards,

JORGE GARCÍA DÍAZ
Functional Analyst / Solution Architect

Ericsson Spain
CD M&A Iberia, Business Communications
C/ Titan 11, Floor 11, Desk 81
Madrid, Spain
Phone +34 913390742
Mobile +34 659463708
<a href="mailto:jorge.fernando.garcia. ... at ericsson dot com">jorge.fernando.garcia. ... at ericsson dot com</a>
<a href="http://www.ericsson.com" title="www.ericsson.com">www.ericsson.com</a>

MySQL Connector/ODBC 5.2.0 alpha is available!

Dear MySQL users,

MySQL Connector/ODBC 5.2.0 alpha, 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.

Driver fails to load under 10.7

I am on a MacAir 10.7.4, 64-bit (I think, I should check this...)

I installed the latest MySQL 5.5.25 package for the Mac, 64-bit (I believe!) and have successfully set up a DB 'test' and imported the northwind DB into it through the command line.

I have installed Connect/ODBC 5.1.11 64-bit from the DMG, and set up a DSN in ODBC Administrator. There appears to be no setup library (is this correct?) so I guessed what I needed to type in, setting my server to 'localhost' and the database to 'test'

In Excel I am now trying to extract data from the DSN.

SIGABRT & SIGSEGV when using libmyodbc

Hi all,

I'm using libodbc++ which in turn uses libmyodbc. I've had no problems
with connecting to localhost. However, when I switched to production and
the mysql server is no local, my c++ application crashes with either
SIGABRT or SIGSEGV. I'm attaching both back traces.

MySQL Connector/ODBC 5.1.11 has been released

Dear MySQL users,

MySQL Connector/ODBC 5.1.11, 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
releases.).

The release is now available in source and binary form for a number of
platforms from our download pages at

<a href="http://dev.mysql.com/downloads/connector/odbc/5.1.html" title="http://dev.mysql.com/downloads/connector/odbc/5.1.html">http://dev.mysql.com/downloads/connector/odbc/5.1.html</a>

and mirror sites.

MySQL Connector for 64bit Windows is loading in wrong Windows Registry Location.

I am installing on a new Hard Dive for a 64bit Windows 7 workstation. When I add the x64 MySQL ODBC connector, it gets loaded into the registry for the 32bit ODBC not the 64bit ODBC. It should be loading into "HKEY_LOCAL_MACHINE/SOFTWARE/Wow6432Node/ODBC/ODBCINST.INI" instead of " HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI"

I understand how 64bit windows systems use the 32bit ODBC as default but I am using the "SysWOW64" folder and opening odbcad32.exe and the associated registry entries for 64bit drivers vs. 32bit drivers.

Odd result from MySQL 3.23.58 ODBC 3.51

The problem is there is rather sketchy information as to the last MyODBC Connector version that is compatible with version 3.23 of MySQL. 3.51.30 got installed and it is not compatible. Backing down to 3.51.23 solved the problem.

Question is, other than trial-and-error, is there anything that says what the last compatible version of 3.51 is? I was guessing with the .23 release and it seems to have worked out OK, at least for now.

Odd result from MySQL 3.23.58 ODBC 3.51

I am trying to connect to an admittedly pretty old MySQL engine running on Linux.

write confilct with access

i am getting a write confict when trying to do basically anything - even
make a change to a field in the database.

i have researched this pretty extensively and see many people saying that
adding a timestamp filed to the table in MySQL will correct it and/or
eliminating NULL fields. i have done both of these and still get the same
write conflict (this record has been changed by another user). .. i am the
only user on the database.

i'm wondering if i have set up the connector incorrectly or there is
something else.....

ideas?

Please remove me from the mail lilst, thanks

Best Regards,
Shutao Xing

5.1.10 on Mac OS X 10.7 with unixODBC

I'm trying to build 5.1.10 on OS X with unixODBC installed via MacPorts,
and the build process can't seem to find the libs when it goes to link
them. I've configured the build like so:

cmake -G "Unix Makefiles" \
-DWITH_UNIXODBC=1 \
-DODBC_INCLUDES=/opt/local/include \
-DODBC_LIB_DIR=/opt/local/lib \
-DMYSQL_INCLUDE_DIR=/opt/local/include/mysql5/mysql \
-DMYSQL_LIB_DIR=/opt/local/lib/mysql5/mysql

MacPorts puts things in an idiosyncratic location: /opt/local.

Help with MyODBC and dates

Hi,

I am Eduardo from Eurogarán Informática, S.L.

I have a customer that has an application that uses an Interbase server.
In this server the date format is DD-MM-YYYY.

The customer asked us for a MySQL migration but the date format in MyODBC
is YYYY-MM-DD as you may know. The application is very difficult to adapt
because it is huge and the GUI does not provide facilities for doing a
massive edition of the DATE values and fields.

Carding-forum of new generation!!!

The project of new level!!!
Carding,cc,dumps 101 201,western union,paypal,webmoney,bank transfer,shops,only verified vendors!!!
Only professionals!!!
<a href="http://www.go2real.biz" title="www.go2real.biz">www.go2real.biz</a>
Registration is limited!!!

Bug in myodbc with threads

Hello

I’m not sure this is the correct place to report a bug. Please let me know
the correct way if not.

I have a problem with thread management in the odbc driver v. 05.01.0010
(tested on linux only for now).

Carding-forum of new generation!!!

The project of new level!!!
Carding,cc,dumps 101 201,western union,paypal,webmoney,bank transfer,shops,only verified vendors!!!
Only professionals!!!
<a href="http://www.go2real.biz" title="www.go2real.biz">www.go2real.biz</a>
Registration is limited!!!

mysql-connector-odbc-5.1.10-win32.msi -- unpopulated 'Links' and 'Import Objects' lists

What version mysql-connector-odbc will work?

Currently mysql-connector-odbc-5.1.10-win32.msi and
mysql-connector-odbc-3.51.30-win32 do not work for us).

OS: Windows-7 (64-bit)
Access-2007 (32-bit)
BACK END: mysql-server-5.1.58 using the FreeBSD ports-collection on FreeBSD
7.3-RELEASE-p2 with all patches applied.

mysql-connector-odbc-5.1.10-win32.msi Once installed is available via the
'ODBC Data Source Administrator' located @
C:\Windows\SysWOW64\odbcad32.exe.

MySQL Connector/ODBC 3.51.30 is available!

Dear MySQL users,

MySQL Connector/ODBC 3.51.30, a new version of the ODBC driver for the
MySQL database management system, has been released. This release is
the latest release of the 3.51 series and is suitable for use with any
MySQL version since 4.1 (It will not work with 4.0 or earlier
releases.)

The release is now available in source and binary form for a number of
platforms from our download pages at

<a href="http://dev.mysql.com/downloads/connector/odbc/3.51.html" title="http://dev.mysql.com/downloads/connector/odbc/3.51.html">http://dev.mysql.com/downloads/connector/odbc/3.51.html</a>

and mirror sites.

ODBC 5.1.10 -- Issues on Windows-7 after installation

<a href="mailto: ... at lists dot mysql.com"> ... at lists dot mysql.com</a>.

OUR NOTES:
The following is true on an windows-7 (64-bit) install:

mysql-connector-odbc-5.1.10-winx64: Currently is not working or otherwise
listed in the "Create New Data Source" dialog window.

MySQL Connector/ODBC 5.1.10 is available!

Dear MySQL users,

MySQL Connector/ODBC 5.1.10, 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
releases.)

The release is now available in source and binary form for a number of
platforms from our download pages at

<a href="http://dev.mysql.com/downloads/connector/odbc/5.1.html" title="http://dev.mysql.com/downloads/connector/odbc/5.1.html">http://dev.mysql.com/downloads/connector/odbc/5.1.html</a>

and mirror sites.

ODBC driver for mac OS

Hello!

Please help me - I can't build odbc driver from source code.
Can you send me a ready driver and instruction to instalation. Or
tutorial how to build driver from source code. And why MySql don't makes
.dmg for mac OS?

Thanks!

How to connect Mysql Install on windows by ODBC from the different Loaction

Hi,
 
I am new to mysql, I have install mysql 5.5.16 on window 7. My one user is sitting in diffrent State and i want to give him access to mysql database using odbc, so that he/she can update/view the relevant infromation in the databast by using ms acces as front end. Please suggest how it is possible.
 
Thanks
Raj Kumar 

Issue with max_user_connections

Hello

I submitted patch to Percona-server bugtrack, but how can I see - MySQL 5 5 has the same issue.

Please check this thread:
<a href="https://bugs.launchpad.net/percona-server/+bug/893348" title="https://bugs.launchpad.net/percona-server/+bug/893348">https://bugs.launchpad.net/percona-server/+bug/893348</a>

You will find how to reproduce issue

Also I include patch to this email.

Hope to see this changes soon.

Regards,
Gor Martsen

IT Patrol inc.
founder

Tel: +1.647.680.4112
mail: <a href="mailto:gor@it-patrol.com">gor@it-patrol.com</a>
web: <a href="http://www.it-patrol.com" title="www.it-patrol.com">www.it-patrol.com</a>

MySQL Connector/ODBC won't connect to internal network

'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 connect to the MySQL database both via
the command-line client and via M$ Access and Excel.

I also have Virtualbox installed with a LAMP server running on a host-only
network. I can connect to the LAMP server via cmd.exe, PuTTY, Firefox, etc.

ODBC Connection between mySQL and Excel under VDI

We have converted our laptops to GENY VDI. We are unable to establish ODBC connection between mySQL and Excel. Any ideas on how to install ODBC driver for mySQL in VDI space? You may know how other users dealt with this situation or are we unique. VDI allows ODBC between MS Access or SQL server but not mySQL.

Thank You and Kind Regards,

Sunil Gosain
Office: 312-954-1735; Cell: 630-660-5470

This communication is for informational purposes only.

Starting Your Own SMS MARKETING Business- SECRET Revealed

Your email client cannot read this email.
To view it online, please go here:
<a href="http://simplysms.ug/emarketing/display.php?M=26241&amp;C=301782513b54068fb403e4ca65b27fc6&amp;S=5&amp;L=1&amp;N=3" title="http://simplysms.ug/emarketing/display.php?M=26241&amp;C=301782513b54068fb403e4ca65b27fc6&amp;S=5&amp;L=1&amp;N=3">http://simplysms.ug/emarketing/display.php?M=26241&amp;C=301782513b54068fb40...</a>

To stop receiving these
emails:http://simplysms.ug/emarketing/unsubscribe.php?M=26241&C=301782513b54068fb403e4ca65b27fc6&L=1&N=5
Powered By Elmot Ltd

Write conflict with driver 5.1.9

Using version 5.1.9 of the driver, I had several write conflict message when working on a sinle table attached in MS Access 2010.

I use the following file dsn
[ODBC]
DRIVER=MySQL ODBC 5.1 Driver
UID=...
SERVER=...
PORT=3306
OPTION=4210714
DATABASE=...
PWD=...
With the 3.5.1.23 driver none of these messages occurred.

I turn the debug on I have tried to extract the same sequence for the two drivers.

Help with Connector/ODBC 3.51.29

Hello All,

I'm trying to run a make for the Connector/ODBC 3.51.29 and run into this linking error:

# make
/bin/bash: warning: setlocale: LC_ALL: cannot change locale (en_US.ISO8859-15)
Making all in util
make[1]: Entering directory `/home/mdo/mysql-connector-odbc-3.51.29/util'
make[1]: Nothing to be done for `all'.
make[1]: Leaving directory `/home/mdo/mysql-connector-odbc-3.51.29/util'
Making all in driver
make[1]: Entering directory `/home/mdo/mysql-connector-odbc-3.51.29/driver'
/bin/bash: warning: setlocale: LC_ALL: cannot change locale (en_US.ISO8859-15)
make all-am
/bin/bash: warnin

32bit Win Apps on 64bit Systems with Transactions

I have ODBC problems von 64bit machines using transactions.

Following sample:

START TRANSACTION
SELECT ...
DELETE FROM INST_FOLDER WHERE INSTFOLDERID = 26471
SELECT ...
DELETE FROM INST_FOLDER WHERE INSTFOLDERID = 26475
...
DELETE FROM INSTRUMENT WHERE INSTID = 677469
-> SQLExecDirect Error 1451 - HY000 - [MySQL][ODBC 5.1
Driver][mysqld-5.1.47]Cannot delete or update a parent row: a foreign
key constraint fails (`PicosDbCl`.`INST_FOLDER`, CONSTRAINT
`fk_inst_folder_instrument` FOREIGN KEY (`INSTID`) REFERENCES
`INSTRUMENT` (`INSTID`))
DELETE FROM INSTRUMENT WHERE INSTID = 677470
->

make still failing

I worked around the last error by copying all the qt header files to another
directory. Now I get this:

make[1]: Leaving directory
`/home/steward/tmp/mysql-connector-odbc-5.1.8/setup'
Making all in installer
make[1]: Entering directory
`/home/steward/tmp/mysql-connector-odbc-5.1.8/installer'
gcc -DHAVE_CONFIG_H -I. -I../driver -I..

make fails #4

output from make attached

make fails #3

setup/Makefile attached

make fails #2

makefile attached

make fails #1

Your mail demon continues to reject what I send. I'm sending the files one
by one.

TIENES QUE SER COACH EJECUTIVO Y DE VIDA

Documento sin títuloCLIC AQUÍ para ver la información en línea

Usted recibe este mensaje porque: 1. Está suscrito a nuestro boletín, 2. Algún amigo suyo lo recomendo,
3. Ha participado en alguno de nuestros programas. 4. Nos ha enviado algún mensaje.

Este mensaje cumple con las políticas nacionales e internacionales anti spam. No pretendemos saturar su correo.
Si considera que recibe este correo por error, o información de este tipo no es de su interés, haga CLIC AQUÍ para eliminar su
dirección de nuestras listas, y por favor disculpe las molestias que esto le ocasiona.

2011.

error when I install mysql-odbc

I encountered an error when I installed "mysql-connector-odbc-5.1.8". I don't know what is wrong.

cpu: x86_64
mysql-5.5.15: Installed
unixODBC-2.3.0: Installed

shell>./configure --prefix=/usr/local --with-unixODBC==/usr/local --with-mysql-path=/usr/local/mysql

Success!!

shell>make

Making all in util
make[1]: Entering directory `/root/install/new/mysql-connector-odbc-5.1.8/util'
/bin/sh ../libtool --tag=CC --mode=compile gcc -DHAVE_CONFIG_H -I. -I../driver -I..

Fix for crash in mySQL ODBC Driver

the MySQL ODBC Driver was not properly honoring the RETRIEVE_DATA attribute, which is used by the OLEDB Provider for ODBC Driver.

This patch resolves that problem.

under driver, the affected files & lines are

options.c - line 110:
options->retrieve_data = (SQLULEN) ValuePtr;
options.c - line 184:
*((SQLUINTEGER *) ValuePtr)= options->retrieve_data;
handle.c -- line 210:
dbc->stmt_options.retrieve_data = TRUE;

results.c - line 1547:

if (stmt->stmt_options.retrieve_data)

Re: OS X 10.6.6 - MyODBC Connector

I had the same issue and managed to solve it by installing the 32 bit
version of the ODBC connector.

Hallo,

DSNless ODBC Connection

I connect to a MySQL database from Access using a DSN-less connection. What
must I change in the ODBC string in order to keep the connection alive for
more than a minute?

When I set up a DSN on my machine, I just check off the auto-reconnect
feature in the MySQL ODBC Connector, then the connections stay up.

How do I do this using a DSN-less connection string?

Dan Hugos

Mauch Chunk Opera House

Jim Thorpe, PA

<a href="http://www.MauchChunkOperaHouse.com" title="www.MauchChunkOperaHouse.com">www.MauchChunkOperaHouse.com</a>

570-325-2082

Altova Database Spy 2011 Needs ODBC Connector Driver

Altova Database Spy 2011 Needs ODBC Connector Driver. I cannot find one in
its selector.

SQLConnect Floating Point Exception

All,

Trying to use MySQL ODBC drivers on RHE Linux to connect from a user written program to MySQL database on a remote machine. I downloaded the latest drivers this past week, and unixODBC refreshed on machine a few days ago.

Linking on LINUX with ODBC drivers - missing libodbcinst.so.1

Hi,

I have an ODBC application on LINUX that needs to access databases on other machines using ODBC. I've downloaded the myodbc driver tarball for LINUX.

cs_mit

<a href="http://7thart.atwebpages.com/asl3.html" title="http://7thart.atwebpages.com/asl3.html">http://7thart.atwebpages.com/asl3.html</a>

cs_mit

<a href="http://jinsalang.co.kr/srs3.html" title="http://jinsalang.co.kr/srs3.html">http://jinsalang.co.kr/srs3.html</a>

date and time functions not working

Hello,

Date and time functions are not working for me when using the ODBC connector with LabVIEW.

cs_mit

<a href="http://wopsa.com/sol3.html" title="http://wopsa.com/sol3.html">http://wopsa.com/sol3.html</a>

Syndicate content