SQLXML way: SQLXML (currently at version 3.0) allows you to set up IIS Virtual Directories that act as 'gateways' to a SQL Server 2000 database using a given login and password. You can then send queries to the database in various formats and SQL Server will return the results in XML.
http://yourMSSQLhost/SQLXMLdir?SQL=SELECT+*+FROM+[mytablename]+FOR+XML+AUTO&root=root On Fri, 2 Aug 2002 10:32:44 -0400 , [EMAIL PROTECTED] (Bob Showalter) wrote: >> -----Original Message----- >> From: learn perl [mailto:[EMAIL PROTECTED]] >> Sent: Thursday, August 01, 2002 5:33 PM >> To: [EMAIL PROTECTED] >> Subject: How to create DBI connection on unix to MS SQL server ? >> >> >> Hi guys, >> >> just wondering how to establish a DBI connection from a unix >> machine to a >> WINNT machine running MS SQL server? do I have to specify an OBDC? > >Hard way: find ODBC client software for your UNIX box and use DBD::ODBC. > >Easy way: install Perl and DBI/DBD::ODBC on the NT box and use DBD::Proxy on >the UNIX box. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
