Ok I found the URL: http://tlowery.hypermart.net/perl_dbi_dbd_faq.html#HowDoIAccessMSWindowsDB
However, the second step is "On the Windows system install DBI, all the modules for DBD::Proxy, and DBD::ODBC. " Wheh I use ppm on my windows machine and search for "DBD::Proxy" or even "Proxy" it cannot seem to find anything? Did you encounter this too? Thanks! > -----Original Message----- > From: Tim Howell [mailto:[EMAIL PROTECTED] > Sent: Monday, February 24, 2003 12:35 PM > To: [EMAIL PROTECTED] > Subject: RE: connecting perl to MS SQL on Linux > > > Rusty-- > > In addition to the DBD driver (in this case, DBD::ODBC), you need a > database specific ODBC driver for MS SQL. AFAIK, there are no freely > available MS SQL ODBC drivers for linux. > > I've had a similar problem recently in trying to connect to SQL Server > from a RedHat box. The solution I've gone with is DBD::Proxy with > DBD::ODBC on the Windows machine to allow the linux box to connect. > There's a page somewhere with instructions on doing just this; > unfortunately, I don't have the URL. > > FWIW, in order to make this setup work reliably, I had to patch > Net::Daemon and PlRPC on the Windows machine with a patch supplied > [EMAIL PROTECTED] > > Let me know if you have any questions. =) > > --TWH > > -----Original Message----- > From: Russell Kroboth [mailto:[EMAIL PROTECTED] > Sent: Monday, February 24, 2003 9:27 AM > To: [EMAIL PROTECTED] > Subject: connecting perl to MS SQL on Linux > > > I have a number of perl scripts used under Windows that I am trying to > port to a Redhat 8 Linux machine. All my scripts use DBI.pm and > DBD::ODBC to connect to an MS SQL Server database. > > I have seen this question several times here, and found several FAQs > that all say that I need to simply install a driver manager > and a driver > on my Linux machine. So I thought I would install unixODBC as > the driver > manager, and then DBD:ODBC as my driver. I downloaded and installed > unixODBC-2.2.2-3.i386.rpm. However, during the next step - > installation > of DBD:ODBC - I get the following error: > > Using DBI 1.32 installed in > /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto > /DBI > > The DBD::ODBC module needs to link with an ODBC 'Driver Manager'. (The > Driver Manager, in turn, needs one or more database specific ODBC > drivers. The DBD::ODBC module does _not_ include any ODBC drivers!) > > You need to indicate where your ODBC Driver Manager is installed. You > can do this ether by setting the ODBCHOME environment variable or by > runing 'perl Makefile.PL -o odbcdir'. > > If you do not have an ODBC Driver Manager you can try > building the free > iODBC Driver Manager in the iodbcsrc directory. > > Makefile.PL aborted. > > > > According to the FAQ's I can find, and the unixODBC manual, > this should > not occur since I have installed the driver manager. Am I missing > something? Or doing this wrong? > > > Thanks! > Rusty > >
