> > Hello dbi-users, > > I want to use the DBD-ODBC module to connect to a W2K hosted > MS SQL db, from a Solaris 8 box. > > But there are three things that I'm either unsure about, or > would like some clarification on ... can you help? > > Question 1) > > "Programming the Perl DBI" states that "For UNIX and > variants, the iODBC driver manager source is included in the > iodbcsrc directory". > > I've looked for this directory in the hierarchy that I've > extracted from the DBD-ODBC module, but it isn't there. I've > also looked for it in the hierarchy that I've extracted from > the DBI module, but it isn't there either. So I've then run a > "find . -name iodbsrc -print" on the solaris box, with a pwd > of /, and this hasn't found it either. > > My question is where is it?
It's no longer there. I believe the DBD::ODBC POD documentation covers that it was removed because it was out of date and there are better ways to get it. (Actually, I use unixODBC now, anyway). > > Question 2) > > I need an ODBC driver. > > I've found an evaluation "single tier driver - sql server > lite" on the openlinksw.com website. > > My question is have I got the right thing for my environment? You can be, but you should ask them :) . I have mostly used 2 tier models and test regularly with www.Easysoft.com ODBC-ODBC bridge product. I believe this is a DBI FAQ (www.xmlproj.com/cgi/fom.cgi) and/or it was mentioned on this list in the last few weeks, so use google to find it (how to connect to sql server from unix/linux). > > Question 3) > > The documentation for the above ODBC driver states that "my > LD_LIBRARY_PATH must point to the location of any shared > libraries required by the Database Vendors communication > layer in order for the ... driver to load". I've looked on > www.microsoft.com, but can't find any information about what (if any) shared libraries > would be required on a Solaris 8 box, in order to access data in a W2K hosted MS SQL > database. > My question is do I need any such libraries, and if so, where do I find them? This is on the Unix side Jeff
