microstation and mysql
in [MyODBC]
|
Prev: Posta elettronica che mostra le nuove misure di securezza !
Next: Effetuare l'aggiornamento dei dati cliccando sul seguente collegamento sicuro
From: =?ISO-8859-2?Q?Attila_Ber=E9nyi?= on 8 Jan 2008 08:30 --------------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--
From: Jess Balint on 8 Jan 2008 12:14 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=myodbc(a)freebsd.csie.nctu.edu.tw
From: =?ISO-8859-1?Q?Attila_Ber=E9nyi?= on 9 Jan 2008 02:28 --------------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(a)burken.hu --------------010504080307090801070701--
From: =?ISO-8859-1?Q?Attila_Ber=E9nyi?= on 9 Jan 2008 06:59
--------------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-- |