Torben Frey wrote:
Well, I'm the first user who needed to use SAP DB from Perl and took the time to make it possible.Hi Flemming,Heh, I wrote those lines of code:-)Thanks for the fast reply! So I already met the SAPDB-ODBC expert?
I know it's sort of giving up, but you could use DBD::MySQL in stead of DBD::ODBC to access your MySQL instance in stead and then you can continue using a SAP DB specific DBD::ODBC, this is in fact exactly what I do:)
I've never used a driver manager to access SAP DB, but as others have said, it should work and it does work.
it should be a problem with the perl DBD::ODBC module.
What version of DBD::ODBC are you using (sorry if you already said)
DBD::ODBC calls SQLSetConnectionOption twice:What does this SQLSetConnectionOption do?
First to turn on Autocommit (as pr. the DBI spec):
rc = SQLSetConnectOption(imp_dbh->hdbc,
SQL_AUTOCOMMIT, SQL_AUTOCOMMIT_ON);
Then to turn it off when the users wants it off (doesn't he always?):
rc = SQLSetConnectOption(imp_dbh->hdbc, pars->fOption, vParam);
unixodbc may call that routine to do other things as well, but it
certainly exists in the driver or it wouldn't work when DBD::ODBC is compiled directly against it.
--
Regards Flemming Frandsen - http://dion.swamp.dk
PartyTicket.Net co founder & Yet Another Perl Hacker
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
