MySQL does not work in Visual Interdev

[NRGeti]

I set up a MySQL data base and tried to communicate with it using a web page
built in Visual Interdev. I am getting some problems. The same web pages but
using Access works perfectly.

The problems fall into these general cases:
1. Text fields displayed on the web pages are padded with question marks.
2. The Grid and RecordSetNav controls in conjunction with the RecordSet
control do not step through the underlying table. These controls are the
Design Time Controls (DTC) found in the left toolbox panel of the VI screen.

3. Only one field displays data in the grid control. All other fields in the grid are empty.

 

[palbano]

>> The same web pages but
>> using Access works perfectly.

First all database do not support the exact same SQL features. Also if the schema is not exactly the same there would be obvious problems.

There are many other reasons you could see the behavior you describe. Are you even connecting to the database?

-pete

 

[NRGeti]

Yes. The test connection works fine. I also can click on the Open option of the drop down list for the data command and display all of the records in the database.

 

[palbano]

Did you just change the connection out from under the DTC Recordset control? If so I don't think that works. I have a vague memory that i had to delete the previous one and drop a new one on the page and set it up from scratch.

-pete

 

[NRGeti]

I don't understand what you mean to change the connection out from under the DTC Recordset control.

When the control is first dropped on the web page, it defaults to the first entry in the Global.asa/Environment. I have to use the drop down list to pick the connection name that I want.

In any case I created a new DSN and a new web page. But the problem still exists.

 

[palbano]

>> what you mean to change the connection out from under
>> the DTC Recordset control

Yeah that was a poorly written post, sorry.

>> I have to use the drop down list to pick the connection
>> name that I want

Yes that's what i meant.

>> I created a new DSN and a new web page

Well currently i'm out of ideas. When i read your previous posts i don't spot anything wrong but lets recap.

You drop a Recordset DTC and connect it with a Database connection that shows records in the tables in the data environment. Then you add a DTC Editbox and link it to the Recordset and select one of the fields from the combobox fields list in the properties.

After doing this you run the page and get the ????? in the edit box.

Is that correct?

-pete

 

[NRGeti]

That describes one of my problems. I found that if I highlighted the question marks and deleted them then they were gone permanently from the web page as I stepped through the records.

The other problem was that the grid DTC does not work. I used the same Data Connection and Data Command objects for all of my tests.

The select string of the Data Command object is:

"SELECT product.*, product_type.type_description FROM product, product_type WHERE (product.type_id = product_type.product_type) ORDER BY product.type_id, product.description"

Results:
The grid shows just one line and the first column contains the data; the other three columns are empty. If I set up row navigation with a color, then the next record button changes the color of that one line just as though the full grid was there but hidden while the record pointer moved to the next record.

What I really want to know is whether MySql works with VI or I have something corrupted on my PC. It would be great if you could test this situation on your PC.

 

[palbano]

>> It would be great if you could test this situation on
>> your PC.

Don't have MySql and don't want it. ;-)

>> What I really want to know is whether MySql works with VI

Technically VI does not know it's working with MySql, that's what the drivers do.

Have you tried executing that query you posted directly in the MySql environment, or even the Interdev Query window?

"????????" How did you get the data into MySql? If the data in your database is UNICODE perhaps the driver your using does not support UNICODE. Of course you are using the latest driver yes?

-pete