Hi Thomas, now I sent my other posting right when you posted this message... first thanks for your answer.
> Actually you can use either perl with SAP DB exclusively > (since some driver manager functions are included in > the driver) or you use a driver manager. I tested some > time ago iODBC and recently unixODBC. Yes, so far, until yesterday, we were only using SAPDBs via ODBC, so I used the libsqlod as driver manager as well (I did not know that, but the perl ODBC.so was compiled using libsqlod, because the Makefile.PL found /opt/sapdb/interfaces/odbc/lib/....). > To have access to different DBs over DSNs you have to > compile the perl module agains the driver manager (i.e. > you have to set the odbchome to somewhere the driver > manager resides, cmp README in DBD). Afterwards you have to > define the DSNs. This is what I found after quite some debugging. I then recompiled the DBD-ODBC module by doing a make clean; perl Makefile.PL -o /usr; make all; make install. After this I can perfectly use Mysql-Databases via ODBC - but trying to connect I get the following: DBI->connect(CRUNCHER2) failed: [unixODBC][Driver Manager]Driver does not support this function (SQL-IM001)(DBD: dbd_db_login/SQLSetConnectOption err=-1) at /usr/local/bin/testmysql.pl line 8 , my formerly working SAPDB-DSN is not working anymore. Recompiling with make clean; perl Makefile.PL -o /opt/sapdb/interfaces/odbc; make all; make install. makes my SAPDB-DSN work again, but then Mysql is not working anymore and I get an error from SAP. I have really no idea why this happens... Do you know how I can debug this any further? Greetings from Munich, Torben -- +++ GMX - Mail, Messaging & more http://www.gmx.net +++ NEU: Mit GMX ins Internet. Rund um die Uhr f�r 1 ct/ Min. surfen! _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
