The easiest way to do that is to compile DBD::ODBC to use a driver manager such as unixODBC or iODBC, depending upon your platform, etc. The driver manager, through odbc.ini or other config files, will "talk" directly to the drivers. It soulds like you have built DBD::ODBC to connect directly to a driver.
I presume you are not running under Windows/Win32... I presume you have the correct driver to talk to MS SQL Server from your platform (i.e. www.easysoft.com or www.Openlinksw.com from unix). Jeff > -----Original Message----- > From: drewhead [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 01, 2002 9:24 AM > To: [EMAIL PROTECTED] > Subject: Mutiple ODBC APIs? > > > I have a properiterary ODBC API that I've compiled DBD::ODBC for with > a bit of hair pulling and hand holding from someone who had done it > before. :) Works just fine. Now I find that I have a need to > connect to a MsSql server from the same box... in the same perl > program no less! > > I didn't really think it would, but when trying to connect to the > MsSql server uing the properitary API I get a Protocol error. Can I > compile mutiple APIs into DBD::ODBC (and how)? Can I build and use a > seperate DBD::ODBC module with an MS compatible ODBC API? Am I > barking up the wrong tree and should look at another method? > -- > [EMAIL PROTECTED] > >
