MS_SQL Connectivity

[Bill Campbell]

On Fri, May 18, 2007, Shawn Tayler wrote:
>On Thu, 17 May 2007 21:15:08 -0700 Bill Campbell <linux-sxs at celestial.com>
>exclaimed:
>> 
>> You don't need to know much about java to use most jdbc drivers
>> (and they're probably the best to use with OpenPKG given its Sun
>> and Java heritage).  Mostly it depends on what's going to be
>> using the interface.
>> 
>> Bill
>
>Well, my intention is to either run a query every 24 hours that pulls the
>past days data from probably one or 2 tables on each server.  this data is
>dup checked, cleaned up, and inserted into a set of tables in the Postgre
>box. The other option is to have the tables in question, which are present
>in the remote MS-SQL boxes, appear as tables in the PostgreSQL server.
>Either would be helpful to my purpose.

About six months ago I did some testing, connecting to a M$-SQL
server using python, postgresel and sqlobject, an object mapping
package for python that treats database tables as python classes.

All I did at the time was enough to establish that (a) it would
connect to the M$-SQL system, and (b) I could retrieve data.

Bill
--
INTERNET:   bill at Celestial.COM  Bill Campbell; Celestial Software LLC
URL: http://www.celestial.com/  PO Box 820; 6641 E. Mercer Way
FAX:            (206) 232-9186  Mercer Island, WA 98040-0820; (206) 236-1676

``It will be of little avail to the people that the laws are made by men of
their own choice if the laws be so voluminous that they cannot be read, or
so incoherent that they cannot be understood.''
    -James Madison, Federalist Paper #62