I'm new to PHP and having issues. We have seperate servers for them. We
can use ODBC to test the connection and it works fine. However, when we try
to run the site we get a message of *** Error: Unable to Connect to
Database. Please Try Again Later. ***
We are using a custom app that we
I originally posted this to the general discussion but wanted to see if
anyone on this list had an idea. The issue is trying to connect to the
MSSQL with PHP from a linux box (Fedora Core 4 in this instance)
An interesting development. I found some reference to running my PHP
script from the
Run it from the command line as the apache user. See if that makes a
difference. I'd guess not though.
Apache's php module doesn't really put any restrictions that I know of on the
scripting.. that's a strange effect..
On Wednesday 02 November 2005 10:54 am, [EMAIL PROTECTED] wrote:
I
I have the freetds installed and am able to communicate with MSSQL, but
only when i run the script from the command line. When I run it from a
webbrowser, it fails.
Robbert
Joseph Crawford [EMAIL PROTECTED] wrote on 11/02/2005, 08:00:43 PM:
I attempted this a while back for a client who used
I ran it as the apache user and it worked fine (from the command line).
I do notice that when I run a system command using the exec or system
functions, I get nothing back on some of the commands (primarily
traceroute and ping). Others do work (whoami)
Robbert
Micah Stevens [EMAIL
System commands are supposed to output errors on STERR, not on STOUT, php's
system commands only grab STOUT so if there's an error you'll get no output..
You need to redirect STERR to STOUT when you issue the command..
Just put this at the end of your command:
21
Don't know if that's the
hi,
I have been learning PHP and MySQL from a book that I have bought. I am
really pleased with the way these 2 systems work, but I was wondering if
MSSQL wouldn't be easier to use, more specifically I was wondering wether I
could make an Access Database and connect it to my php website using
:[EMAIL PROTECTED]
Sent: Wednesday, December 31, 2003 4:08 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] PHP and MSSQL
hi,
I have been learning PHP and MySQL from a book that I have bought. I am
really pleased with the way these 2 systems work, but I was wondering if
MSSQL wouldn't be easier to use
Hi Alan,
If this is a problem with PHP it's in the Sybase extension. I hvae not
tried working with that since I made it possible to use --with-mssql (and
I'm not the maintainer).
Can you compile the cli version (--disable-cgi
--with-mssql=path/to/freetds ...) and test a small comanndline script
Hello,
Because I am not sure if this is just a PHP issue or a
PHP+DB issue, I will be posting this message
(seperately) to bith the General and PHP-DB lists.
First, a brief rundown of my setup:
Mandrake Linux 9.0
Apache 1.3.27
PHP 4.3.0
We are in the process of rebuilding our outdated
servers,
Hi Alan,
I'm not sure what 'Control Panel PHP script' means ?
What version of FreeTDS are you using ?
Do you use the sybase or the mssql extension in PHP ?
- Frank
Hello,
Because I am not sure if this is just a PHP issue or a
PHP+DB issue, I will be posting this message
(seperately) to
Hi Frank,
--- Frank M. Kromann [EMAIL PROTECTED] wrote:
I'm not sure what 'Control Panel PHP script' means ?
I meant the PHP page itself that is the Control Panel
(i.e., 's_controlpanel.php')
What version of FreeTDS are you using ?
0.60 on the new server; I am not sure about the
currently
Hi Alan,
Did you configure FreeTDS with the right tdsver ? This can be none when
compiling FreetTDS using --with-tdsver=7.0 or in freetds.conf.
You should use the correct version according to your MSSQL server (70. =
SQL Server 7, 80 = SQL Server 2000).
From PHP 4.3.0 you can compile php using
Hi Frank,
--- Frank M. Kromann [EMAIL PROTECTED] wrote:
This should be ok. --with-tdsver=4.2 sets the
default.
I figured as much, since I think the default can be
overridden in the 'freetds.conf' and/or $TDSVER
environment variable, no?
Have you tried the tsql tool to see if you can
connect
hello,
I am trying to connect mssql with php, when I use mssql_pconnect(), It
will fail to connect when the amount of visitors becomes large. But,
when I use mssql_connect(), I can only run SELECT quern, while the
INSERT/UPDATE staments doesn't work. Can somebody tell me why? thanks
and sorry
Hello all:
Just have been tasked to port an app created on
(linux)php/mysql/apache to run (on Win2K)
php/mssql/apache.
Any links with info on setting up mssql to work with
php and apache (all on win2k) appreciated!
Luis
__
Do You Yahoo!?
Find the
is it possible to establish a connaction with php 4.0.4 to mssql server vers
8 ???
i've tried it serveral times but php alway crashes with the php_mssql70.dll
extension - and the modul php_mssql from the 4.0.6 release doesn't work with
php 4.04
is it there an other extension out there
thanx
cu
Universal Data Access Data Integration Technology Providers
-Original Message-
From: hausii [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 19, 2001 3:52 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] php and mssql 8
is it possible to establish a connaction with php 4.0.4 to mssql
Hello
Did anybody have problems with retrieving data from the fields of type
Text..
?php
$dsn = dsn_database;
$user = enduser;
$pass = ;
$query = usp_get_subj 10;
$conn = odbc_connect($dsn, $user, $pass);
$res = odbc_exec($conn, $query);
while (odbc_fetch_row($res)) {
//$data =
Hi
I found an interesting thing.. But it will just make my work much harder..
comparing to ASP... :o (which I already am not able to use in the
project we should deliver to our customer in a few weeks :o
?php
// database settings
$dsn = dsn_database;
$user = enduser;
$pass = ;
The error which occures during the call of stored procedure is:
Warning: SQL error: [Microsoft][ODBC SQL Server Driver]Invalid Descriptor
Index, SQL state S1002 in SQLGetData in
d:\Inetpub\wwwroot\local_test\test.php on line 43
Michael Yevdokimov
Web developer
e-mail: [EMAIL PROTECTED]
Ok.. I discovered also that everything will work pretty good.. But!! The
field on type text should be ALWAYS the LAST in the model of the table..
Otherwise, it will not work what happens in my case..
Good night!
Mike
Michael Yevdokimov
Web developer
e-mail: [EMAIL PROTECTED]
On Friday 22 June 2001 15:03, Martin Pavlas wrote:
Hi all,
I'm totaly lost. I have a Linux server (Debian Potato), which runs
Apache (1.3.14) + PHP (4.0.5) and MySQL (3.23.39).
Now, I need to connect to other machine (NT) which runs MS SQL 7 and I
need to insert some data to this machine.
Hi all,
I'm totaly lost. I have a Linux server (Debian Potato), which runs
Apache (1.3.14) + PHP (4.0.5) and MySQL (3.23.39).
Now, I need to connect to other machine (NT) which runs MS SQL 7 and I
need to insert some data to this machine. I'll read this data from my
MySQL and I need to store
-Original Message-
From: Miles Scruggs [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 11:17 AM
To: PHP Mailing
Subject: FW: [PHP-DB] php/linux/mssql
Well from what I can tell php treats sybase and mssql the same. Am I
wrong on this, or how do I fix this?
That's
So I don't get an error until I try to select a db. I run tcpdump
at the same time just to make sure that it wasn't trying to
connect
to the remote server and there was no attempt to even make a
connection.
Have you tried running a 'make check' in your FreeTDS directory to run
the
26 matches
Mail list logo