Hi all,

These are my findings on Sybase database support in ActivePerl:
1. You can compile the drivers yourself via codes supplied with the database installation. 2. http://www.peppler.org has two libraries for interfacing with the database
3. Access can be via ODBC

I have tried and failed on (1). I get this error when running nmake:
C:\Perl\lib\CORE\perl.h(380) : fatal error C1083: Cannot open include file: 'sys/types.h': No such file or directory

DBD::Sybase from (2) is a good idea, but requires installation of Open Client. But I cannot afford to package that into my installation. ODBC sounds like the best idea, but I am quite new to Sybase, and it seems that unless the user is also the owner of the table, access is not possible even after granting rights to it.

Performance aside, perhaps ODBC is the best way, though I have not figured the solution to the above-mentioned problem. But I think I may have to try (1) again for a native driver.

If anyone can help me with any of the two problems (how to make DBA the table owner and still let a db user access the table, and how to compile the supplied perl driver)

Thanks in advance.
_______________________________________________
ActivePerl mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

Reply via email to