Very Computer

1. R: RE MySQL -> Linked Server in MS SQL Server

Ok! This works, but what about modifying fields in the MySQL Linked
Server ?
I have this problem from long ago.=20
I'm waiting for a new ODBC driver with at least the ability to send two
distinct command as a workaround for the need for the openquery call to
have something in return.=20

Eg:=20
select a.* from openquery(MySQLLinkedServer, 'INSERT INTO company
(company_name, costreet, creditlimit) VALUES ("A", 10.10 , 10.10);
select trim(company_name), trim(costreet), creditlimit from company')

Or there is something I don't understand (or some trick with MySQL
stored procedures) ?

Bye

Pier

P.S.: Sorry for my english

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc

2. FREEWAREV30 XLOCKMORE3.10

3. RE MySQL -> Linked Server in MS SQL Server

4. 4-way joystick adaptor

5. MyODBC 3.51.01, OleDB, MS SQL Server And Linked Servers

6. V LOOKUP PROBLEM

7. R: MyODBC 3.51.01, OleDB, MS SQL Server And Linked Servers (Multiple-statements ??)

8. ADO.NET newbie: Binding to comboBox & querying a dataset

9. MyODBC 3.51.01, OleDB, MS SQL Server And Linked Servers

10. MySQL Server as Linked Server to MSSQL Server?

11. ms SQL server 7.0 -- > mysql?

12. MySQL-SQL Server Linked Server Problem

13. MS SQL 2k5 linked server to Postgresql