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
Then, is it safe to assume that you can run stored procedures and queries
that don't use a remote linked server? Fundamentally, I don't know why
PHP would be the problem, since the remote link is established within the
stored procedure. To make sure that it is not a problem with the mssql
extensio
You may be using the SA credentials, but will the sql server allow the
connection from the webserver. That is a different situation.
Bastien
From: Raul IONESCU <[EMAIL PROTECTED]>
Reply-To: Raul IONESCU <[EMAIL PROTECTED]>
To: php-db@lists.php.net
CC: [EMAIL PROTECTED]
Subject: Re:
Yes, of course; I'm running under sa credentials so that's not the problem.
On Mon, 14 Mar 2005 09:28:15 -0500, Bastien Koert <[EMAIL PROTECTED]> wrote:
> Do you have permissions to run the query as the php/webserver user?
>
> Bastien
>
> >From: Raul IONESCU <[EMAIL PROTECTED]>
> >Reply-To: Rau
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 accessing an remo
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
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
Yes, I'm connecting to a MSSQL server from FreeTDS, and it works fine.
Try using the IP of the MSSQL server instead of the name, and see if
that makes any difference.
On Mon, 2004-03-15 at 09:23, Jason Morrill wrote:
> I changed the mssql_select_db line as suggested by another person here
> but i
I changed the mssql_select_db line as suggested by another person here
but it didn't change a thing. I still get the exact same error message.
Is there anyone else here connecting to a MS SQL server using TDS v8.0
??
Thanks!
Jason
-Original Message-
From: Jason Morrill [mailto:[EMAIL P
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
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
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
Shaun, the MySQL manual suggests that you have hit your limit using the
VARCHAR field type (255 characters). To store 6,000 characters have you not
considered using the TEXT field type?
"6.2.3.1 The CHAR and VARCHAR Types
The CHAR and VARCHAR types are similar, but differ in the way they are
st
This is true if Shaun was using MySQL, but he is using MSSQL. MSSQL
allowas you to declare char and varchar fields with lengths up to 8000
characters. Unfortunately the extension bundled with PHP cannot read
beyond the first 255 characters. This is primarily due to the fact that
the extension wa
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
First make a odbc DSN to the MSSQL database.
Here is a code sample of how I connect to my MSSQL server via PHP.
This is inside my class_db.php
class Db
{
var $datasource;// Data source á server
var $username;
var $password;
var $connect;
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
>
> 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 Linux 7) with Microsoft SQL server (ru
Hi Dragan,
You may wish to use the the odbc_functions.
There is a HOWTO on compiling the iODBC Driver Manager in with PHP at
http://www.iodbc.org.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Tec
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
000c01c080c1$960de3b0$d5245ed1@tech2
30 matches
Mail list logo
