RE: Microsoft SQL Server linking to MySQL

2001-02-20 Thread Aaron Weiker
:419.304.0323 web search: http://www.allthesites.com -Original Message- From: Ed Carp [mailto:[EMAIL PROTECTED]] Sent: Monday, February 19, 2001 8:56 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Microsoft SQL Server linking to MySQL I'm trying

Re: Microsoft SQL Server linking to MySQL

2001-02-19 Thread Rolf Hopkins
I never tried but I would have thought you would type a normal table name in your SELECT statement. It looks like your writing SQL statements meant for MS SQL and not mysql. - Original Message - From: "Aaron Weiker" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 20,

Re: Microsoft SQL Server linking to MySQL

2001-02-19 Thread Ed Carp
I'm trying to set up a link to MySQL through Microsoft SQL. I set up a ODBC DSN using MyODBC and I told Microsoft SQL to link through an ODBC Datasource. Everything seems to work except I can't query anything. This is a statement I try. SELECT * FROM [MySQL].mysql.db This is