php-windows Digest 19 Sep 2005 13:43:36 -0000 Issue 2779
Topics (messages 26357 through 26358):
Re: FrontPage or something else?
26357 by: JC Botha
Re: Calling MSSQL Stored Procedure
26358 by: Robert Twitty
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[email protected]
----------------------------------------------------------------------
--- Begin Message ---
Hi there, Yes, I personally would shun FP. What you could do is to design
all your page in it and then dump your PHP into it. But on the other had it
is not advisable.
What I do with my designs is having a single index.php file and I push all
my data, forms, text, db quarries etc into that single page that the user
quarries.
I use and only use Zend Studio. It is made for PHP and I will not be able to
do with out it. An alternative to consider is PHP Designer
http://www.mpsoftware.dk/phpdesigner.php
At the end of the day it will have to be hard coding on both sides (HTML and
PHP) to get exactly what you want. There is not really another way to go
about things.
All the best, keep us posted as to what you decided on.
--- End Message ---
--- Begin Message ---
Since you are using php_mssql.dll, you should use php_odbtp.dll instead of
php_odbtp_mssql.dll to prevent namespace conflicts. The ADODb driver name
is 'odbtp', and the database connection should be performed similar to the
following:
$db = NewADOConnection('odbtp');
// Connect to database via ODBTP server
$odbtp_server = '127.0.0.1';
$odbc_conn = 'DRIVER={SQL Server};SERVER=mysqlserver;'
. 'UID=myuid;PWD=mypwd;DATABASE=mydb; ';
if( !$db->PConnect( $odbtp_server, $odbc_conn ) ) {
print $DB->ErrorMsg();
die;
}
On Sun, 18 Sep 2005, Alf Stockton wrote:
> Robert Twitty wrote:
>
> >Hi Alf
> >
> >The ODBTP client works on all platforms. It includes a Win32 PHP
> >extension (php_odbtp.dll). If you install it, you may find that it
> >will produce better reslts than the packaged mssql extesnion under
> >Windows. The reason is because the PHP win32 mssql extension was built
> >with DB-Library, which Microsoft stop supporting after SQL Server 6.5.
> >
> >
> I am attempting the above and I copied the php_odbtp_mssql.dll into
> c:\php\ext and altered the php.ini but now I need to know what do I set
> the $driver= in my php script to. It is currently set to $driver=mssql
> and I cannot find an ODBTP alternative & when I restart Apache, Apache
> keeps telling me it cannot find php_odbtp_mssql.dll. Even when I restart
> the server.
>
>
> --
>
> Regards,
> Alf Stockton www.stockton.co.za
>
> I must have a prodigious quantity of mind; it takes me as much as a
> week sometimes to make it up.
> -- Mark Twain, "The Innocents Abroad"
>
> My email disclaimer is available at www.stockton.co.za/disclaimer.html
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--- End Message ---
