MS Office comes with an ODBC driver, which may be able to connect to MSSQL 2000. If it can, using it may not be trivial--you might have to use some of the Mac API stuff. You could ask Microsoft for any documentation on the driver and how or whether you can use it.
Keary Suska Esoteritech, Inc. "Leveraging Open Source for a better Internet" > From: [EMAIL PROTECTED] > Date: Sun, 11 Nov 2001 19:45:42 -0500 > To: [EMAIL PROTECTED] > Subject: [MacPerl] MS 2000 SQL > > Dear group, > > I would like to use MacPerl to connect to the company's Microsoft 2000 SQL > server. > > I'm using OS 9.1 and would like to use our LAN to connect to the server. > The server is probably running on a Compaq machine. > > I have figured how get MacPerl to extract caption information from JPEG > photo files. I would like to continue to use MacPerl to place caption info > into the MS SQL server. This would help me build a database of captions > to search years down the road. > > Anyone have any suggestions to pull this off? > > Thank you. > > -- cloth > > > >