Re: [GENERAL] Integration with MS Sql Server

2005-10-04 Thread Sean Davis
On 10/3/05 7:41 PM, "J B" <[EMAIL PROTECTED]> wrote: > On 10/3/05, Dann Corbit <[EMAIL PROTECTED]> wrote: >> Using SQL*Server, and OLEDB or ODBC data source can be connected as a >> linked server. Then, TSQL queries can go against PostgreSQL tables as >> though they were ordinary SQL*Server table

Re: [GENERAL] Integration with MS Sql Server

2005-10-03 Thread J B
On 10/3/05, Dann Corbit <[EMAIL PROTECTED]> wrote: > Using SQL*Server, and OLEDB or ODBC data source can be connected as a > linked server. Then, TSQL queries can go against PostgreSQL tables as > though they were ordinary SQL*Server tables (but they have 4 part names > instead of 3 part names).

Re: [GENERAL] Integration with MS Sql Server

2005-10-03 Thread Dann Corbit
TECTED] [mailto:pgsql-general- > [EMAIL PROTECTED] On Behalf Of J B > Sent: Monday, October 03, 2005 10:56 AM > To: pgsql-general@postgresql.org > Subject: [GENERAL] Integration with MS Sql Server > > Guys, > > We have an in-house application that absolutely has to run against

[GENERAL] Integration with MS Sql Server

2005-10-03 Thread J B
Guys, We have an in-house application that absolutely has to run against MS Sql Server. We also have an application that doesn't, but that needs to integrate with that MSSQL database. I'm considering any options, including using application code as an integration point. I'd prefer to somehow mir