A quick look at the source shows lots of references to the DBD::ODBC namespace so you will need to search and replace within the ODBC.pm file, looking for the string DBD::ODBC. I suppose you should also change the Name attribute for the driver handle (line 42 of $DBD::ODBC::VERSION = '0.28').
I don't know if any of the xs stuff needs fixing too. I guess Jeff Urlwin is your best guide for this. If you were on Win32 you could have used DBD::ADO as an alternative to DBD::ODBC. In your situation you could build DBD::Sybase against the FreeTDS libraries and communicate with the MS-SQL server that way. -- Simon Oliver drewhead wrote: > > Yes Oliver, this is my understanding of the issue. As long as we're > talking specfics, this is a ODBC API for RedBrick, an IBM product > formerly Informix (no DBD-Infomix isn't for the DBMS). I actually > did try iODBC first, but was unsuccessful. Upon asking on the > RedBrick list I was contacted by a helpful user who showed me how it > could be done linking some of the libs (that have an extra 'rb' in > their name). Alas, I've now coded myself into a corner needing > access to other drivers that this 'interface' can't handle. > > If the solution here is to compile what I currently have working with > RB to a diffrent name, perhaps RBODBC, I'll certianly give that a > shot. I don't think I've ever changed a module's name. Is there > anything to be aware of besides wholesale %s/ODBC/RBODBC/g? > -- > Drew > > > Jeff, perhaps I have misunderstood what is going on here but it is > my > > impression that DBD-ODBC is being built against propriety > interfaces that look > > like an ODBC API library but in fact will only communicate with a > specific > > DBMS. One such example is SAP-DB. > > > > If this propriety build of DBD-ODBC will only work with a propriety > DBMS it is > > my opinion that it should not be called DBD-ODBC, instead the > module should be > > renamed to reflect its specific purpose, in order to properly > describe the > > DBD's function and allow the loading of the real DBD-ODBC at the > same time. > > > > -- > > Simon Oliver > > > > > > Jeff Urlwin wrote: > > > > > > Simon, > > > > > > You should be able to build DBD::ODBC against a driver manager > such as > > > unixODBC or iODBC (the assumed way to do it from my perspective, > in fact). > > > The driver manager will then talk to SAP DB, etc. > > > > > > Jeff > > >