in reply to install_driver(ODBC) mac mojave 10.14.2
you may need to install the DBD::ODBC module
So, did you install the DBD::ODBC module?
Available drivers: DBM, ExampleP, File, Gofer, Proxy, SQLite, Sponge. at testperldb.pl
At least Perl thinks you didn't install the module.
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re^2: install_driver(ODBC) mac mojave 10.14.2
by raventheone (Novice) on Jan 21, 2019 at 06:55 UTC | |
yes you are absolutely right, the DBD::ODBC module is not installed. If i try to install i get this message: cpan1> install DBD::ODBC Reading '/Users/xxxx/.cpan/Metadata' Database was generated on Mon, 21 Jan 2019 01:54:44 GMT Running install for module 'DBD::ODBC' Running make for M/MJ/MJEVANS/DBD-ODBC-1.60.tar.gz Checksum for /Users/xxxx/.cpan/sources/authors/id/M/MJ/MJEVANS/DBD-ODBC-1.60.tar.gz ok Scanning cache /Users/xxxx/.cpan/build for sizes ............................................................................DONE CPAN.pm: Building M/MJ/MJEVANS/DBD-ODBC-1.60.tar.gz ********** Remember to actually *READ* the README file! And re-read it if you have any problems. ********** OSNAME: darwin LANG: de_CH.UTF-8 ODBCHOME: LD_LIBRARY_PATH: DBROOT: WINDIR: II_SYSTEM: DBD_ODBC_UNICODE: Perl: 5.018002 ExtUtils::MakeMaker: 6.66 Command line options: x! = undef u! = undef o=s = g! = 0 e! = undef w! = undef Your LANG environment variable is set to "de_CH.UTF-8" This is known to cause problems in some perl installations - even stopping this Makefile.PL from running without errors. If you have problems please try re-running with LANG unset or with the utf part of LANG removed. You are using a Perl configured with threading enabled. Please read the warnings in DBI about this. You should also be aware that on non-Windows platforms ODBC drivers come n two forms, thread-safe and non-thread-safe drivers and you may need to make sure you are using the right one. Press return to continue... 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/lib ODBC INC dir set to /usr/local/Cellar/unixodbc/2.3.7/include via odbc_config ODBC LIB dir set to /usr/local/Cellar/unixodbc/2.3.7/lib via odbc_config 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_TYPES_H -DHAVE_LONG_LONG -DSIZEOF_LONG_INT=8 -I/usr/local/Cellar/unixodbc/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 Using DBI 1.631 (for perl 5.018002 on darwin-thread-multi-2level) installed in /System/Library/Perl/Extras/5.18/darwin-thread-multi-2level/auto/DBI/ Using DBI 1.631 (for perl 5.018002 on darwin-thread-multi-2level) installed in /System/Library/Perl/Extras/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. cp Changes blib/lib/DBD/ODBC/Changes.pm cp FAQ blib/lib/DBD/ODBC/FAQ.pm cp TO_DO blib/lib/DBD/ODBC/TO_DO.pm cp ODBC.pm blib/lib/DBD/ODBC.pm cc -c -DHAVE_UNISTD_H -DHAVE_PWD_H -DHAVE_SYS_TYPES_H -DHAVE_LONG_LONG -DSIZEOF_LONG_INT=8 -I/usr/local/Cellar/unixodbc/2.3.7/include -I/usr/local/Cellar/unixodbc/2.3.7/include -I. -I/System/Library/Perl/Extras/5.18/darwin-thread-multi-2level/auto/DBI -g -pipe -fno-common -DPERL_DARWIN -fno-strict-aliasing -fstack-protector -Os -DVERSION=\"1.60\" -DXS_VERSION=\"1.60\" -iwithsysroot "/System/Library/Perl/5.18/darwin-thread-multi-2level/CORE" -DHAVE_UNISTD_H -DHAVE_PWD_H -DHAVE_SYS_TYPES_H -DHAVE_LONG_LONG -DSIZEOF_LONG_INT=8 -I/usr/local/Cellar/unixodbc/2.3.7/include -I/usr/local/Cellar/unixodbc/2.3.7/include ConvertUTF.c make: *** No rule to make target `/System/Library/Perl/Extras/5.18/darwin-thread-multi-2level/auto/DBI/Driver_xst.h', needed by `ODBC.xsi'. Stop. MJEVANS/DBD-ODBC-1.60.tar.gz /usr/bin/make -- NOT OK 'YAML' not installed, will not store persistent state Running make test Can't test without successful make Running make install Make had returned bad status, install seems impossible Failed during this command: MJEVANS/DBD-ODBC-1.60.tar.gz : make NO | [reply] |
by Corion (Patriarch) on Jan 21, 2019 at 08:58 UTC | |
There are three relevant parts of this output:
Have you done that? Twice?
Have you done that? What was the result? The easiest steps to do that configuration are (from the CPAN client):
As the ODBC drivers are supplied by your vendor (Apple), we'll assume that Perl and the ODBC drivers are a matching pair here. | [reply] [d/l] [select] |
by raventheone (Novice) on Jan 21, 2019 at 19:06 UTC | |
how do i properly set the DBI_DSN? | [reply] [d/l] |
by Corion (Patriarch) on Jan 21, 2019 at 19:10 UTC | |
by raventheone (Novice) on Jan 22, 2019 at 07:27 UTC | |
| |