Skip to content
+1-888-319-3663

COMMUNITY FORUM

Error Connection MySql

Alexander Jaen asked 5 years ago
The SmartConnect stops working when trying to create an ODBC type select DNS, which is 64 bits to MySql. If I try to create it directar with Local MySql, it indicates that the credentials are valid for that situation, use DNS.
 
Error Event View
Event xmlns=”http://schemas.microsoft.com/win/2004/08/events/event>


<System>


  <Provider Name=”Application Error />


  <EventID Qualifiers=”0>1000</EventID>


  <Level>2</Level>


  <Task>100</Task>


  <Keywords>0x80000000000000</Keywords>


  <TimeCreated SystemTime=”2016-10-31T14:32:20.228115400Z />


  <EventRecordID>20500</EventRecordID>


  <Channel>Application</Channel>


  <Computer>J2EE</Computer>


  <Security />

  </System>



<EventData>


  <Data>iCloudDrive.exe</Data>


  <Data>1.6.10.45</Data>


  <Data>57f2c9f3</Data>


  <Data>iCloudDrive_main.dll</Data>


  <Data>1.6.10.45</Data>


  <Data>57f5e285</Data>


  <Data>c0000005</Data>


  <Data>0010025c</Data>


  <Data>1660</Data>


  <Data>01d23383408a47b0</Data>


  <Data>C:\Program Files (x86)\Common Files\Apple\Internet Services\iCloudDrive.exe</Data>


  <Data>C:\Program Files (x86)\Common Files\Apple\Internet Services\iCloudDrive_main.dll</Data>


  <Data>b5dae692-8468-4a4c-b934-3a0a7c1ed7d5</Data>


  <Data />


  <Data />

  </EventData>


  </Event>

 
Answers
Patrick Roth Staff answered 5 years ago
SmartConnect is a 32bit application and so therefore you would need to use 32bit drivers.
Also see also:
http://www.eonesolutions.com/blog-post/using-smartconnect-to-connect-to-odbc-datasource/
 
Alexander replied 5 years ago

thanks for your prompt reply, if he had read the article you send me. Like change the 32-bit ODBC error persists.

Lorren Zemke Staff replied 5 years ago

Alexander, are you able to connect to MySQL when you use a machine DNS outside of Smartconnect? Make sure you have downloaded the most recent MySQL ODBC Drivers.

Alexander replied 5 years ago

If I can connect to MySql from outside SmartConnect. I have installed the driver is the Connector / ODBC 5.3.6 web https://dev.mysql.com/downloads/connector/odbc/


If you would like to submit an answer or comment, please sign in to the eOne portal.