microstation and mysql
am 08.01.2008 14:29:27 von aberenyi
--------------080900070905040906060602
Content-Type: text/plain; charset=ISO-8859-2; format=flowed
Content-Transfer-Encoding: 7bit
Dear Folks,
I'm trying to connect a MySQL database (hosted by a linux box) with a
Microstation (running on an XP) drawing. After successful connection the
Microstation creates a table named MSCATALOG in the database, and I'm
able to add content to this MSCATALOG table. But if I try to close the
window Microstation tries to create the MSCATALOG table once again then
it fails :"Unable to update MSCATALOG table"...it's very annoying.
I've tried with myodbc 3.51 and with myodbc 5.1 but the problem persist.
Anyone faced this problem before?
Any suggestion?
Thanks in advance,
Attila
--------------080900070905040906060602--
Re: microstation and mysql
am 08.01.2008 18:14:04 von Jess Balint
Attila-
My first guess would be to enable the "Return matched rows instead
of affected rows" option on the DSN. If you don't already have this
enabled, please give it a try.
Jess
On Tue, Jan 08, 2008 at 02:29:27PM +0100, Attila Ber?nyi wrote:
> Dear Folks,
>
> I'm trying to connect a MySQL database (hosted by a linux box) with a
> Microstation (running on an XP) drawing. After successful connection the
> Microstation creates a table named MSCATALOG in the database, and I'm
> able to add content to this MSCATALOG table. But if I try to close the
> window Microstation tries to create the MSCATALOG table once again then
> it fails :"Unable to update MSCATALOG table"...it's very annoying.
> I've tried with myodbc 3.51 and with myodbc 5.1 but the problem persist.
>
> Anyone faced this problem before?
>
> Any suggestion?
>
> Thanks in advance,
>
> Attila
>
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org
Re: microstation and mysql
am 09.01.2008 08:27:52 von aberenyi
--------------010504080307090801070701
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
Dear Jess,
Thank you for your fast reply, I've tried but no success at all...:(
I've forgot to mention, that I try with Microstation V8 XM and MySQL
5.0.44 if it counts.
Attila
Jess Balint írta:
> Attila-
>
> My first guess would be to enable the "Return matched rows instead
> of affected rows" option on the DSN. If you don't already have this
> enabled, please give it a try.
>
> Jess
>
> On Tue, Jan 08, 2008 at 02:29:27PM +0100, Attila Ber?nyi wrote:
>
>> Dear Folks,
>>
>> I'm trying to connect a MySQL database (hosted by a linux box) with a
>> Microstation (running on an XP) drawing. After successful connection the
>> Microstation creates a table named MSCATALOG in the database, and I'm
>> able to add content to this MSCATALOG table. But if I try to close the
>> window Microstation tries to create the MSCATALOG table once again then
>> it fails :"Unable to update MSCATALOG table"...it's very annoying.
>> I've tried with myodbc 3.51 and with myodbc 5.1 but the problem persist.
>>
>> Anyone faced this problem before?
>>
>> Any suggestion?
>>
>> Thanks in advance,
>>
>> Attila
>>
>>
>
>
--
Berényi Attila Attila Berényi
térinformatikus GIS engineer
Burken Kft. Burken Ltd.
--------------------------------------
H-1155 Budapest, Obsitos tér 2.
Tel.: +36-1-415-0219
+36-1-415-0220
Fax: +36-1-410-1314
E-mail: aberenyi@burken.hu
--------------010504080307090801070701--
Re: microstation and mysql
am 09.01.2008 12:57:47 von aberenyi
--------------060804080509090600020903
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
Dear Jess,
I've found a "solution". If I create a m$ access database containing
only a link to every single table in my MySQL database, and I connect to
this access database the Microstation functions are working well and I'm
able to run queries on my database. But it's not the way it should work,
so if you have any other idea please share with me.
Thanks,
Attila
Jess Balint írta:
> Attila-
>
> My first guess would be to enable the "Return matched rows instead
> of affected rows" option on the DSN. If you don't already have this
> enabled, please give it a try.
>
> Jess
>
> On Tue, Jan 08, 2008 at 02:29:27PM +0100, Attila Ber?nyi wrote:
>
>> Dear Folks,
>>
>> I'm trying to connect a MySQL database (hosted by a linux box) with a
>> Microstation (running on an XP) drawing. After successful connection the
>> Microstation creates a table named MSCATALOG in the database, and I'm
>> able to add content to this MSCATALOG table. But if I try to close the
>> window Microstation tries to create the MSCATALOG table once again then
>> it fails :"Unable to update MSCATALOG table"...it's very annoying.
>> I've tried with myodbc 3.51 and with myodbc 5.1 but the problem persist.
>>
>> Anyone faced this problem before?
>>
>> Any suggestion?
>>
>> Thanks in advance,
>>
>> Attila
>>
>>
>
>
--------------060804080509090600020903--