July 15, 2002 at 2:09 pm
I'm getting some requests from our developers here to isql or bcp to SQL Server from UNIX... We were able to do this with SQL Server 7.0 and 6.5, but not 2000. We were actually using Sybase's interfaces file and command utilities to connect to SQL Server 6.5 and 7.0 from UNIX... This doesn't work with 2000. I know that the way we were doing it wasn't really supported, but how else can we do this? Or I should say, is there a supported, proper way? 3rd party tools?
Thanks!
John Aspenleiter
John Aspenleiter
July 15, 2002 at 9:00 pm
It is more common to set up a view on Sybase and use a linked server from SQL Server to connect to Sybase and import the data. Or you can use DTS in SQL Server to connect and pull the data. If the information can be expressed without user interference the you can add to that to do either in a job that can be scheduled for specific times allow more automation of it.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply