[PHP-DB] Checking for ADO errors

Is there a better way to check for ADO errors than what I have done here using the die()? $dbh = db_open($dbserver, $user, $password, $database) or die ("Cannot open database"); if ($dbh) { $stmnt = "SELECT BadFieldName FROM MC"; $rs = $dbh->Execute($stmnt) or die("Cannot execute

[PHP-DB] ADO leaving "Sleeping connections"

When I run my application under a load test, ~1,800 connections are left in a Sleeping status (using the Stored Procedure, sp_who, reveals this). This causes the application to hang. After leaving the SQL Server rest for several minutes, the connections are restored and the application can run

Re: [PHP-DB] SQL Server COM question

Chris wrote: Todd Cary wrote: [Sorry - I misposted this in the General group] I am in the process of converting my clients PHP scripts that are using Firebird so they will work with SQL Server (their request; not mine). Is there a reference where I can get the COM Methods and Properties

[PHP-DB] SQL Server COM question

[Sorry - I misposted this in the General group] I am in the process of converting my clients PHP scripts that are using Firebird so they will work with SQL Server (their request; not mine). Is there a reference where I can get the COM Methods and Properties? Also, without loading the large A

[PHP-DB] Re: Cannot connect to a MySQL DB using a Class

: Message-ID: <[EMAIL PROTECTED]> To: [email protected] Date: Wed, 04 Jan 2006 16:45:54 -0800 From: Todd Cary <[EMAIL PROTECTED]> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Subject: CAnnot connect to a MySQL DB using a Class

[PHP-DB] Re: CAnnot connect to a MySQL DB using a Class

Todd Cary wrote: No doubt I am over looking something very simple, nevertheless I am baffled by not being able to connect to a MySQL DB. Here is the code that will use the Class: $host='192.168.0.12'; $user='todd'; $password='mypassword'; $databa

[PHP-DB] CAnnot connect to a MySQL DB using a Class

No doubt I am over looking something very simple, nevertheless I am baffled by not being able to connect to a MySQL DB. Here is the code that will use the Class: $host='192.168.0.12'; $user='todd'; $password='mypassword'; $database='calevent'; /* $retval=mys

Re: [PHP-DB] Using PHP to import a DB

ntioned in my previous email. -Original Message----- From: Todd Cary [mailto:[EMAIL PROTECTED] Sent: Sunday, November 06, 2005 8:57 AM To: [email protected] Subject: Re: [PHP-DB] Using PHP to import a DB Robert - I used the backup file on my desktop computer and the browse button. After

Re: [PHP-DB] Using PHP to import a DB

retrieved from http://www.phpmyadmin.net/home_page/ Robbert van Andel -----Original Message- From: Todd Cary [mailto:[EMAIL PROTECTED] Sent: Saturday, November 05, 2005 4:02 PM To: [email protected] Cc: Chris Herron Subject: [PHP-DB] Using PHP to import a DB My client switched from a d

Re: [PHP-DB] Using PHP to import a DB

phpmyadmin. It's a very good database interface and can be retrieved from http://www.phpmyadmin.net/home_page/ Robbert van Andel -----Original Message- From: Todd Cary [mailto:[EMAIL PROTECTED] Sent: Saturday, November 05, 2005 4:02 PM To: [email protected] Cc: Chris Herron Subject

Re: [PHP-DB] Using PHP to import a DB

Micah - With the "-p" switch, the user is asked for the password. How does that happen with the system command? Todd Micah Stevens wrote: system("mysql -u user -p db < /tmp/mydb"); On Saturday 05 November 2005 4:02 pm, Todd Cary wrote: My client switched from

[PHP-DB] Using PHP to import a DB

My client switched from a dedicated server to a shared server, so I cannot use the command line to import a DB that was produced with mysqldump. Can I duplicate "mysql -u user -p db < /tmp/mydb" with php? Any suggestions are greatly appreciated Todd -- PHP Database Mailing List (http://w

[PHP-DB] Connecting to SQL Server

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 $connection_string = 'DRIVER={SQL Server};SERVER=2K-SERVER;DATABASE=Php_

[PHP-DB] Creating an Interbase.so file

I am running Fedora Core 3 and I want to install and integrate Interbase (Firebird 1.5) with php. To create the "so" file, I downloaded php 4.4.0 and did a ./configure --with-interbase=shared,/opt/firebird make Then I place the interbase.so into /usr/lib/php4 and make an interbase.ini in /et

[PHP-DB] Integrating Interbase.so and PHP

I have compiled interbase.so, but even though I have extension=interbase.so in the php.ini file, it is not part of PHP. Has anyone had success doing this? Todd -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Integrating Firebird into PHP

I have compiled interbase.so, but even though I have extension=interbase.so in the php.ini file, it is not part of PHP.  Has anyone had success doing this? Todd -- <>

[PHP-DB] Stopping display of DB errors

When I run a query using Interbase and if an error occurs, the error displays in the browser window even though I am testing for errors. Is there a way to prevent this? function db_insert_logon_session($dbh, $sessionid, $offset) { $fulldate = date("m/d/Y H:i:s",time() + $offset); $stmnt

[PHP-DB] Handling DB query errors

I am not sure about how to properly handle DB Query errors. Here is a typical query where the possible is NOT handled. Any suggestions are welcomed e.g. how to code the query; how to have an error page; how to handle errors produced by the Interbase server. /* Get member data */ function d

[PHP-DB] Installing Firebird 1.5 and PHP

I am running Fedora 3 with Apache and Firebird 1.5.1. Where can I obtain instructions on integrating PHP with Apache/Firebird? Thank you Todd -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Storing data in a file

I have a client that does not want to use a DBMS for storing the email addresses the surfers input. Is there a class available that has a search function as well as an append? I would like to have several "fields" separated by a tab or " : ". Todd -- PHP Database Mailing List (http://www.php.

Re: [PHP-DB] PHP - RH Linux - Interbase

Tyler - <<< Although i would check to see if there are some pre-compiled rpms available that already have interbase support compiled in already. >>> Do you have a suggestion? Todd Tyler Lane wrote: Todd Cary wrote: Glen Webber wrote: Hi Todd,

Re: [PHP-DB] PHP - RH Linux - Interbase

Glen Webber wrote: Hi Todd, I'm running interbase, php,... on deb. Happy to help if I can. Whats the issue your dealing with? G/ Todd Cary wrote: I am looking for someone that is running RH 9 Linux with Php & Interbase... Todd Glenn - I greatly appreciate the offer to help. Linux

[PHP-DB] PHP - RH Linux - Interbase

I am looking for someone that is running RH 9 Linux with Php & Interbase... Todd -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] BBS program

I would like to avoid reinventing the wheel and find an existing BBS program. Do these exist? Thank you -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

[PHP-DB] Where to get MySQL help

I may need to convert an Interbase program to MySQL and I have some questions about MySQL. Todd -- Todd Cary Ariste Software 2200 D Street Extension Petaluma, CA 94952 707-773-4523 [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

[PHP-DB] Installing SQL Server

Has anybody succeeded in running PHP, using ODBC and the MS SQL Server ODBC driver? If so, I can use some guidance. Many thanks Todd -- Todd Cary Ariste Software [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For

Re: [PHP-DB] ODBC and SQL Server

Andrew - Since I installed the OpenLink ODBC, the MS SQL Server Enterprise Manager has just about become useless as well as MS SQL Server itself. It take many minutes to do just about anything - even after I uninstalled OL. Do you have any suggestions? Todd -- Todd Cary Ariste Software

Re: [PHP-DB] ODBC and SQL Server

Andrew - What I am trying to do is to find out if I can use PHP with my client's MS SQL Server DB. Anything that can help me obtain that information would be greatly appreciated. OS: Win 2K (SP 2) DBMS: MS SQl Server 7 Todd -- Todd Cary Ariste Software [EMAIL PROTECTED] -- PHP Dat

Re: [PHP-DB] ODBC and SQL Server

Andrew - Could it be that the string, "Acct32_ODBC\ 0", should be "Acct32_ODBC"? If so, how do I get rid of the terminating "\0" in PHP? Todd -- Todd Cary Ariste Software [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

Re: [PHP-DB] ODBC and SQL Server

0x0226E398 [ 94] "[Microsoft][ODBC SQL Server Driver][SQL Server]" SWORD 511 SWORD * 0x0226E7DE (94) inetinfo49c-7fc ENTER SQLFreeConnect HDBC01811688 inetinfo49c-7fc EXIT SQLFreeConnect with return code 0 (SQ

[PHP-DB] ODBC and SQL Server

for user 'PENTIUM3\IUSR_PENTIUM3'., SQL state 28000 in SQLConnect in C:\Webroot\testodbc.php on line 33 Any suggestions on how I can resolve this? Many thanks. Todd -- Todd Cary Ariste Software [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

Re: [PHP-DB] Linux/PHP/Interbase

answered. Keep in mind I have been using Delphi since version 1, so conceptually I understand what is being performed. Where I feel "lost" is in learning the new nomenclature and tools to do the same job. Most important is my appreciation for the generous help you gave me... Todd --

Re: [PHP-DB] Linux/PHP/Interbase

Steve - I was able to find the leading part of that message on php.net, but I was unable to get the complete text. Did you search "documentation"? Todd -- Todd Cary Ariste Software [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-ma

Re: [PHP-DB] Linux/PHP/Interbase

Steve - I am still trying to find out which RPM I need to install... Many thanks for the help... Todd -- Todd Cary Ariste Software [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail

Re: [PHP-DB] Linux/PHP/Interbase

-module=so); 3. 'apxs' is not in your path. Todd -- Todd Cary Ariste Software [EMAIL PROTECTED] -- PHP Database 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-ma

Re: [PHP-DB] Linux/PHP/Interbase

share with me the steps in compiling programs under Linux? This might force me to brush the dust off of those "C" books on my shelf!! Todd -- Todd Cary Ariste Software [EMAIL PROTECTED] Todd Cary wrote: > I am new to the Linux environment - currently using IIS/PHP/Interbase. >

[PHP-DB] Linux/PHP/Interbase

a interbase.so file on my sytem. Many thanks.. Todd -- Todd Cary Ariste Software [EMAIL PROTECTED] -- PHP Database 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

[PHP-DB] Interbase/Apache/Linux

ironment: Linux!! Is there a version of PHP that has Interbase integrated with Apache for Linux? Or do I or my client have to "roll our own"? Many thanks.. Todd -- Todd Cary Ariste Software [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To un