[PHP-DB] Re: oci_bind_by_name, 'Unknown or unsupported datatype given'

2005-08-10 Thread Anton Channing
Okay, its seems my problem is actually more fundamental. I've just tried to run the example from the oci_bind_by_name documentation on php.net, and get the same error! The example doesn't work for me. I think at this point I need to assume there is something wrong with the server settings?

Re: [PHP-DB] Re: oci_bind_by_name, 'Unknown or unsupported datatype given'

2005-08-10 Thread Miles Thompson
Anton, This seems so fundamental I hesitate to suggest it. Have you run a script with phpinfo() in it? Or apache or httpd with the -l, -V or -t switches? Miles At 06:59 AM 8/10/2005, Anton Channing wrote: Okay, its seems my problem is actually more fundamental. I've just tried to run the

Re: [PHP-DB] Re: oci_bind_by_name, 'Unknown or unsupported datatype given'

2005-08-10 Thread Miles Thompson
At 11:32 AM 8/10/2005, Anton Channing wrote: On 8/10/05, Miles Thompson [EMAIL PROTECTED] wrote: Anton, This seems so fundamental I hesitate to suggest it. Have you run a script with phpinfo() in it? Or apache or httpd with the -l, -V or -t switches? Miles Okay, have just run phpinfo,

[PHP-DB] Connecting to SQL Server

2005-08-10 Thread Todd Cary
I have been asked by my client to use SQL Server for my php application (uh!). The name of the server is 2k-server, but I am not sure where to create the ODBC connection. Some of the docs state that all I need is ?php $connection_string = 'DRIVER={SQL

Re: [PHP-DB] Connecting to SQL Server

2005-08-10 Thread Frank M. Kromann
Hi Todd, PHP has native support for MSSQL Server. On a *nix platform you need to install and configure FreeTDS and recompile php using --with-mssql, but then you will be able to use the mssql_* functions. - Frank I have been asked by my client to use SQL Server for my php application

Re: [PHP-DB] Connecting to SQL Server

2005-08-10 Thread tg-php
If I remember right, PHP's built-in database functions don't allow for a DSNLess connection. Meaning you have to set up an ODBC source on the machine PHP is running on (or do a remote ODBC connection) and connect to a DSN (a named datasource manually set up). BUT.. if you know the address of

[PHP-DB] SELECT Performance and INDEXing

2005-08-10 Thread Dwight Altman
I have a MyISAM table holding images with field types bigint(20), mediumblob, varchar(255), blob and tinyint(3). The table has grown to over 800 MB and over 6,000 rows. In the past week, performance has been about 15-20 seconds to run the following select statement which pulls only 16 maximum

Re: [PHP-DB] SELECT Performance and INDEXing

2005-08-10 Thread Dwight Altman
I meant 'Analyze table' and 'the composite key field2 field3 would be unique' - Original Message - From: Dwight Altman [EMAIL PROTECTED] To: php-db@lists.php.net Sent: Wednesday, August 10, 2005 4:23 PM Subject: [PHP-DB] SELECT Performance and INDEXing I have a MyISAM table holding