Very Computer

by **Mitchell, Freddi** » Sat, 30 Aug 2003 04:04:10

Hello:

I have loaded your MyODBC ODBC driver. I have had success in:

1) Connecting to MySQL databases through ACCESS linking
2) Using a DSNless string in ASP pages to display MySQL database data
3) Creating a DSN in the ODBC manager and getting a 'successful' =
connection message using the 'Test' button

What I need, though, is to configure a "Linked Server" in MS SQL Server =
via the Enterprise Manager to link to MySQL databases. I have gotten to =
the point where I can see a list of the tables in my database by using =
the string I used for the DSNless ASP pages in the "Provider String" =
field. I can also use some of the "sp" procedures to see the mete-data" =
of the remote MySQL database. But I can not query the MySQL databases =
using the Linked server. I keep getting error "7313.". I want to do =
some joins to use data in MySQL to update some SQL Server tables.

Where can I get some help with this.

Thanks,

Freddie Mitchell, Jr.
Software Engineer
Northeast (New York) OSS
Desk: 914-421-2775
Mobile: 914-447-6256
Prvt.: 172*62*6256

For Northeast OSS Support

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

by **jbonn..** » Sat, 30 Aug 2003 07:49:16

I would be looking at what error 7313 means exactly to see if I could
resolve it.

If this is a one off transfer of data and tables are not too big, doing a
mysqldump of the data and using some or all of that to build temporary
tables in SQL Server may be a reasonable way to get things done.

John Bonnett

-----Original Message-----

Sent: Friday, 29 August 2003 4:13 AM

Subject: MySQL-SQL Server Linked Server Problem

Hello:

I have loaded your MyODBC ODBC driver. I have had success in:

1) Connecting to MySQL databases through ACCESS linking
2) Using a DSNless string in ASP pages to display MySQL database data
3) Creating a DSN in the ODBC manager and getting a 'successful' connection
message using the 'Test' button

What I need, though, is to configure a "Linked Server" in MS SQL Server via
the Enterprise Manager to link to MySQL databases. I have gotten to the
point where I can see a list of the tables in my database by using the
string I used for the DSNless ASP pages in the "Provider String" field. I
can also use some of the "sp" procedures to see the mete-data" of the remote
MySQL database. But I can not query the MySQL databases using the Linked
server. I keep getting error "7313.". I want to do some joins to use data
in MySQL to update some SQL Server tables.

Where can I get some help with this.

Thanks,

Freddie Mitchell, Jr.
Software Engineer
Northeast (New York) OSS
Desk: 914-421-2775
Mobile: 914-447-6256
Prvt.: 172*62*6256

For Northeast OSS Support

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