Remote View with MySQL Connector 5.2 crash

[vhad]

My application crash when creating remote view / cursoradapter with MySQL Connector 5.2
SQL Pass Through works fine using the connector.

I am Using
- VFP 9.0 SP2
- Windows XP Pro
- MySQL Connector 5.2.6

Any solution to this problem?

Thanks in Advance

 

[Olaf Doschke]

Error?
You did install the 32bit driver, did you?

Bye, Olaf.

 

[vhad]

Thanks Olaf,

Yes. I do install the 32bit driver.

It works fine when I use SQLEXEC command to get data.
But VFP crash when I create RemoteView using that MySQL 5.2 connector.
Tried to use UNICODE and ANSI version. Both crash.

It works OK with MySQL 5.1 connector.

Regards,

 

[JRB-Bldr]

If I am asking the obvious, I apologize in advance.

But just because it wasn't specifically mentioned and just to be sure....

When you installed the 32-bit ODBC driver you installed it with:
C:\Windows\SysWOW64\odbcad32.exe

And within the VFP Database that contains your Remote View, you have defined a Database Connection using that same ODBC driver (for example named: MySQLConnection)?

And, lastly, when you created your VFP Remote View you did something like the following so that your VFP Database Connection is specified:

   CREATE SQL VIEW MySQLDataView;
   REMOTE CONNECTION "MySQLConnection";
   SHARE AS ;
   SELECT * ;
   FROM MySQLDataTable ;
   WHERE <whatever>

Good Luck,
JRB-Bldr

 

[vhad]

Thanks JRN-Bldr

I am using Windows XP Pro.
And I created the remote view using wizard.

Here is what I did :

I get the ODBC installer from MYSQL official web-site.
mysql-connector-odbc-5.2.6-win32.msi

After I install the driver installed on the ODBC Data Source Administrator are :
- MySQL ODBC 5.2 ANSI Driver
- MySQL ODBC 5.2 Unicode Driver

Then I create a UserDSN with that driver. And name it 'test'

Then in VFP I create a new database.

And then create a remote view using Wizard :
- Step 1 : Data Source : ODBC data sources, and choose 'test' DSN
- Step 2 : I choose a table and fields
- And Click Finish, with option save remote view

This is where the crash occurs.

Regards,

 

[Olaf Doschke]

>crash
What's the error? Is there any? What happens and/or is displayed?
What are field types?

Bye, Olaf.

 

[Olaf Doschke]

I just tried the driver myself. It simply doesn't work with a DSN.
Just choosing a table crashes, I don't even get to see a field list.

I tried several options and also using a connection string.

To make it short: It doesn't work.
Also see:

http://forums.mysql.com/read.php?126,582310,582310#msg-582310

So either only use it with sql passthrough or use 5.1 drivers.

Bye, Olaf.

 

[vhad]

Thanks Olaf,

Yes. I think I have to live with it.
There is no workaround for this problem.

Thanks for your effort.

Regards,

 

[vhad]

At the time I asked this question the last version of MySQL Connector was 5.2.6 and 5.3.0 Alpha. Both crash my VFP.
I was very sad.

Today, I tried with the last version of MySQL Connector is 5.3.2.
Surprisingly, the problem was disappear. Bug fixed.

Now I am happy again.

Regards,

 

[Mike Lewis]

Glad to hear you are happy again, Vhad. Thanks for letting us know. It's always good to hear of problems being solved, if only for the benefit of others who come up against the same issues.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads