> > > Firstly, I want to apologise for disturbing you, but I am > unsure how to proceed with this.
No problem. > Basically, I used a PC for quitre a few years, regularly > running perl scripts to take Lotus Notes data into an Access > database, and then produce various reports from various > access databases. Late last year, I changed to a new PC, > running Windows NT4 Service Pack 6A, with Microsofot Visual > Studio 6 SP4, MSDE (aka SQL server) with a mixture of Office > 97 and Office 2000. I installed ActiveState Perl, and used > ppm to install DBI and DBD-ODBC Visual C++ SP4 is a part of your problem. It looks as if when you are building DBD::ODBC yourself, rather than using PPM you will have problems (unless that's a typo and it's really SP3). VC SP4 changed the C++ object model which causes HUGE problem inside ActiveState Perl's. It's tough, but you can you can find references on their mailing list search pages. I *knew* what I was looking for a while back because I remembered reading it, but it took me a while to find it searching for it. So -- trust me or hunt for it, but SP4 is incompatible with the ActiveState builds of Perl 5.6x. Jan Dubios at ActiveState can probably comment. Try the PPD files on my ftp site and ensure they get built and installed. I don't have the direct URL in front of me, so please reference the DBI FAQ (www.xmlproj.com/cgi/fom.cgi) to find "private repositories" > I now get out of memory errors after a period of time when > executing queries with anything other than very simple > syntax. I used ppm to remove DBD-ODBC and downloaded the > DBD-ODBC from CPAN and used nmake then nmake test on the same > database. However, my test script fails to find the built > code, maybe something else needs to be done for ActiveState perl? > > The guys at ActiveState said they could not help, and > suggested I contact the authors, hence this email. Would you > please suggest a way forward. This is the best place to get support -- I'm going to snip it off a bit and ask some questions. It looks as if you are using Access in the tests below, but MSDE on the run? (Just verifying). Is there a way you can send me the database (or a subset) and I can load it here to try to diagnose? I haven't used MSDE, so I don't know if it's easy to import/export data. How much data is in the table? Can you run the same query from MS Query (ODBC client program)? I don't see anything obvious, but I'd like to do more.. .if I can get the database and/or the smallest reproducable case... > [big snip] > t\09multi...........skipped: multiple statements not > supported using ACCESS > t\20SqlServer.......skipped: Microsoft SQL Server tests not > supported using ACCE SS > t\30Oracle..........skipped: Oracle tests not supported using > ACCESS All tests successful, 4 tests and 1 subtest skipped. > Files=9, Tests=56, 2 wallclock secs ( 0.00 cusr + 0.00 csys > = 0.00 CPU) > > E:\Perl\site\lib\DBD-ODBC-1.03> I'm surprised the build even goes this far with SP4... Did you do nmake install after the test? [snip] Regards, Jeff
