Some questions:
[1] What version of unixODBC are you using?
[2] Can you run unixODBC's isql and attach to your data source?
use isql -v data_source_name
[3] have you got any core files in the dir where you are running make test for
DBD::ODBC?
[4] you can edit your odbcinst.ini file (where you tell unixODBC about your
driver) and add:
[5] Did you use the same compiler/linker to build Perl and unixODBC? What about
the RedBrick driver? (probably OK since the C code you attached worked).
[ODBC]
Trace = Yes
TraceFile = /tmp/sql.log
Now when you run isql or make test you should get tracing in /tmp/sql.log.
What does it contain?
Martin
On 18-Sep-2002 Alex Cerantonio wrote:
> 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
>>
--
Martin J. Evans
Easysoft Ltd, UK
Development
