you have to define a DNS on your system. i assume that you know what DNS is
and how to create on windows. if not, say it!
afterwards check, if the odbc has been activated in your php.ini on
the rest is easy:
the code looks like that:
if( !$con=odbc_connect($dns,$user,$pwd) ) exit; // establish
connection, if faild exit
$qry = "SELECT * FROM $table"; // generate
execute query and get result
$fieldscnt = odbc_num_fields($res); // count
while( $n = odbc_fetch_into($res,&$arr) ) // loop as
long as it has records and fetch data into array
for( $i=0; $i<$fieldscnt; $i++) //
loop all fields
// display value in array on current field-element $i
if($res) odbc_free_result($res); // free
memory of result if there's a result
if($con) odbc_close($con); // free
connection if there's an established connection
as you can see, only a few lines...
"Gabor Niederlaender" <[EMAIL PROTECTED]> schrieb im
Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi all!
> I realized, that it is impossible to retrieve "ntext" from an MSSQL DB
> with php normally. (Is this correct?)
> But I think it should be possible to make it through ODBC.
> Can someone explain me how this goes? (I think I have set up one ODBC
> Data Source, but I am not sure) But I cannot even imagine how I use
> this stuff for establishing a connection...
> Does it really only go this way?
> Best regards,
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php