Forum for MySQL Connector/ODBC driver. http://forums.mysql.com/list.php?37 Sat, 25 May 2013 08:54:31 +0000 Phorum 5.2.19 http://forums.mysql.com/read.php?37,587285,587285#msg-587285 http://forums.mysql.com/read.php?37,587285,587285#msg-587285
I downgraded to 5.2.4(w) and the user authenticates.

MySQL Server Version: 5.0.77

ODBC Trace 5.2.4: https://gist.github.com/objnoob/c032df92832e73551581
ODBC Trace 5.2.5: https://gist.github.com/objnoob/49a933103158a562341a

When I create a System DSN using 5.2.5 and use it in lieu of a raw string it connects :\

Any insight into what could be causing this would be greatly appreciated!]]> Stephen Yoachum ODBC Fri, 24 May 2013 18:39:08 +0000 http://forums.mysql.com/read.php?37,586717,586717#msg-586717 http://forums.mysql.com/read.php?37,586717,586717#msg-586717
This installation was attempted from the ZIP version of the Connector and then this was unzipped. There should be a SETUP in the files according to the directions, but I don't see it.

I also tried to install from the MSI version, but not sure how to do that.

At any rate, I've put all my dialog boxes out at:
http://creatingnewworlds.org/odbc_install.pdf

I think I probably need to get stuff out of there first - old drivers are there as you can see on the driver list on the file above.

Any help would be approciated. This is 2010 Access, running on Windows 7.The MySQL is version 5.0.96. The host PHPAdministrator set me to the connecting IP, 50.37.173.75.]]> Carl Townsend ODBC Mon, 20 May 2013 11:09:59 +0000 http://forums.mysql.com/read.php?37,586574,586574#msg-586574 http://forums.mysql.com/read.php?37,586574,586574#msg-586574 Connector ODBC Version: 5.2.5
I try to changed field to UTF16, and use connect string:
DRIVER={MySQL ODBC 5.2 Unicode Driver};SERVER=127.0.0.1;DATABASE=richedb;UID=root;PASSWORD=root;OPTION=3;CharSet=utf16;
when I execute:
szSQL=_T("INSERT INTO test(NAME) VALUES('𢈢')");
ConnectionPtr->Execute((_bstr_t)szSQL, &RecordsAffected, adCmdText);
Is's no respond.
The character '𢈢'(UTF16 byte:0xD848DE22)
any help me!]]> freefly pan ODBC Mon, 20 May 2013 11:11:21 +0000 http://forums.mysql.com/read.php?37,586349,586349#msg-586349 http://forums.mysql.com/read.php?37,586349,586349#msg-586349
The default connection pooling seems to be on for 3.51, and off for 5.1 (at least this is what odbcad32 is telling me).

If so, is there any reason why the default is off in 5.1?

What are the implications of switching it on on a live system (e.g. will I need to restart web servers etc.)?

Thanks for any help.]]> Simon Gregory ODBC Wed, 15 May 2013 09:29:41 +0000 http://forums.mysql.com/read.php?37,586266,586266#msg-586266 http://forums.mysql.com/read.php?37,586266,586266#msg-586266 CREATE TABLE sakila.test(ID INT NOT NULL AUTO_INCREMENT,Name VARCHAR(512),KEY(ID))CHARSET=utf8mb4;

then I creat ODBC DSN with MySQL ODBC 5.2w Driver named "EDB" and set character set utf8mb4 in details.

now, in my project, I try to insert a word use MFC:

CString strSql = _T("insert into test(name) values('𢈢')");
CDatabase db;
db.Open(_T("EDB"));
db.ExecuteSQL(strSql);//error, no respond
db.Close();

If the values is character in 0x0000-0xffff, it`s work.

How to use UTF8mb4 with ODBC.]]> freefly pan ODBC Mon, 20 May 2013 11:25:37 +0000 http://forums.mysql.com/read.php?37,586132,586132#msg-586132 http://forums.mysql.com/read.php?37,586132,586132#msg-586132 szSQL.Format(_T("INSERT INTO test")
_T("(Name)")
_T("VALUES('%s')"), _T("𢈢"));
m_Conn.pConn->Execute((_bstr_t)szSQL, &RecordsAffected, adCmdText);


The program does not return，This problem has troubled me for a long time，Who can help me answer this question thanks]]> mzy ma ODBC Mon, 20 May 2013 10:13:27 +0000 http://forums.mysql.com/read.php?37,585467,585467#msg-585467 http://forums.mysql.com/read.php?37,585467,585467#msg-585467 (a) is it acceptable practice still to use 3.51
(b) any ideas why the 3.51 won't connect whereas 5.1 works fine - 3.5 used to work with this host, what could they have changed, are there any ODBC parameters where changing settings might solve this ?
(c) any comments on MySQL and Crystal ? Crystal 11 works fine with a local install of MySQL with ODBC 5.1.
Thanks.]]> Peter Kaye ODBC Sat, 04 May 2013 05:39:31 +0000 http://forums.mysql.com/read.php?37,585411,585411#msg-585411 http://forums.mysql.com/read.php?37,585411,585411#msg-585411
When I install the 32bit MySQL ODBC driver (mysql-connector-odbc-5.2.5-win32.msi) it is not available to add as new data source.

Is there a way I can make this possible or am I basically sol?

Any help would be appreciated.]]> Peter Netterville ODBC Wed, 08 May 2013 10:04:56 +0000 http://forums.mysql.com/read.php?37,585285,585285#msg-585285 http://forums.mysql.com/read.php?37,585285,585285#msg-585285
I have been developing a solution on a PC that has the following credentials:
Win 7 (64-bit)
Access 2010 (32-bit)
Connector: mysql-connector-odbc-5.2.4-ansi-win32

On this PC (PC_a) I have been able to create the linked tables, query against the linked tables to extract the data and run subsequent queries joining the data I extracted into Access tables to the linked tables.

I am developing the solution for a PC that has the following credentials:
Win 7 (64-bit)
Access 2010 (32-bit)
Connector: mysql-connector-odbc-5.2.4-ansi-win32

On this PC (PC_b) I can create the connection, link the tables, preview the data in the tables, query the tables to extract the data but the subsequent queries that join Access data to the linked tables gets the error, [ODBC--Call Failed] and references a "Server does not support 4-byte encoded UTF8 characters" statement.

I have tried several attempts to including uninstalling and re-installing, installing MySQL server 5.6 and other variations and am at my wit's end. Any help or direction would be appreciated.]]> David Davis ODBC Mon, 20 May 2013 11:32:11 +0000 http://forums.mysql.com/read.php?37,585173,585173#msg-585173 http://forums.mysql.com/read.php?37,585173,585173#msg-585173 One of my customers (the biggest) needs to add some module to his VB6-written application under Windows 95, in aim to write some production data in his MySQL plant server (V5.1).
So he asked me to do that.
I answer that there is no MySQL ODBC driver for Windows95...Am I right?

Is there any solution to install some old version driver that will work with MySQL Server 5.1 ?

I tried to install V3.51 ODBC driver for MySQL, without success : "myodbc3i.exe needs another version of windows OS. Update your windows system."

Thank you in advance for your answrers..

Best regards.]]> Patrice ARDOUIN ODBC Tue, 30 Apr 2013 09:17:40 +0000 http://forums.mysql.com/read.php?37,584979,584979#msg-584979 http://forums.mysql.com/read.php?37,584979,584979#msg-584979
I have just using the set up with a Windows 8 computer. The MySQL connector which has been installed is 5.2a. The MS Access front end appears to be working fine, except if a table has Chinese characters in its records - the table when opened says ODBC failed.

Using the Windows 8 search feature if offers ODBC connectors for 32 and 64 bit.

But I am only able to set up a DSN using the 32 bit version.

I have tried to remove the connector software, but not had any success.

What is the cause of the table with Chinese characters failing to open.

If the solution lies in removing the 32 bit MySQL connector software and using 64 bit, how is the 32 bit version removed?

Would be very grateful for any suggestions as to a solution or knowing what is causing the problem.]]> R Hubbard ODBC Mon, 29 Apr 2013 13:33:38 +0000 http://forums.mysql.com/read.php?37,584870,584870#msg-584870 http://forums.mysql.com/read.php?37,584870,584870#msg-584870
i have a problem with a concat funktion:

select concat(a, '-', b) from xyz....

It works with odbc 3.5.11 and not with newer versions.
I use the data in excel. With the newer drivers the column dissapears even i can see it in the Microsoft Query Browser.
Is that a known bug or can i make some settings in the newer driver?

I cannot use generally the old driver, cause some complicated querys are not editable with 3.5.11.

best regards and thanks in advance]]> HEIKO WIESNER ODBC Fri, 26 Apr 2013 12:25:56 +0000 http://forums.mysql.com/read.php?37,584153,584153#msg-584153 http://forums.mysql.com/read.php?37,584153,584153#msg-584153 I have successfully built the MySQL ODBC driver v5.2.4 on AIX 7.1 along with it's dependencies in 32 bit mode. The problem is that both iODBC and unixODBC are hanging during the driver loading phase.

I have written a test program that is able to connect to the database using the standard MySQ client API and perform queries so at least I know the client library is OK.

Has anybody succeeded in getting this driver working on AIX 6 or 7?

Cheers
K]]> Kristján Rúnarsson ODBC Wed, 17 Apr 2013 11:45:05 +0000 http://forums.mysql.com/read.php?37,583774,583774#msg-583774 http://forums.mysql.com/read.php?37,583774,583774#msg-583774
I am trying to set up an ODBC connection to query a MySQL Database using MS Query and complete a report using VBA, how do I go about setting up my ODBC connection, the issue I have is that the MySQL database isnt stored on a network its stored on a local drive (Z:\) rtaher than a server

Is there am alternative way to query my database via Excel/MsQuery?

Many Thanks,
Antonio]]> Antonio De Paolo ODBC Fri, 12 Apr 2013 09:57:58 +0000 http://forums.mysql.com/read.php?37,582770,582770#msg-582770 http://forums.mysql.com/read.php?37,582770,582770#msg-582770 As we all know, the ODBC driver supplied by IBM only works with MySQL Enterprise Edition. We visited the MySQL website but couldn't locate a driver for AIX.

Our server admin has procured a customized version, which when used on AIX 6.1 with DataStage 8.7 throws the following error:

DSD.BCIOpenR call to function SQLTables failed.
SQLSTATE=S1004, DBMS.CODE=0
[DataStage][SQL Client]An unsupported SQL data type was encountered

Could someone help us to find the right ODBC connector for MySQL Community Edition that works on AIX and is compatible with DataStage 8.7?

If one doesn't exist, kindly provide us with a step by step guide that will help us to compile from source on AIX 6.1.]]> Trinanjan Bhanja ODBC Sun, 31 Mar 2013 14:28:12 +0000 http://forums.mysql.com/read.php?37,582525,582525#msg-582525 http://forums.mysql.com/read.php?37,582525,582525#msg-582525 Thanks]]> Jules Witte ODBC Mon, 20 May 2013 09:54:12 +0000 http://forums.mysql.com/read.php?37,582498,582498#msg-582498 http://forums.mysql.com/read.php?37,582498,582498#msg-582498
Can anyone tell me how to change my security preferences? I can't seem to find it!

Thanks in advance. Please email me directly and post to this forum.

Linda
-------
Linda@compu-books.com]]> Linda Carter ODBC Tue, 09 Apr 2013 17:05:10 +0000 http://forums.mysql.com/read.php?37,582363,582363#msg-582363 http://forums.mysql.com/read.php?37,582363,582363#msg-582363
I tried out the MySQL ODBC client Version 5.2 with a Visual Foxpro 9 based application. Using a CursorAdapter crashes the whole application (no specific error message, just a GPF) on the "cursorfill" method of the CursorAdapter. The same application works fine and stable with MySQL ODBC 5.1 (any version) connecting to the same server. Also SQL-passthrough commands (SQLEXEC) seem to work without problems. I tried out several options including the new "no_ssps"-option without effect.
There must be some behaviour change in the ODBC 5.2 Client that leads to the crash.

Thank you very much for any suggestions!

PS: The Crash occurs with both client Versions 5.2a and 5.2w

Environment:
* MySQL Community Edition 5.6 (tried 5.1,5.5 also) 64Bit
* Windows 7 64Bit
* MySQL ODBC 5.2.4 32Bit
* VFP 9.0 SP1 Build 7423



Kind regards,
Gerold]]> Gerold Lübben ODBC Tue, 26 Mar 2013 10:30:19 +0000 http://forums.mysql.com/read.php?37,582362,582362#msg-582362 http://forums.mysql.com/read.php?37,582362,582362#msg-582362 (I'm NOT searching the other way round, I don't want a table in Access linking to a MySQL table)

Accessing MySQL tables in Access is very easy, so is the other way round also possible?


The data in Access changes daily, so only exporting the tables to MySQL is no option, i need to synchronize the data somehow. Changes in Access need to be transfered also to the MySQL DB.]]> Annika Korz ODBC Tue, 26 Mar 2013 14:41:10 +0000 http://forums.mysql.com/read.php?37,581875,581875#msg-581875 http://forums.mysql.com/read.php?37,581875,581875#msg-581875
I was looking at this because I found a problem using prepared statements with the C/C++ APIs. Certain SQL with VIEWs cause the server to crash when they are executed more than once. It does not happen when using ODBC. Looks that is because it is only executes a prepared statement once.]]> Tim Besser ODBC Thu, 28 Mar 2013 14:03:49 +0000 http://forums.mysql.com/read.php?37,581818,581818#msg-581818 http://forums.mysql.com/read.php?37,581818,581818#msg-581818
How do I get a standard connection string to work using an ADODB.Connection on the same machine? I want to first get the connection running on the same machine, and then try connecting to MySQL from Excel on another machine in the network. I have a Uid and Pwd working from Workbench, and the current string I tried is
cn.Open "DRIVER={MySQL ODBC 5.2w Driver};UID=adasgupta;PWD=mypwd;Database=Sakila;"
For the post, I've just replaced the actual password here with mypwd. When I run it, I get an error that says data source name not found and no default driver specified. I've referenced the Activex Data Objects 6.0 library in VBA.]]> Arijit Dasgupta ODBC Mon, 20 May 2013 10:36:17 +0000 http://forums.mysql.com/read.php?37,581488,581488#msg-581488 http://forums.mysql.com/read.php?37,581488,581488#msg-581488
I'm trying to establish a connection to an online MySQL database. I have downloaded the latest connector from the web page, configured the DSN as recommended, but still not able to establish a successful connection.

When I take a look at the ODBC connector I don't find any connector for Mac OS X 10.8. The last version of OS X supported seems to be 10.7. Does this connector actually works with 10.8? Did anyone try it?

Is the first time I post here so if you need more information or any log files please tell me and I will provide them asap.

Thanks in advance!

Best Regards,

Rodrigo]]> Rodrigo Alvez ODBC Sun, 05 May 2013 23:17:54 +0000 http://forums.mysql.com/read.php?37,581419,581419#msg-581419 http://forums.mysql.com/read.php?37,581419,581419#msg-581419
Open Office now has it's own, native, MySQL connector... it is a normal "extension".

For help with getting MySQL (server) and Open Office "Base" (dreadful name!) (client) "playing nicely" together, see....

http://sheepdogguides.com/srv/s0MySqlDoInst.htm]]> Sheep dog ODBC Fri, 15 Mar 2013 10:16:30 +0000 http://forums.mysql.com/read.php?37,581165,581165#msg-581165 http://forums.mysql.com/read.php?37,581165,581165#msg-581165 ODBC Connector 5.2
Excel 2010
Win7 (Ent) 64

I can setup the connector with no problem (tests fine). But when I goto Excel, to connect to other ODBC connections, I get the following message:

the specified DSN contains an architecture mismatch

I have read where I should try the following:

1. Load 32bit version, then overlay with 64bit version (results in a catastrophic error).
2. Use just the 32bit version, the driver isn't even recognized.
3. Tried using the 5.1.9 build, the same initial issue.

This screams a interaction issue with Excel, but I'm at my wits end on what to try next. I'm sure somebody has been successful with this config before. SO if you would be kind enough to share your recipe. I would be most beholding to you.

THanks,
D-]]> Don Potter ODBC Tue, 12 Mar 2013 19:01:02 +0000 http://forums.mysql.com/read.php?37,580577,580577#msg-580577 http://forums.mysql.com/read.php?37,580577,580577#msg-580577
Thanks all

the specified DSN contains an architecture mismatch between the driver and application

Setting up the data source is successful. Only happens when in the application and trying to add a new source in mailings in Word for example.]]> David Potter ODBC Mon, 04 Mar 2013 23:54:31 +0000 http://forums.mysql.com/read.php?37,580081,580081#msg-580081 http://forums.mysql.com/read.php?37,580081,580081#msg-580081
I am often having to recompile my source code due to the ever-changing nature of the ODBC driver= string. A couple months ago it was suffixed with "CE", then the suffix became "W", now it is "A". As the string also contains the a portion of the version number ("5.2"), it is obvious that the string will never be static. I've now decided to make my programs read an external flat file, and to obtain the driver name from it. I'll then at least be able to avoid the frequent recompiles.

Programmatically ensuring end-users are running the current version is also a little screwy. The file "myodbc5w.dll" is older than "myodbc5a.dll", so the naming convention does not seem to indicate which is the current file. Yet, if I search the install directory using a wildcard for the suffix, in order to check file version numbers, i'll gets hits on both a "myodbc5a.dll" and a "myodbc5S.dll". Granted, they should both return the same version number, but if the core library has a variable suffix, like "myodbc5w.dll" or "myodbc5a.dll", why is there a library with a different purpose following the same naming convention?

Wouldn't it create less confusion to give the setup library a more unique name, rather than making it look like a version of the core library?

Is there a reason not to maintain a more static connection string such as "Driver={MySQL ODBC5 Driver};" and eliminate the need for constant program maintenance?

It's been a long day here, I hope I don't come across as grumpy.
Any replies are greatly appreciated.]]> Paul Williams ODBC Tue, 26 Feb 2013 21:19:12 +0000 http://forums.mysql.com/read.php?37,580028,580028#msg-580028 http://forums.mysql.com/read.php?37,580028,580028#msg-580028
I have a intranetsite running on PHP & Mysql. "Live" I've got 1118 records in my database (PHPmanager).But when I make a connection throught ODBC to do a mailmerge only 1113 records show up. The last 5 do not for some reason...
I presume that there is no some kind of limit when using ODBC ?

This setup is working almost 3 years now and nothing has been changed ?

Perhaps anyone has had this kind of behavior before ?

Any help appreciated !

Stefan]]> Stefan Fets ODBC Tue, 26 Feb 2013 12:07:09 +0000 http://forums.mysql.com/read.php?37,579996,579996#msg-579996 http://forums.mysql.com/read.php?37,579996,579996#msg-579996 http://dev.mysql.com/downloads/connector/odbc/#downloads

Inside that there is a build.win which says that one needs to install CMake, setup an environment variable and fire up cmake which generates the native makefiles (or .sln file for VS2012).

This doesn't work. The error is

C:\projects\MySQL.Connectors\mysql-connector-odbc-5.2.4-src> cmake -G "Visual Studio 11 Win64"
-- The C compiler identification is MSVC 17.0.51106.1
-- The CXX compiler identification is MSVC 17.0.51106.1
-- Check for working C compiler using: Visual Studio 11 Win64
-- Check for working C compiler using: Visual Studio 11 Win64 -- broken
CMake Error at C:/Program Files (x86)/CMake 2.8/share/cmake-2.8/Modules/CMakeTestCCompiler.cmake:61 (message):
The C compiler "C:/Program Files (x86)/Microsoft Visual Studio
11.0/VC/bin/x86_amd64/cl.exe" is not able to compile a simple test program.

It fails with the following output:

Change Dir: C:/projects/MySQL.Connectors/mysql-connector-odbc-5.2.4-src/CMakeFiles/CMakeTmp

Run Build Command:C:\PROGRA~2\MICROS~1.0\Common7\IDE\devenv.com
CMAKE_TRY_COMPILE.sln /build Debug /project cmTryCompileExec3889604268


Question: How does one build the ODBC driver on Windows? I'm aware of the .NET connector - we're targetting the ODBC driver specifically. Thanks]]> Sid Shetye ODBC Mon, 25 Feb 2013 23:02:40 +0000 http://forums.mysql.com/read.php?37,579576,579576#msg-579576 http://forums.mysql.com/read.php?37,579576,579576#msg-579576
I'm sorry if there is an information about this already on this forum. I wasn't able to find one.
I have a mySQL 5.6.10 CE server running and trying to connect with an ODBC connector 5.1.6 from an IBM p-Series with AIX 6.1. I could connect a 5.1.45 CE server without any problems before.
I did the tests with mysql_client_test, but these fail right after the connect, which was successful. I added the output from mysql_client_test below.
I'm not so experienced with mySQL and trying to get close to the error step by step.

So my first question is: Is it possible to connect with the ODBC 5.1.6 to the 5.6.10 server?

If it is necessary to use a newer ODBC connector version, is someone aware of compiled versions for AIX?

Thanks in advance!

Regards,
Oliver

=======================================================

Output from mysql_client_text (I run the checks as dba. It also creates the client_test_db, but empty):

#####################################
client_connect
#####################################

Establishing a connection to 'xxxxxxxx' ...OK
Connected to MySQL server version: 5.6.10-log (50610)

Creating a test database 'client_test_db' ...mysql_client_test.c:248: check failed: 'row']]> Oliver Brehm ODBC Fri, 22 Feb 2013 12:20:23 +0000 http://forums.mysql.com/read.php?37,579399,579399#msg-579399 http://forums.mysql.com/read.php?37,579399,579399#msg-579399
I try to connect to MySQL 5.6 server through MySQL ODBC connector 5.2(w) from ADO.NET. I write a simple code in C#.

static void Main(string[] args) {
using (OdbcConnection connection = new OdbcConnection("DSN=MYDSN")){
connection.Open();
DataTable tables = connection.GetSchema("Tables");
DataTable datatypes = connection.GetSchema("DataTypes");
}
}

connection.GetSchema("DataTypes") method throw an exception:
System.AccessViolationException
Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

Stack Trace

at System.Data.Common.UnsafeNativeMethods.SQLFreeStmt(OdbcStatementHandle StatementHandle, STMT Option)
at System.Data.Odbc.OdbcStatementHandle.FreeStatement(STMT stmt)
at System.Data.Odbc.CMDWrapper.FreeStatementHandle(STMT stmt)
at System.Data.Odbc.OdbcDataReader.Close(Boolean disposing)
at System.Data.Odbc.OdbcDataReader.Dispose(Boolean disposing)
at System.Data.Common.DbDataReader.Dispose()
at System.Data.Odbc.OdbcMetaDataFactory.GetDataTypesCollection(String[] restrictions, OdbcConnection connection)
at System.Data.Odbc.OdbcMetaDataFactory.PrepareCollection(String collectionName, String[] restrictions, DbConnection connection)
at System.Data.ProviderBase.DbMetaDataFactory.GetSchema(DbConnection connection, String collectionName, String[] restrictions)
at System.Data.ProviderBase.DbConnectionInternal.GetSchema(DbConnectionFactory factory, DbConnectionPoolGroup poolGroup, DbConnection outerConnection, String collectionName, String[] restrictions)
at System.Data.Odbc.OdbcConnection.GetSchema(String collectionName, String[] restrictionValues)
at System.Data.Odbc.OdbcConnection.GetSchema(String collectionName)
at ConsoleApplication3.Program.Main(String[] args)

ODBC connector architecture is x86.

Anyone know how to fix this problem?

Thanks!]]> Pavel M ODBC Mon, 18 Feb 2013 16:20:55 +0000