A few months back I wrote the list asking for help making a connection
to a MS SQL database from our linux webserver. At that time I was able
to make a successfull connection on Fedora Core 1 after installing
php-mssql.rpm and a freetds rpm. When I upgradd to FC4, I was unable
to continue my
Is it from php or the mssql driver? If it's from the driver, then the library
is installed at least partially correctly. If it's from php, perhaps not.
From there you can narrow it down by checking the connection parameters
outside of php to make sure they're right, is there a mssql client for
The error I'm getting is from the PHP function. Both mssql_connect and
PEAR are returning the same error. As far as I can tell, mssql only
returns the last line of an error message so I can't be sure that the
error I'm seeing is from MSSQL or PHP. Running TCPdump shows no
traffic is going to my
Hmm.. if you're using a function like mssql_error or something like that, it's
likely coming from the driver and not php..
Did you see this on the docs page?
I have spent the last 2 days trying to get PHP to connect to MSDE on Windows
2003 Web Edition.
Although initally PHP would connect
There's actually a few issues with php5 connecting that have solutions on this
page:
http://us2.php.net/manual/en/function.mssql-connect.php
You may of read it already though..
On Tuesday 01 November 2005 3:24 pm, Micah Stevens wrote:
Hmm.. if you're using a function like mssql_error or
See what perplexes me is that the extension seems to be installed (I
uninstalled the php-mssql rpm and got an error that the extension
wasn't installed). Reinstalling the rpm returned me to my original
error that the connection failed. As I mentioned TCPDUMP tells me that
there is no traffic
Do you have permissions to run the query as the php/webserver user?
Bastien
From: Raul IONESCU [EMAIL PROTECTED]
Reply-To: Raul IONESCU [EMAIL PROTECTED]
To: php-db php-db@lists.php.net
Subject: [PHP-DB] PHP MSSQL bug
Date: Mon, 14 Mar 2005 09:16:40 +0200
I have created a stored procedure wich
[EMAIL PROTECTED]
To: php-db php-db@lists.php.net
Subject: [PHP-DB] PHP MSSQL bug
Date: Mon, 14 Mar 2005 09:16:40 +0200
I have created a stored procedure wich is accessing an remote linked MSSQL
2000 server and works perfectly from Querry Analyzer. The problem occurs
when I try to execute
permissions to run the query as the php/webserver user?
Bastien
From: Raul IONESCU [EMAIL PROTECTED]
Reply-To: Raul IONESCU [EMAIL PROTECTED]
To: php-db php-db@lists.php.net
Subject: [PHP-DB] PHP MSSQL bug
Date: Mon, 14 Mar 2005 09:16:40 +0200
I have created a stored procedure
I have created a stored procedure wich is accessing an remote linked MSSQL
2000 server and works perfectly from Querry Analyzer. The problem occurs
when I try to execute the stored procedure from php 5.0.3 (by using mssql_bind
or mssql_query); I've got no error but no result either. It seems that
Recently, I had to format my db server and when I re-attached the database,
I noticed some unusal behavior. I have some fields in certain tables with a
width of 60. When I would extract data from the table for that specific
field, the data would contain extra blank chars. As a result, I am forced
Th cols are likely defined as CHAR not as VARCHAR. CHAR cols will pad out
the length of the value to the full width of the column...change the type to
varchar...
bastien
From: Dale Hersowitz [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [PHP-DB] php mssql
Date: Tue, 19 Oct 2004 09:36:25
-DB] PHP - MSSQL - LINUX
Hi Santosh Try to install mysql-3..22 source where you will get all libraries by
default . After installation of mysql configure php support with mysql. Madhu. Hi
All, Where do I get mssql.so to connect mssql with my PHP4.0.6 and PHP4.3.3
Regards, Santos
.
Is it possible can i get for MSSQL.so from MYSQL Installation.
Thanks and Regards,
Santhosh Kumar.M
- Original Message -
From: Madhu Manjari
To: [EMAIL PROTECTED]
Sent: Wednesday, March 17, 2004 2:27 PM
Subject: Re: [PHP-DB] PHP - MSSQL - LINUX
Hi Santosh Try
Open your php.ini file and uncomment the line:
extension=php_mssql.dll
Happy coding,
Jimmy Brock
-Original Message-
From: Santhosh Kumar [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 17, 2004 5:17 AM
To: PHP DB; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] PHP - MSSQL - LINUX
Hi Madhu
You will need to install and configure the FreeTDS library. Another
alternative is to use ODBTP, which is available at
http://odbtp.sourceforge.net. It is much easier to
install and configure than FreeTDS, and supports all of the mssql_*
functions. However, ODBTP requires a WIn32 service to be
Hi All,
Where do I get mssql.so to connect mssql with my PHP4.0.6 and PHP4.3.3
Regards,
Santos Kumar.M
PROTECTED]
Sent: Friday, March 12, 2004 8:36 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] PHP - MSSQL connects, but can't query
I've got a very simple PHP script for testing my MS SQL Server
connection. I've installed FreeTDS and I can connect and query the
database with TSQL.
With PHP I can
PROTECTED]
Subject: [PHP-DB] PHP - MSSQL connects, but can't query
I've got a very simple PHP script for testing my MS SQL Server
connection. I've installed FreeTDS and I can connect and query the
database with TSQL.
With PHP I can connect and disconnect properly but I can't query or
attach
I've got a very simple PHP script for testing my MS SQL Server
connection. I've installed FreeTDS and I can connect and query the
database with TSQL.
With PHP I can connect and disconnect properly but I can't query or
attach to different databases. Here is my sample PHP followed by what
the web
Hmm, replace the line where you select the DB with:
$dbconnect = mssql_select_db(Northwind) or
die(mssql_get_last_message());
(All on one line incase the email wraps it.)
On Fri, 2004-03-12 at 08:35, Jason Morrill wrote:
I've got a very simple PHP script for testing my MS SQL Server
It is not directly PHP but it is Db with PHP/Linux
Linux 2.4.19-4GB
Apache: httpd-2.0.48
php-4.3.4
freetds-0.61.2
I have php pages to connect to MsSQL-2000 server
$conn = mssql_connect($server, $user, $pass)
or die ;
or (PEAR:Db)
$dsn = mssql://$user:[EMAIL PROTECTED]/$dbname;
if
Le Wednesday 21 January 2004, 12:54:18 ou environ Robert Twitty [EMAIL PROTECTED] a
écrit:
Hi again Bob,
It was about 13h00 (13 pm) when you sent this mail and about 8 pm here. Thus
give me time to go back to work tomorrow morning and to study the question. If
interested I contact again.
Good
I used to use named pipes to connect to a remote sql server. My nt
department removed anonymous access account and now I have to use tcpip.
Since the change the performance of the php quering has decreased. it takes
more time to load the page.
anything to look at in the sql configs or in the
Thoughts... I've used mssql via PHP on linux via tcp/ip 1433 with good
success and performance.. Never used named pipes (I'm assuming you have
to be an entire ms environment to do that)
You might check into timing the process, perhaps the tcp/ip login is
taking longer for authentication against
or VARCHAR column that exceeds the column's
maximum length, the value is truncated to fit.
- Original Message -
From: Shaun Bentley [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, August 11, 2003 11:23 AM
Subject: [PHP-DB] PHP MSSQL
Hi
I am currently trying to use PHP
Message -
From: Shaun Bentley [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, August 11, 2003 11:23 AM
Subject: [PHP-DB] PHP MSSQL
Hi
I am currently trying to use PHP and MSSQL together but I am having a
few problems.
I can enter data into the Db OK, but when pulling
Hi
I am currently trying to use PHP and MSSQL together but I am having a
few problems.
I can enter data into the Db OK, but when pulling the data back to display
on the page, the string cuts to around 250 chars. The Db field is VarChar
6000 and I can see the whole data in the field.
I have
hi,
The charset used on my sql server is :
Character Set = 1, iso_1
ISO 8859-1 (Latin-1) - Western European 8-bit character set.
Where can I change these settings ?
Ben
[EMAIL PROTECTED] (Edwin Boersma) wrote in
news:[EMAIL PROTECTED]:
Your code page setting might be wrong.
Hello,
I'm developping an application using php and mssql.
I have problems with french accents,
when I insert something from php, and i consult it by enterprise manager
(sql server) the accents are replaced, example paté becomes patÚ
and if I insert something from enterprise manager and get teh
Your code page setting might be wrong.
Edwin
Benjamin Masdoua wrote:
Hello,
I'm developping an application using php and mssql.
I have problems with french accents,
when I insert something from php, and i consult it by enterprise manager
(sql server) the accents are replaced, example paté
Folks...
I have a situation where I need a Visual Basic program, running on a win2k server to
store some data. I later need a PHP script to come along, retrieve and parse that
data. I have a MS SQL server running on the win2k server along with the VP program. I
then have a RedHat/Apache box
);
$name = odbc_result($get,2);
echo $name has id $id;
}
Hope this helps,
Greetings,
Konni.
-Original Message-
From: Joseph Szobody [mailto:[EMAIL PROTECTED]]
Sent: 20. september 2002 22:44
To: [EMAIL PROTECTED]
Subject: [PHP-DB] PHP - MSSQL
Folks...
I have
Because of the limitations of MS SQL Server and the inability to limit
result sets as you are in MySQL, I am having to finesse/brute force a method
to peruse through large result sets.
My question is this: How exactly does the mssql_fetch_array() function
work? Does it make a call to the db
What version of php are you using ?
Handling of binary data from MSSQL Server was changed from php4.0.5 to php4.0.6.
As far as I can tell You should not have any problems with php4.0.6
- Frank
I am preparing a report for a database at my company that will be shown on
the web. It has
I am preparing a report for a database at my company that will be shown on
the web. It has several nested tables and such in it. One of the fields to
show is a blob field.
If the blob field is too long, IIS will hang, and not be able to render the
table. If the blob field is less than 2K
Hey all -
I would like to connect to a MSSQL server and do not know how. I have only
worked with MySQL which is pretty easy to set up. Can you tell me how to go
about this? Do I need to set up ODBC first? I imagine that it is not as
simple as MySQL but will not be much different.
Thanks much,
As someone else has noted, the ODBC functions are one way.
Another way, particularly if you prefer to talk to the database directly
rather than through a translation layer, is to install the FreeTDS
libraries (http://www.freetds.org/) on your Linux machine and then build
PHP with the
Hi there.
Is there any possible way to connect PHP (running on apache 1.3.12 on Red
Hat Linux 7) with Microsoft SQL server (running on Windows 2000) ?
Dragan Dinic, Serbia
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands,
On Mon, May 14, 2001 at 12:11:17PM +0200, Dragan Dinic wrote:
Hi there.
Hi.
Is there any possible way to connect PHP (running on apache 1.3.12 on Red
Hat Linux 7) with Microsoft SQL server (running on Windows 2000) ?
Yes
--
Jason Stechschulte
[EMAIL PROTECTED]
--
Perl itself is usually
What is the problem you're having? Are you trying to change setting in the
PHP.INI file and they are not reflecting in the scripts or is PHP returning
some other sort of error saying it could not locate PHP.INI?
""Robert"" [EMAIL PROTECTED] wrote in message
41 matches
Mail list logo