RE: connecting SQL server on W and PHP/MYSQL on Unix

Hi Lalit,
 
I really don't know the answer here, I had to set this up as I needed to
report (using Crystal 8.5) on stuff from both MySQL and SQL Server so the
data was really being pulled from My SQL into views on SQL Server. The post
I made in February was the first time I had needed to do anything like this
and the first time I really had anything to do with MySQL so I guess I'm the
wrong person to be asking
 
 
Sorry....not much help I know
 
 
Hope you find the answers you are after, someone out there must know
 
 
cheers
 
Mike
-----Original Message-----
From: lalit jairath [mailto:lkjairath@xxxxxxxxx]
Sent: Thursday, 11 March 2004 10:01
To: Mike Harknett; myodbc@xxxxxxxxxxxxxxx
Cc: grant.reid@xxxxxxxxxxxxxx
Subject: RE: connecting SQL server on W and PHP/MYSQL on Unix


Hi Mike,
 
So is it possible to communicate both ways- accessing MSSQL from MySQL (unix
machine) as well as MySQL from MSSQL. I'm more interested in accessing MSSQL
server from MySQL.
 
Could you  please point me to a detailed doc/code. I'm not very familiar
with MSSQL (un)fortunately.
 
Thank you much.
 
Lalit
 
 
Hi Lalit
Have a look at the thread starting with the post I made on 25th Feb 
with
subject of  "MySQL -> Linked Server in MS SQL Server" I don't know if 
it
will do what you want but it may be of some help

Cheers

Mike

-----Original Message-----
From: lalit jairath [mailto: lkjairath@xxxxxxxxx
<http://us.f101.mail.yahoo.com/ym/Compose?To=lkjairath@xxxxxxxxx&YY=19041&or
der=down&sort=date&pos=0> ]
Sent: Thursday, 11 March 2004 3:41
To: myodbc@xxxxxxxxxxxxxxx
<http://us.f101.mail.yahoo.com/ym/Compose?To=myodbc@xxxxxxxxxxxxxxx&YY=19041
&order=down&sort=date&pos=0> 
Cc: grant.reid@xxxxxxxxxxxxxx
<http://us.f101.mail.yahoo.com/ym/Compose?To=grant.reid@xxxxxxxxxxxxxx&YY=19
041&order=down&sort=date&pos=0> 
Subject: RE: connecting SQL server on W and PHP/MYSQL on Unix


Is your MYSQL on unix machine? so, how do you do it? Thx. lkj



  _____  

Do you Yahoo!?
Yahoo! Search - Find what you're looking for
<http://search.yahoo.com/?fr=ad-mailsig-home> faster.

-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@xxxxxxxxxxx