ODBC error on secondary layer with polygons

[gombi]

Dear All,

I have an interesting problem:
I use polygon layer and I want to colour with a secondary table from Teradata through Teradata ODBC.
This generates an SQL string which is correct (because through MS Access pass-through query runs correctly)
but MapGuide 6 gives the error:"Unable to retrieve data for layer ..... The query posed to data source failed to execute. ODBC driver does not support the requested properties. SQL statement:
SELECT megye_kod, megye_nev || ': ' || perc_imei_megye || '% '
FROM VD21_salesmap.V2112_weekly_sold_megye
Where (tol = cast ('2003-01-23' as date)) AND
(megye_kod IN ('1', '10','11','12','13','14','15','16','17','18','19','2','20','3','4','5','6','7','8','9'))."

How can I avoid this error? I'm asking your help.
Other queries where are no secondary layer on poligons, run successfully, but this only fails.

bYe,
Laszlo Gombos
Development
Pannon GSM
Hungary

[Anonymous]

Dear All,
I have an interesting problem:
I use polygon layer and I want to colour with a secondary table from
Teradata through Teradata ODBC.
This generates an SQL string which is correct (because through MS Access
pass-through query runs correctly)
but MapGuide 6 gives the error:"Unable to retrieve data for layer ..... The
query posed to data source failed to execute. ODBC driver does not support
the requested properties. SQL statement:
SELECT megye_kod, megye_nev || ': ' || perc_imei_megye || '% '
FROM VD21_salesmap.V2112_weekly_sold_megye
Where (tol = cast ('2003-01-23' as date)) AND
(megye_kod IN ('1',
'10','11','12','13','14','15','16','17','18','19','2','20','3','4','5','6','
7','8','9'))."
How can I avoid this error? I'm asking your help.
Other queries where are no secondary layer on poligons, run successfully,
but this only fails.
bYe,
Laszlo Gombos
Development
Pannon GSM
Hungary


Hello,
We have very similar problem. We used database as data-source for displaying
MapTip and Url for a polygon layer. We are using "Link to secondary table"
tool in Author. Everything works good when it was an Access database. But
when we tried use MySQL database, we obtained the same error message.
Did anyone knows, where we are wrong?

Jacek Przepiorkiewicz
MODGiK/SIT Lodz, Poland
www.modgik.lodz.pl

[gombi]

I have found the cause of this error: it is with the Microsoft OLE DB:
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B237615

I didn't solved the problem, we want download the fix.

Gombos Laszlo

[Anonymous]

as I know, and after ... digging ... MySQL is not supported by MG.
Kalmy



"JP" wrote in message
news:291FDD0C3331FD053EF95CFE03226222@in.WebX.maYIadrTaRb...
>
> Dear All,
> I have an interesting problem:
> I use polygon layer and I want to colour with a secondary table from
> Teradata through Teradata ODBC.
> This generates an SQL string which is correct (because through MS Access
> pass-through query runs correctly)
> but MapGuide 6 gives the error:"Unable to retrieve data for layer .....
The
> query posed to data source failed to execute. ODBC driver does not support
> the requested properties. SQL statement:
> SELECT megye_kod, megye_nev || ': ' || perc_imei_megye || '% '
> FROM VD21_salesmap.V2112_weekly_sold_megye
> Where (tol = cast ('2003-01-23' as date)) AND
> (megye_kod IN ('1',
>
'10','11','12','13','14','15','16','17','18','19','2','20','3','4','5','6','
> 7','8','9'))."
> How can I avoid this error? I'm asking your help.
> Other queries where are no secondary layer on poligons, run successfully,
> but this only fails.
> bYe,
> Laszlo Gombos
> Development
> Pannon GSM
> Hungary
>
>
> Hello,
> We have very similar problem. We used database as data-source for
displaying
> MapTip and Url for a polygon layer. We are using "Link to secondary table"
> tool in Author. Everything works good when it was an Access database. But
> when we tried use MySQL database, we obtained the same error message.
> Did anyone knows, where we are wrong?
>
> Jacek Przepiorkiewicz
> MODGiK/SIT Lodz, Poland
> www.modgik.lodz.pl
>
>