Hi Jeff, We very much appreciate your prompt reply.
In answer to your questions: 1. DBI v1.30 2. DBD::ODBC v0.43 3. We are using the ODBC driver supplied with the Redbrick Db Client SDK, this includes a test C program which compiles and runs connecting to the Db okay. I've attached this C program to this e-mail to have a look at. Kind Regards, Alex -----Original Message----- From: Jeff Urlwin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 10:25 PM To: Alex Cerantonio; [EMAIL PROTECTED] Cc: Darren Edgerton; [EMAIL PROTECTED] Subject: RE: Problems with using DBD-ODBC > > Hi Tim and Jeff, > > We are having problems with using DBD-ODBC. The ODBC driver is > installed on > our server and can connect to our Redbrick Db, but the DBD-ODBC can not > connect when running the Maketest. > > 1. The log of all step of the built is attached in the zip file. > 2. Perl: v5.6.1 built for aix > Database: Redbrick v6.11 > Server: AIX 4.3.3.0 > > If you require any additional information not in the attached files please > don't hesitate to ask. > > Your assistance with our problem will be greatly appreciated. What version of DBD::ODBC are you using (probably not important yet, but may be)? Are you really using unixODBC as your driver manager? (good, if you are)? Did you test connecting to the database before testing DBD::ODBC? UnixODBC includes odbctest. You should allocate an environment handle then connect. If that works, then DBD::ODBC should work. Regards, Jeff > > Kind Regards, > Alex Cerantonio >
Makefile
Description: Binary data
rb_client.c
Description: Binary data
/*
*
* (C) Copyright IBM Corp. 1998-2001 All rights reserved
*
* The parties acknowledge and agree that the Software is provided AS IS
* and may not be functional on any machine or in any environment.
* Red Brick has no continuing obligation to support or service the Software.
* RED BRICK DISCLAIMS ALL WARRANTIES RELATING TO THE SOFTWARE, EXPRESS OR
* IMPLIED, INCLUDING, BUT NOT LIMITED TO, ANY WARRANTIES OF
* NON-INFRINGEMENT, MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE.
*/
# README file for Sample ODBC program for Red Brick SDK
The sample ODBC example program contains following files:
1. rb_client.c (C program for the example)
This sample ODBC client program asks the user for DSN (Data Source Name)
connect information and a SQL statement.
It then submits the SQL to the server and
returns the results to the client.
DSN is defined in $HOME/.odbc.ini file
2. Makefile
This is makefile for compiling the above example on
various UNIX platforms.
Please set following installation specific defines
in the makefile, marked by 1,2,3 in the makefile.
1. RB_PLATFORM
Please set RB_PLATFORM to one of the following operating systems:
solaris (For Sun OS 5.x)
hpux (For HP-UX 10.10)
hpux64 (For HP-UX 11, 64 bit format)
decunix (For DEC OSF 4.x and 3.2)
aix3 (For AIX 3.2.x)
aix4 (For AIX 4.x)
aix64 (For AIX 4.x, 64 bit format)
irix6 (For SGI IRIX 6.x, 64 bit format)
irix6_32 (For SGI IRIX 6.x, 32 bit format)
irix6_old32 (For SGI IRIX 6.x, old 32 bit format)
ptx (For Sequent DYNIX 4.x)
ncr (For NCR )
unisys (For Unisys)
2. RB_ODBC
ALWAYS set this to 1, when using this Red Brick ODBCLib SDK.
3. RB_INSTALL_DIR
Please set this to installation dir of Red Brick release.
Notes:
The example has been tested on the above flavors of operating systems. UNIX operating
system versions, is a constantly moving target. If user has a different version of
operating system and wants to make changes in the makefile, the operating system
specific changes are localized in two macros in the makefile:
- GETCC (This macro gets the compiler name, location)
- GETOSLIBS (This macro gets system libs)
