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 goin
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 som
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 t
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
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
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 pro
lt;[EMAIL PROTECTED]> wrote:
> > 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
>
er?
>
> Bastien
>
> >From: Raul IONESCU <[EMAIL PROTECTED]>
> >Reply-To: Raul IONESCU <[EMAIL PROTECTED]>
> >To: php-db
> >Subject: [PHP-DB] PHP MSSQL bug
> >Date: Mon, 14 Mar 2005 09:16:40 +0200
> >
> >I have created a stored proc
CU <[EMAIL PROTECTED]>
> >Reply-To: Raul IONESCU <[EMAIL PROTECTED]>
> >To: php-db
> >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
> >2
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
Subject: [PHP-DB] PHP MSSQL bug
Date: Mon, 14 Mar 2005 09:16:40 +0200
I have created a stored procedure wich is
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 p
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: Tu
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 t
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 in
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
MySQL .
> 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: [P
-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 > >
Re
Hi All,
Where do I get mssql.so to connect mssql with my PHP4.0.6 and PHP4.3.3
Regards,
Santos Kumar.M
]
> 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 quer
EMAIL 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 wit
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
> conne
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 se
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
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";
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
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 php
to a CHAR 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 & MS
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 tr
r 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 A
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.
>
>
> E
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é" beco
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 te
hile (odbc_fetch_row($get)) // walk through all results
{
$id = odbc_result($get,1);
$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.
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 th
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 ser
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 sev
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,
ol
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
>
> 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 th
> -Original Message-
> From: Dragan Dinic [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 14, 2001 5:11 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] php -> MSSQL
>
>
> Is there any possible way to connect PHP (running on apache
> 1.3.12 on Red Hat Linu
tion Technology Providers
> -Original Message-
> From: Dragan Dinic [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 14, 2001 6:11 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] php -> MSSQL
>
>
> Hi there.
>
> Is there any possible way to connect PHP (running
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
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, e
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
000c01c080c1$960de3b0$d5245ed1@tech2
php 4.0.5-dev / IIS 4 / Win NT 4 Server / MSSQL 6.5
It looks like PHP is ignoring my php.ini file ( in c:\winnt\ )
I make changes, restart IIS and do a phpinfo() the changes do not show up
I tried copying the php.ini file to c:\ c:\winnt\ c:\winnt\system32\ and even
made a c:\windows fold
45 matches
Mail list logo
