http://www.perlmonks.org?node_id=1083354


in reply to Re^3: Strawberry Perl 64bit on Win7 crashes on DBI-function
in thread Strawberry Perl 64bit on Win7 crashes on DBI-function

I didn't write the data_sources method but I look after DBD::ODBC these days. I don't see a 64bit issue and inspecting the code I cannot see any issue although there are things I might have done differently.

I still suspect it is something to do with the large number of DSNs you have. If you download DBD::ODBC and build it yourself I can suggest a few small changes that might help identify the issue.

Download the latest DBD::ODBC, and untar it into a dir. Open a strawberry perl shell session and change to the dir above. Edit the file ODBC.xs and delete the function data_sources and replace it with the one below:

void data_sources(drh, attr = NULL) SV* drh; SV* attr; PROTOTYPE: $;$ PPCODE: { #ifdef DBD_ODBC_NO_DATASOURCES /* D_imp_drh(drh); imp_drh->henv = SQL_NULL_HENV; dbd_error(drh, (RETCODE) SQL_ERROR, "data_sources: SOLID d +oesn't implement SQLDataSources()");*/ XSRETURN(0); #else int numDataSources = 0; SQLUSMALLINT fDirection = SQL_FETCH_FIRST; RETCODE rc; SQLCHAR dsn[SQL_MAX_DSN_LENGTH+1+9 /* strlen("DBI:ODBC:") */]; SQLSMALLINT dsn_length; SQLCHAR description[256]; SQLSMALLINT description_length; D_imp_drh(drh); if (!imp_drh->connects) { rc = SQLAllocEnv(&imp_drh->henv); if (!SQL_ok(rc)) { imp_drh->henv = SQL_NULL_HENV; dbd_error(drh, rc, "data_sources/SQLAllocEnv"); XSRETURN(0); } } strcpy(dsn, "dbi:ODBC:"); while (1) { description[0] = '\0'; rc = SQLDataSources(imp_drh->henv, fDirection, dsn+9, /* strlen("dbi:ODBC:") */ SQL_MAX_DSN_LENGTH, &dsn_length, description, sizeof(description), &description_length); if (!SQL_ok(rc)) { if (rc != SQL_NO_DATA_FOUND) { /* * Temporarily increment imp_drh->connects, so * that dbd_error uses our henv. */ imp_drh->connects++; dbd_error(drh, rc, "data_sources/SQLDataSources"); imp_drh->connects--; } break; } printf("/%s/ (%d), /%s/ (%d)\n", (dsn + 9), dsn_length, description, description_length); ST(numDataSources++) = newSVpv(dsn, dsn_length+9 /* strlen("db +i:ODBC:") */ ); fDirection = SQL_FETCH_NEXT; } if (!imp_drh->connects) { SQLFreeEnv(imp_drh->henv); imp_drh->henv = SQL_NULL_HENV; } XSRETURN(numDataSources); /* return indicating # + items on stack */ #endif /* no data sources */ }

Now type perl Makefile.PL, then dmake and it should build you a DBD::ODBC. Now run something like the following:

perl -Ic:\path_to_dbd_odbc_dir\blib\lib -Ic:\path_to_dbd_odbc_dir\blib +\arch -le "use DBI; my @a = DBI->data_sources('ODBC');"

Replace c:\path_to_dbd_odbc_dir as per your machine and where you unpacked DBD::ODBC. It should output a list of your dsns and lengths - what was the output and did it crash? If it does not crash, take the printf line out (all from printf to the semi colon), rebuild and try again? Does it work now?

Replies are listed 'Best First'.
Re^5: Strawberry Perl 64bit on Win7 crashes on DBI-function
by theman824 (Novice) on Apr 23, 2014 at 14:14 UTC

    Thank you a lot.

    I am not used to compiling packages, since i am used to use ActiveState Perl for Windows and am used to get ready to use ppm-packages, so please forgive me.

    I did as described, but on doing the "perl Makefile.PL" it is telling me:

    Press return to continue... Using DBI 1.631 (for perl 5.018001 on MSWin32-x64-multi-thread) instal +led in C:/strawberry/perl/site/lib/auto/DBI/ Strawberry Perl found; adjusting the INC variable; Using DBI 1.631 (for perl 5.018001 on MSWin32-x64-multi-thread) instal +led in C:/strawberry/perl/site/lib/auto/DBI/ INC is now INC = -IC:\strawberry\perl\site\lib\auto\DBI -IC:\strawber +ry\perl\site\lib\auto\DBI Using DBI 1.631 (for perl 5.018001 on MSWin32-x64-multi-thread) instal +led in C:/strawberry/perl/site/lib/auto/DBI/ Writing Makefile for DBD::ODBC Writing MYMETA.yml and MYMETA.json Warning: not all required environment variables are set. Warning: Will not be able to run tests as you have not defined all of DBI_DSN, DBI_USER and DBI_PASS environment variables.

    What values should i set here (and what are they for)? It also gave me Warning (mostly harmless): No library found for ODBC32.LIB.

      Ignore the first warning - you don't need to run any tests so you don't need to set those env vars. I'm not sure about the second one but just do dmake and see where that gets you.

        Ok.

        This actually crashes as well. The output was:
        /dBASE Files/ (11), /Microsoft Access dBASE Driver (*.dbf, *.ndx, *.md +x)/ (51) /Excel Files/ (11), /Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *. +xlsb)/ (54) /MS Access Database/ (18), /Microsoft Access Driver (*.mdb, *.accdb)/ +(40) /Test_Workstation_AIX/ (20), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /PETER/ (5), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /WINTEL/ (6), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /WRCEZUMI/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /PROD50/ (6), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /ZUMWINT/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /AMKAS4I/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /AMKASDB/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /AMKASSYS/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /ZUMPD/ (5), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /LEIMIS/ (6), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /LEIMISP/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /ZUMD/ (4), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /ZUMQD/ (5), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT203DWK/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT200DWK/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF200DWK/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP200DWK/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF203DWK/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP203DWK/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DBE/ (3), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DBP/ (3), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DTE0/ (4), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /BBH9/ (4), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT233MV/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT233MV1/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /D211PSY/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT233DWK/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF233DWK/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF233MV/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DXD0/ (4), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DXA0/ (4), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP233MV/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT270DWK/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF233MV1/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /BBH1/ (4), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /BBH4/ (4), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /BBHA/ (4), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /BBHB/ (4), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DB2T/ (4), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DB2S/ (4), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /BBH0/ (4), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /BBHC/ (4), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DB2P/ (4), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DB2D/ (4), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT11CLQE/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP270DWK/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP11CLQE/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /ZUMPA/ (5), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF270DWK/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP233DWK/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP203CAP/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DXV0/ (4), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP211DWS/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT233PTS/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT233PTG/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT233PTU/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /D211BN/ (6), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DXG0/ (4), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP233PTG/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP233PTS/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP233PTU/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /D233PTG/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /D233PTS/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /D233PTU/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF211TD/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP11PSY/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DTBREPR/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DPBREPR/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT203ZAN/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF203ZAN/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP203ZAN/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /D203ZAN/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT203DLK/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /TKOL/ (4), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF203DLK/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /QKOL/ (4), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /AUTOTEST/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /TSTHEXSR/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /TOSCAM/ (6), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /PROTST/ (6), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /D201CMLS/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /D233CMLS/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /BBHX/ (4), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DB2M/ (4), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /TOSCAF/ (6), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP203DLK/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /PKOL/ (4), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /MOGTEST2/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /TIPWDB/ (6), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /PIPWDB/ (6), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP205WPS/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /TOSCAT/ (6), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /SEA/ (3), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /HEXSR/ (5), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /K_IPS_DB/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /AMKPCTAR/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /AMK0707E/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /AMK0701E/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /AMK0607G/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /AMK0607E/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /AMK0601P/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /AMK0601E/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /S657A2CE/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /P3DGRU/ (6), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /GRUUNF/ (6), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /MOGULVNR/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /MOGUL_DM/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /D205CMLS/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT233ST/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /INVTEST/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /FAUSTDB/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT11RTIM/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /SVSPROD1/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /PROVDS65/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /TECOSOFT/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /INVPLAN/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /TOSCAB/ (6), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /TOSCAC/ (6), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DEGDDPA0/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DEGDDPG0/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DEGDDPV0/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DEGDDPD0/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /D243CMLS/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /D203CMLS/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /D299CMLS/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /D211TCMD/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /D211DS1/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT203ZAB/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF203ZAB/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DB2W/ (4), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /D211DS5/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /D211DS4/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT299KPK/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF299KPK/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP299KPK/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP203ZAB/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF205WPS/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT11TCMD/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /HEXSRTST/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT2MISB1/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF2MISB1/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP2MISB1/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT211DWS/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP233ST/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF211DWS/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF33UST/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT11RVX/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DPB1IRS/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF11RVX/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /AMFDBKLN/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT211BSV/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF211BSV/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP211BSV/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /WPS03BPC/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /WFS03CEI/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /WFS03CS6/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /WFS03SIB/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /WFS03BPC/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /WP403BPC/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /WP403CS6/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /WP403SIB/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /WP403CEI/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /ECOSOFT/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /D211DWS/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP33UST/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF33USTI/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF33USTS/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /XMETA/ (5), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DBIMSC/ (6), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT203GOZ/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DE11OVP/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT11OVP/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF11OVP/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT211TD/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF11AMVS/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP11AMVS/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT233SPK/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF233SPK/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP233SPK/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP211DIV/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP211OVP/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP11OVP/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP211PST/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT268OCA/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF203GOZ/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF03GOZA/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /D299MGMT/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT204SII/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DBIMST/ (6), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF204SII/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /FGENBAV/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /PGENBAV/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF268OCA/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DV268OCA/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DBGEN01/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DCTMDB/ (6), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DCTMIGDB/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /QGENBAV/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DB2WN/ (5), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DB2DN/ (5), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP11REPR/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP11REPB/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT2MISB2/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF2MISB2/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP2MISB2/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DSD0/ (4), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT11REPR/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT203OST/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT211C10/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /C10TAUDI/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DE211CGX/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF211C10/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /C10FAUDI/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DV211CGX/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP211C10/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /C10PAUDI/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /test/ (4), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT203VGV/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT233VGV/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT270VGV/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF203VGV/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF233VGV/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF270VGV/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP203VGV/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP233VGV/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP270VGV/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DEGADTV0/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DEGADTD0/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /test2/ (5), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP203GOZ/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP03GOZA/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF267SC/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP267SC/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DM233UST/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT267SC/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP268OCA/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT33USTP/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF33USTP/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT33UST/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT233UST/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT11AMVS/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DR11AMVS/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF299DFL/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF299DAC/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF203OST/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP01COMP/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP01CADM/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT01COMP/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF01COMP/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF01CADM/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DV01COMP/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /PGINABAV/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /MOGTESTP/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DBT70MGP/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /AMLDISP1/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP27GDL/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /bernd2/ (6), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP299DFL/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT204DWH/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF204DWH/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP204DWH/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DBF70MGP/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /MOGFACHP/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT11GESB/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DR11GESB/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT234AVO/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF11GESB/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DM11GESB/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF234AVO/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF243AVO/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF243AVB/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP243AVO/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF203BPA/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF203BPE/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF203BS/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF203BPM/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF203CEI/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF203CMN/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF203ME/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF203PDW/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP204SII/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT7GBRDL/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT70MG01/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF70MG01/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP11AIW/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP99DOCB/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP211AIW/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /D211TD/ (6), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT11ZUM/ (7), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT11GEGT/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DR11GEGT/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF11GEGT/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP11GEGT/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DP70MG01/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT33ZL/ (6), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DF04SIIB/ (8), /IBM DB2 ODBC DRIVER - DB2RTCL9N/ (31) /DT70PDF/ (7), /IBM DB2 ODBC DR
        And there it crashed.

        Is there a way to verify if the altered and newly created ODBC was actually used?

        Update: I take back the last sentence. Obviously the altered data_sources-function created the output... sorry for that.