Stack Overflow
Stack Overflow

Questions tagged [mysql-odbc-connector]

MySQL Connector/ODBC is a standardized database driver for Windows, Linux, Mac OS X, and Unix platforms.

39 questions
12
votes
4 answers

Incorrect string value: '\xC2\x9Fe 10...' for column

We have a Old 5.1 Mysql server running on server 2003. Recently we move to a newer environment with Mysql 5.6 and server 2008. Now on the new server we keep getting errors when inserting special chars like 'Ã'. Now I have checked the source encoding…
Florian Schaal
  • 2,586
  • 3
  • 39
  • 59
9
votes
3 answers

Installation failed trying to install MySQL ODBC connector on macOS High Sierra

I'm trying to install this mysql odbc connector on my macOS High Sierra machine, but I get this error: I tried installing it using installer in the hopes of getting information about what went wrong: ➜ ~ sudo installer -pkg…
L42
  • 3,052
  • 4
  • 28
  • 49
7
votes
5 answers

I'm trying to install the MySQL connector on a windows 7 systembut it doesn't show up in the ODBC add window

This is under Windows 7 64 bit. I downloaded the 64 bit drivers and as a matter of fact I tried all the windows drivers(uninstalling the previous ones first though). But when I try to configure a new ODBC connection the MySQL driver doesn't show…
Peter
  • 148
  • 1
  • 2
  • 18
5
votes
1 answer

How to fix ODBC Driver 8.0 SQL syntax error in SSIS?

I have a SSIS package which is used to export data from a MySQL database to a SQL database. For some reason, I can only read data using the ODBC Source item but I cannot preview the table, also, while doing some other tests I found out I can't…
user9260347
  • 61
  • 1
  • 2
  • 6
5
votes
3 answers

Deleting/Editing rows in MySQL ODBC linked table results in error in MS Access

I am using MS Access 2003 under Windows 7 (64bit), with external linked table at MySQL server (5.0.51a-24+lenny5), connected via MySQL ODBC connector (using 5.1.10, because the newest 5.1.11 is buggy). When I open this table in MS Access and try to…
Tomas
  • 57,621
  • 49
  • 238
  • 373
4
votes
2 answers

Unable to transfer SQL Server varchar(max) to MySQL text using SSIS

I'm trying to transfer a table from SQL Server to MySQL using SSIS and it is failing on one column that is varchar(max) on SQL Server and text on MySQL. So far I have tried doing this as an OLE DB to ODBC data flow, as well as BCP out into a flat…
David
  • 142
  • 1
  • 8
4
votes
2 answers

MySQL ODBC connector 32bit or 64bit?

I want a 32bit bit application (running on Windows 7 64bit) to connect to MySQL 5 64bit through ODBC. Does the MySQL ODBC connector have to be 32 or 64 bit? Does the MySQL ODBC connector's register size have to match the application's or MySQL's?…
Raffael
  • 19,547
  • 15
  • 82
  • 160
3
votes
1 answer

Is there compatible ODBC driver with Mariadb 10 on Linux?

I tried to use MySQL ODBC driver but that resulted in an error when I compile. MySQL ODBC driver is fine with Mariadb 5.5 but not Mariadb 10. So is there ODBC driver for Mariadb 10? I installed MySQL Connector ODBC Driver source code version. The…
kijeong
  • 71
  • 8
2
votes
0 answers

MySQL ODBC performance issue in SSIS package after upgrade to 2019 version

We have recently upgraded the SQL Server and SSIS projects from 2012 to 2019 version. Since this upgrade, one SSIS project is taking very huge time for completion. This SSIS project has a package which loads data from MySQL ODBC source and insert it…
Samay
  • 503
  • 6
  • 14
2
votes
0 answers

LinkTable is not editable in MS Access

I have MySQL table which is linked to access using odbc(Mysql ODBC connector 8.0 32 bit). Initially one of the column has length of Varchar(1000) and everything works fine. However now I need to increase the column size to Varchar(2000). However as…
Maqsood
  • 369
  • 4
  • 17
2
votes
0 answers

Prevent MySQL Connector/ODBC Data Source Configuration window from appearing when connection fails

On Excel I have a table that uses MySQL Connector/ODBC to get external data from a database. If the connection fails when I refresh it the MySQL Connector/ODBC Data Source Configuration window appears. Instead of that I want to present the user…
user7393973
  • 2,270
  • 1
  • 20
  • 58
2
votes
0 answers

SSRS passing parameters as '?' to ODBC

I have a windows server in which I have installed SSRS to make some reports out of a mySQL database. SSRS is connected through "MySQL ODBC 5.3 Unicode Driver". I remember the reports working fine just before upgrading the ODBC driver but now I…
BI_guy
  • 21
  • 1
2
votes
1 answer

Which odbc connector to use?

I am getting this error from the following code: $result = odbc_connect("DRIVER={MySQL ODBC 3.51 Driver};Server=localhost;Database=$database_name",$database_username, $database_password); Warning: odbc_connect(): SQL error: [unixODBC][Driver…
Ozair Kafray
  • 13,351
  • 8
  • 59
  • 84
1
vote
0 answers

How do I keep both version 8.0 and 5.1 of the MySQL ODBC connector?

I installed MySQL Connector/ODBC 8.0 with the MSI installer on my development machine but it automatically uninstalled the MySQL Connector/ODBC 5.1 driver. I reinstalled MySQL Connector/ODBC 5.1 with the MSI installer and both work in parallel…
Toothbrush
  • 2,080
  • 24
  • 33
1
vote
0 answers

SSIS Error: Disconnected recordsets are not available from ODBC connections

I have one EXECUTE SQL TASK in SSIS package , Task Type: Execute SQL TASK Data Source Type: ODBC for MySql (DSN) Error : [Execute SQL Task] Error: Executing the query "select * from nasb_dev.v_borrower_address" failed with the following…
Ali
  • 91
  • 1
  • 8
1
2 3