I'm trying to use easyoft's ODBC bridge to talk between my SBS Server and a
linux box that will be eventually serving web data.
Currently, running easysoft's demo and identifying new datasource not in
odbc.ini works fine, so I know this is a configuration issue. Does anything
jump out?
Thanks,
Shawn
Demo which is located in the default dir /usr/local/easysoft/oob/examples
outputs the following (OOB Demo DSN is an Access db set up as a System DSN
on SBS server):
[1] Read the initial notice.
[2] Requirements for the demo.
[3] Display ./odbc.ini
[4] Test Connection to demo.easysoft.com.
[5] Get Easysoft contact information from remote database.
[6] Test connection to all DSNs in your odbc.ini
[7] Test connection to new datasource not in odbc.ini
[8] Exit.
Choose an option: 7
This option will allow you to connect to any ODBC driver on a remote
machine where the OOB Server is running even if you do not have a DSN
in your odbc.ini (i.e. a DSN-less connection).
You do not need a DSN defined in an odbc.ini file to connect to a remote
data source as all the attributes defining a connection may be passed
to the ODBC function SQLDriverConnect().
This option will prompt you for the attributes, compile a connection
string and attempt to connect. Defaults are displayed in [] and may
be used by pressing <enter>.
Press enter to continue
Driver (ODBC driver) [OOB] :
Server (IP address or FQDN) where OOB Server installed [demo] : 192.69.1.1
Port (the OOB Server usually listens on port 8888) [8888] :
Transport (OOB currently only supports TCP/IP [TCP/IP] :
TargetDSN (the name of the SYSTEM DSN on the remote machine [pubs] : OOB
Demo DSN
LogonUser (valid username for remote machine) [demo] : username
LogonAuth (password for LogonUser) [easysoft] : userpass
TargetUser (database username - may not be required) [demo] :
TargetAuth (password for TargetUser) [easysoft] :
Additional attributes of the form attribute=value, each attribute/value
pair separated by a semicolon. e.g. ENG=engine;DBN=database; [] :
Using connection string:
Driver=OOB;Server=192.69.1.1;Port=8888;Transport=TCP/IP;TargetDSN=OOB Demo
DSN;Log
onUser=username;LogonAuth=userpass;TargetUser=demo;TargetAuth=easysoft;
Passing connection string to SQLDriverConnect to attempt a connection...
Connection OK
Connected to database: F:\mariboss
DBMS Name: ACCESS
Driver Name: esoobclient
Driver Version: 01.00.0025
[root@srv DBD-ODBC-0.28]# perl -v
This is perl, v5.6.0 built for i386-linux
Copyright 1987-2000, Larry Wall
Perl may be copied only under the terms of either the Artistic License or
the
GNU General Public License, which may be found in the Perl 5.0 source kit.
So...then I did a:
perl Makefile.PL in /DBD-ODBC-0.28 which returned...
Unrecognized escape \i passed through at Makefile.PL line 217.
Using ODBC in /usr/local/easysoft/oob
Umm, this looks like a udbc type of driver manager.
Configuring DBD::ODBC ...
>>> Remember to actually *READ* the README file!
And re-read it if you have any problems.
Using DBI 1.15 installed in
/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI
Note (probably harmless): No library found for -ludbc
Using DBI 1.15 installed in
/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI
Writing Makefile for DBD::ODBC
The DBD::ODBC tests will use these values for the database connection:
DBI_DSN=dbi:ODBC:OOB Demo DSN e.g. dbi:ODBC:demo
DBI_USER=username
DBI_PASS=userpass
so then I did a make, which returned:
cc -c -I. -I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI
-I/usr/local/easys\
oft/oob/include -fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64 -\
O3 -fomit-frame-pointer -pipe -s -march=pentium -ffast-math
-fexpensive-optimizat\
ions -DVERSION=\"0.28\" -DXS_VERSION=\"0.28\" -fpic
-I/usr/lib/perl5/5.6.0/i3\
86-linux/CORE ODBC.c
In file included from ODBC.h:9,
from ODBC.xs:1:
dbdodbc.h:6: libudbc.h: No such file or directory
In file included from ODBC.h:15,
from ODBC.xs:1:
dbdimp.h:19: parse error before `HENV'
dbdimp.h:19: warning: no semicolon at end of struct or union
dbdimp.h:21: parse error before `}'
dbdimp.h:28: parse error before `HENV'
dbdimp.h:28: warning: no semicolon at end of struct or union
dbdimp.h:29: warning: data definition has no type or storage class
dbdimp.h:37: parse error before `HENV'
dbdimp.h:37: warning: no semicolon at end of struct or union
dbdimp.h:38: warning: data definition has no type or storage class
dbdimp.h:39: parse error before `hstmt'
dbdimp.h:39: warning: data definition has no type or storage class
dbdimp.h:50: parse error before `*'
dbdimp.h:50: warning: data definition has no type or storage class
dbdimp.h:53: parse error before `*'
dbdimp.h:53: warning: data definition has no type or storage class
dbdimp.h:56: parse error before `RowCount'
dbdimp.h:56: warning: data definition has no type or storage class
dbdimp.h:60: parse error before `}'
dbdimp.h:67: parse error before `UCHAR'
dbdimp.h:67: warning: no semicolon at end of struct or union
dbdimp.h:68: warning: data definition has no type or storage class
dbdimp.h:69: parse error before `ColDef'
dbdimp.h:69: warning: data definition has no type or storage class
dbdimp.h:70: parse error before `ColScale'
dbdimp.h:70: warning: data definition has no type or storage class
dbdimp.h:71: parse error before `ColSqlType'
dbdimp.h:71: warning: data definition has no type or storage class
dbdimp.h:72: parse error before `ColNullable'
dbdimp.h:72: warning: data definition has no type or storage class
dbdimp.h:73: parse error before `ColLength'
dbdimp.h:73: warning: data definition has no type or storage class
dbdimp.h:74: parse error before `ColDisplaySize'
dbdimp.h:74: warning: data definition has no type or storage class
dbdimp.h:77: parse error before `ftype'
dbdimp.h:77: warning: data definition has no type or storage class
dbdimp.h:80: parse error before `*'
dbdimp.h:80: warning: data definition has no type or storage class
dbdimp.h:81: parse error before `datalen'
dbdimp.h:81: warning: data definition has no type or storage class
dbdimp.h:98: parse error before `SWORD'
dbdimp.h:98: warning: no semicolon at end of struct or union
dbdimp.h:99: warning: data definition has no type or storage class
dbdimp.h:100: parse error before `cbValue'
dbdimp.h:100: warning: data definition has no type or storage class
dbdimp.h:103: parse error before `}'
ODBC.xsi: In function `XS_DBD__ODBC__db_commit':
ODBC.xsi:73: dereferencing pointer to incomplete type
ODBC.xsi: In function `XS_DBD__ODBC__db_rollback':
ODBC.xsi:82: dereferencing pointer to incomplete type
ODBC.xsi: In function `XS_DBD__ODBC__db_disconnect':
ODBC.xsi:91: dereferencing pointer to incomplete type
ODBC.xsi:95: dereferencing pointer to incomplete type
ODBC.xsi:96: dereferencing pointer to incomplete type
ODBC.xsi:97: dereferencing pointer to incomplete type
ODBC.xsi:101: dereferencing pointer to incomplete type
ODBC.xsi:101: dereferencing pointer to incomplete type
ODBC.xsi:103: dereferencing pointer to incomplete type
ODBC.xsi:105: dereferencing pointer to incomplete type
ODBC.xsi:109: dereferencing pointer to incomplete type
ODBC.xsi:109: dereferencing pointer to incomplete type
ODBC.xsi:109: dereferencing pointer to incomplete type
ODBC.xsi: In function `XS_DBD__ODBC__db_DESTROY':
ODBC.xsi:144: dereferencing pointer to incomplete type
ODBC.xsi:146: dereferencing pointer to incomplete type
ODBC.xsi:153: dereferencing pointer to incomplete type
ODBC.xsi:154: dereferencing pointer to incomplete type
ODBC.xsi:155: dereferencing pointer to incomplete type
ODBC.xsi:157: dereferencing pointer to incomplete type
ODBC.xsi:158: dereferencing pointer to incomplete type
ODBC.xsi:158: dereferencing pointer to incomplete type
ODBC.xsi:158: dereferencing pointer to incomplete type
ODBC.xsi:160: dereferencing pointer to incomplete type
ODBC.xsi:168: dereferencing pointer to incomplete type
ODBC.xsi:169: dereferencing pointer to incomplete type
ODBC.xsi:174: dereferencing pointer to incomplete type
ODBC.xsi:174: dereferencing pointer to incomplete type
ODBC.xsi:174: dereferencing pointer to incomplete type
ODBC.xsi: In function `XS_DBD__ODBC__st_execute':
ODBC.xsi:288: dereferencing pointer to incomplete type
ODBC.xsi:289: dereferencing pointer to incomplete type
ODBC.xsi:292: dereferencing pointer to incomplete type
ODBC.xsi:306: dereferencing pointer to incomplete type
ODBC.xsi:307: dereferencing pointer to incomplete type
ODBC.xsi: In function `XS_DBD__ODBC__st_finish':
ODBC.xsi:355: dereferencing pointer to incomplete type
ODBC.xsi:356: dereferencing pointer to incomplete type
ODBC.xsi:360: dereferencing pointer to incomplete type
ODBC.xsi:363: dereferencing pointer to incomplete type
ODBC.xsi:363: dereferencing pointer to incomplete type
ODBC.xsi:363: dereferencing pointer to incomplete type
ODBC.xsi: In function `XS_DBD__ODBC__st_DESTROY':
ODBC.xsi:430: dereferencing pointer to incomplete type
ODBC.xsi:432: dereferencing pointer to incomplete type
ODBC.xsi:438: dereferencing pointer to incomplete type
ODBC.xsi:439: dereferencing pointer to incomplete type
ODBC.xsi:439: dereferencing pointer to incomplete type
ODBC.xsi:439: dereferencing pointer to incomplete type
ODBC.xsi:441: dereferencing pointer to incomplete type
ODBC.xsi:442: dereferencing pointer to incomplete type
ODBC.xsi:443: dereferencing pointer to incomplete type
ODBC.xsi:451: dereferencing pointer to incomplete type
ODBC.xsi:451: dereferencing pointer to incomplete type
ODBC.xsi:451: dereferencing pointer to incomplete type
ODBC.xs: In function `XS_DBD__ODBC__st_DescribeCol':
ODBC.xs:42: `SQL_MAX_COLUMN_NAME_LEN' undeclared (first use in this
function)
ODBC.xs:42: (Each undeclared identifier is reported only once
ODBC.xs:42: for each function it appears in.)
ODBC.xs: In function `XS_DBD__ODBC__db_GetFunctions':
ODBC.xs:146: `UWORD' undeclared (first use in this function)
ODBC.xs:146: parse error before `pfExists'
ODBC.xs:147: `RETCODE' undeclared (first use in this function)
ODBC.xs:150: `rc' undeclared (first use in this function)
ODBC.xs:150: dereferencing pointer to incomplete type
ODBC.xs:150: `pfExists' undeclared (first use in this function)
ODBC.xs: In function `XS_DBD__ODBC__dr_data_sources':
ODBC.xs:179: `UWORD' undeclared (first use in this function)
ODBC.xs:179: parse error before `fDirection'
ODBC.xs:180: `RETCODE' undeclared (first use in this function)
ODBC.xs:181: `UCHAR' undeclared (first use in this function)
ODBC.xs:182: `SWORD' undeclared (first use in this function)
ODBC.xs:186: `HENV' undeclared (first use in this function)
ODBC.xs:186: parse error before `henv'
ODBC.xs:188: dereferencing pointer to incomplete type
ODBC.xs:189: `rc' undeclared (first use in this function)
ODBC.xs:189: dereferencing pointer to incomplete type
ODBC.xs:191: dereferencing pointer to incomplete type
ODBC.xs:191: `SQL_NULL_HENV' undeclared (first use in this function)
ODBC.xs:196: `dsn' undeclared (first use in this function)
ODBC.xs:198: dereferencing pointer to incomplete type
ODBC.xs:198: `fDirection' undeclared (first use in this function)
ODBC.xs:200: `dsn_length' undeclared (first use in this function)
ODBC.xs:201: `description' undeclared (first use in this function)
ODBC.xs:202: `description_length' undeclared (first use in this function)
ODBC.xs:209: dereferencing pointer to incomplete type
ODBC.xs:211: dereferencing pointer to incomplete type
ODBC.xs:216: `SQL_FETCH_NEXT' undeclared (first use in this function)
ODBC.xs:218: dereferencing pointer to incomplete type
ODBC.xs:219: dereferencing pointer to incomplete type
ODBC.xs:220: dereferencing pointer to incomplete type
ODBC.xsi: In function `boot_DBD__ODBC':
ODBC.xsi:17: sizeof applied to an incomplete type
ODBC.xsi:18: sizeof applied to an incomplete type
ODBC.xsi:19: sizeof applied to an incomplete type
make: *** [ODBC.o] Error 1
Shawn Pursley
MIS Director
Eagle Transport Services
800 820 8883
Visit us on the web at www.eagletransportservices.com!
