RE: Microsoft SQL Server linking to MySQL

2001-02-20 Thread Aaron Weiker
w.cisp.cc Cell: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

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

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,