Firstly, I already compiled with odbc support, as I said it in my mail, I
can retrieve the data but I can't retrieve column SQL Data Type, I have a
case opened with openlink and the last thing they said was:
>Daniel,
>
>I tested this using the SQL Server native driver, and the results are the
same as with ours: >the SQLColAttributes() ODBC call returns a <unmodified>
value for >SQL_COLUMN_TYPE. I do not know why this is the case; it would
need to be investigated >with Microsoft. The SQLDescribeCol() API call is
much more robust, and will return the >information you require. However, I
don't know if the PHP development community is >willing to invest in this
change.
>Best regards,
>Stephen - Online Support Team
I'm curious, why you decided to close the case without testing?, or if you
tested the script I sent why you don't mentioned, I don't follow your QA.
Thanks anyway
Daniel H. Ardison
Systems Development Manager
Ardison Software & Consulting
----- Original Message -----
From: "Bug Database" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Viernes 4 de Mayo de 2001 4:15 PM
Subject: Bug #10369 Updated: Openlink4/ODBC odbc_field_type returns nothing
> ID: 10369
> Updated by: ahill
> Reported By: [EMAIL PROTECTED]
> Old-Status: Open
> Status: Closed
> Bug Type: ODBC related
> PHP Version: 4.0.4pl1
> Assigned To:
> Comments:
>
> Firstly, please use --with-iodbc instead of --with-iodbc.
> Also, this is most likely not a PHP issue but a database specific issue,
and will only occur in cases where the corresponding database CLI call
doesn't work natively.
>
> Please test this with the latest OpenLink drivers and open a support case
at http://www.openlinksw.com/support/suppindx.htm if the problem persists.
>
>
>
> Previous Comments:
> --------------------------------------------------------------------------
-
>
> [2001-04-17 20:12:15] [EMAIL PROTECTED]
> This script reproduces the problem:
>
> <HTML>
> <HEAD>
> <TITLE>Test odbc_field_type</TITLE>
> </HEAD>
> <BODY bgcolor="#000000" text="#CCCCCC" link="#33CCFF" vlink="#996699"
alink="#FF
> FFFF" marginwidth="0" marginheight="0" topmargin="0" leftmargin="0">
> <?php
>
>
> putenv("LD_LIBRARY_PATH=/usr/local/openlink/odbcsdk/lib");
> putenv("LIBPATH=/usr/local/openlink/odbcsdk/lib:$LIBPATH");
> putenv("SHLIB_PATH=/usr/local/openlink/odbcsdk/lib:$SHLIB_PATH");
> putenv("UDBCINI=/usr/local/openlink/bin/odbc.ini");
> putenv("ODBCINSTINI=/usr/local/openlink/bin/odbcinst.ini");
> putenv("ODBCINI=/usr/local/openlink/bin/odbc.ini");
> $dsn="DSN=Arbant";
> $user="dba";
> $password="sql";
> $sql='Select cod_emp, cod_amb, den from loguec';
> if(($conn_id=odbc_connect("$dsn","",""))){
> if(($result=odbc_prepare($conn_id,$sql))){
> @odbc_execute($result);
> if(!empty($result)){
> $cols_count=odbc_num_fields($result);
> $ind=1;
> while($ind<=$cols_count){
> $cols_name[$ind]=odbc_field_name($result,$ind);
> $cols_types[$ind]=odbc_field_type($result,$ind);
> $ind++;
> }
> echo "<H1>Results</H1>";
> echo "<B>The Query is: $sql<B>n";
> echo '<TABLE align="center" border="1" bordercolor="green"
cellpadding="
> 2" cellspacing="0">';
> $ind=1;
> echo "<tr><td><b>Names</b></td><td><b>Types</b></td></tr>";
> while($ind<=$cols_count){
> echo "<tr>";
> echo "<td>" . $cols_name[$ind] . "</td>n";
> echo "<td>" . $cols_types[$ind] . "</td>n";
> echo "</tr>";
> $ind++;
> }
> odbc_free_result($result);
> }else{
> echo "Cannot execute query";
> }
> }else{
> echo "Cannot prepare query";
> }
> }
> ?>
> </BODY></HTML>
>
> I compiled PHP standard, I simply run ./configure with openlink option ,
run make and make install.
> I can retrieve column name information and also data but I can't retrieve
the column SQL Type. I asked Openlink and they said that is a PHP issue.
>
> I'm using Openlink Multi-tier Driver for accessing a MS SQL Server 7
Database on a Windows NT box from PHP scripts running on the Apache Web
Server on a Linux Box
> OpenLink Version 4
> PHP Version 4.0.4pl1
> Linix SuSE 6.1 Kernel Version 2.2.7
> Apache Version 1.3
> PHP is running as a Loadable Apache Module
>
>
> --------------------------------------------------------------------------
-
>
>
>
> ATTENTION! Do NOT reply to this email!
> To reply, use the web interface found at
http://bugs.php.net/?id=10369&edit=2
>
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
