Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

comment on

( #3333=superdoc: print w/replies, xml ) Need Help??
cpan[3]> install DBD::ODBC DBD::ODBC is up to date (1.60). cpan[1]> look DBD::ODBC Reading '/Users/raventheone/.cpan/Metadata' Database was generated on Mon, 21 Jan 2019 01:54:44 GMT Running look for module 'DBD::ODBC' Trying to open a subshell in the build directory... Checksum for /Users/raventheone/.cpan/sources/authors/id/M/MJ/MJEVANS/ +DBD-ODBC-1.60.tar.gz ok Scanning cache /Users/raventheone/.cpan/build for sizes ...................................................................... +......DONE Working directory is /Users/raventheone/.cpan/build/DBD-ODBC-1.60-8omQ +Ke sh-3.2# perl Makefile.PL Looking for odbc_config in : nowhere Looking for odbc_config in (PATH) /Library/Frameworks/Python.framework +/Versions/3.7/bin:/usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin Found odbc_config (via odbc_config) version 2.3.7 odbc_config reports --prefix=/usr/local/Cellar/unixodbc/2.3.7 odbc_config reports --include-prefix=/usr/local/Cellar/unixodbc/2.3. +7/include odbc_config reports --lib-prefix=/usr/local/Cellar/unixodbc/2.3.7/li +b ODBC INC dir set to /usr/local/Cellar/unixodbc/2.3.7/include via odb +c_config ODBC LIB dir set to /usr/local/Cellar/unixodbc/2.3.7/lib via odbc_co +nfig Using ODBCHOME /usr/local/Cellar/unixodbc/2.3.7 This looks like a unixodbc type of driver manager. Looking for odbcinst Found odbcinst in /usr/local/Cellar/unixodbc/2.3.7/bin odbcinst -j reports: unixODBC 2.3.7 DRIVERS............: /usr/local/etc/odbcinst.ini SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini FILE DATA SOURCES..: /usr/local/etc/ODBCDataSources USER DATA SOURCES..: /var/root/.odbc.ini SQLULEN Size.......: 8 SQLLEN Size........: 8 SQLSETPOSIROW Size.: 8 Please note these files as they are where you define your ODBC drivers + and data sources. Looking for odbc_config to get cflags Adding odbc_config --cflags "-DHAVE_UNISTD_H -DHAVE_PWD_H -DHAVE_SYS_T +YPES_H -DHAVE_LONG_LONG -DSIZEOF_LONG_INT=8 -I/usr/local/Cellar/unixo +dbc/2.3.7/include " to CC line Warning: LD_LIBRARY_PATH= doesn't include /usr/local/Cellar/unixodbc/2 +.3.7/lib Checking if your kit is complete... Looks good Multiple copies of Driver.xst found in: /Library/Perl/5.18/darwin-thre +ad-multi-2level/auto/DBI/ /System/Library/Perl/Extras/5.18/darwin-thr +ead-multi-2level/auto/DBI/ at Makefile.PL line 151. Using DBI 1.642 (for perl 5.018002 on darwin-thread-multi-2level) inst +alled in /Library/Perl/5.18/darwin-thread-multi-2level/auto/DBI/ Multiple copies of Driver.xst found in: /Library/Perl/5.18/darwin-thre +ad-multi-2level/auto/DBI/ /System/Library/Perl/Extras/5.18/darwin-thr +ead-multi-2level/auto/DBI/ at Makefile.PL line 1136. Using DBI 1.642 (for perl 5.018002 on darwin-thread-multi-2level) inst +alled in /Library/Perl/5.18/darwin-thread-multi-2level/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. sh-3.2# make test PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_h +arness(0, 'blib/lib', 'blib/arch')" t/*.t t/01base.t ................... ok t/02simple.t ................. skipped: DBI_DSN is undefined t/03dbatt.t .................. skipped: DBI_DSN is undefined t/05meth.t ................... skipped: DBI_DSN is undefined t/07bind.t ................... skipped: DBI_DSN is undefined t/08bind2.t .................. skipped: DBI_DSN is undefined t/09multi.t .................. skipped: DBI_DSN is undefined t/10handler.t ................ skipped: DBI_DSN is undefined t/12blob.t ................... skipped: DBI_DSN is undefined t/20SqlServer.t .............. skipped: DBI_DSN is undefined t/30Oracle.t ................. skipped: DBI_DSN is undefined t/40UnicodeRoundTrip.t ....... skipped: DBI_DSN is undefined t/41Unicode.t ................ skipped: DBI_DSN is undefined t/45_unicode_varchar.t ....... skipped: DBI_DSN is undefined t/50_odbc_utf8_on.t .......... skipped: DBI_DSN is undefined t/70execute_array_dbi.t ...... skipped: DBI_DSN is undefined t/70execute_array_native.t ... skipped: DBI_DSN is undefined t/80_odbc_diags.t ............ skipped: DBI_DSN is undefined t/82_table_info.t ............ skipped: DBI_DSN is undefined t/87_odbc_lob_read.t ......... skipped: DBI_DSN is undefined t/90_trace_flags.t ........... skipped: DBI_DSN is undefined t/odbc_describe_parameter.t .. skipped: DBI_DSN is undefined t/pod-coverage.t ............. 1/1 # Test::Pod::Coverage 1.04 required + for testing POD coverage t/pod-coverage.t ............. ok t/pod.t ...................... ok t/rt_101579.t ................ skipped: DBI_DSN is undefined t/rt_38977.t ................. skipped: DBI_DSN is undefined t/rt_39841.t ................. skipped: DBI_DSN is undefined t/rt_39897.t ................. skipped: DBI_DSN is undefined t/rt_43384.t ................. skipped: DBI_DSN is undefined t/rt_46597.t ................. skipped: DBI_DSN is undefined t/rt_50852.t ................. skipped: DBI_DSN is undefined t/rt_57957.t ................. skipped: DBI_DSN is undefined t/rt_59621.t ................. skipped: DBI_DSN is undefined t/rt_61370.t ................. skipped: DBI_DSN is undefined t/rt_62033.t ................. skipped: DBI_DSN is undefined t/rt_63550.t ................. skipped: DBI_DSN is undefined t/rt_78838.t ................. skipped: DBI_DSN is undefined t/rt_79190.t ................. skipped: DBI_DSN is undefined t/rt_79397.t ................. skipped: DBI_DSN is undefined t/rt_81911.t ................. skipped: DBI_DSN is undefined t/rt_null_nvarchar.t ......... skipped: DBI_DSN is undefined t/sql_type_cast.t ............ skipped: DBI_DSN is undefined All tests successful. Files=42, Tests=11, 1 wallclock secs ( 0.09 usr 0.07 sys + 0.97 cus +r 0.21 csys = 1.34 CPU) Result: PASS

how do i properly set the DBI_DSN?


In reply to Re^4: install_driver(ODBC) mac mojave 10.14.2 by raventheone
in thread install_driver(ODBC) mac mojave 10.14.2 by raventheone

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post; it's "PerlMonks-approved HTML":



  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.
  • Log In?
    Username:
    Password:

    What's my password?
    Create A New User
    Chatterbox?
    and the web crawler heard nothing...

    How do I use this? | Other CB clients
    Other Users?
    Others examining the Monastery: (6)
    As of 2019-12-11 20:41 GMT
    Sections?
    Information?
    Find Nodes?
    Leftovers?
      Voting Booth?

      No recent polls found

      Notices?