RE: [PHP-DB] PHP to MS SQL Package
Hi, I have changed the freetds.conf file at the server section to the following: # A typical Microsoft server [egServer70] host = 192.168.10.129 port = 1433 tds version = 4.2 I noticed that the pinging and telnet to the server is error free like everything else you suggested below. However, I did notice that on my PHP configuration page, I see no information with MS SQL on the page like Gary described in another post. I am not sure if I would see this to make sure that my PHP would be able to connect to the MS SQL server. I did notice that after having added the above lines, it does not take as long for me to see that it is not connected to the server. I have made attempts to have another person use another programming language to connect using the same user name and password, and he could connect and I could not. Are there other things I might have missed? Alice == Alice Wei MIS 2009 School of Library and Information Science Indiana University Bloomington [EMAIL PROTECTED] From: Ken Keefe [EMAIL PROTECTED] Sent: Thursday, June 12, 2008 6:04 PM To: Wei, Alice J. Cc: Olavi ivask; php-db@lists.php.net Subject: Re: [PHP-DB] PHP to MS SQL Package That error message tells you that you are getting closer. Next step would be to make sure you have a connection to that system: $ ping 192.168.10.128 Next thing I would do is see if that port is open on the server: $ telnet 192.168.10.128 1433 If it says something about Escape character is ... then the SQL server is listening and no firewalls or anything are getting in the way. Finally, you probably need to add an entry at the bottom of your /etc/freetds/freetds.conf file that looks like this: [SomeNameForTheServer] host = 192.168.10.128 port = 1433 tds version = 8.0 Then, in your php code, use the name you give (SomeNameForTheServer) as the host instead of the IP address. Good luck. Ken On Thu, Jun 12, 2008 at 3:53 PM, Wei, Alice J. [EMAIL PROTECTED] wrote: Hi, I hope this would allow me to address this problem to a step further now. After getting FreeTDS installed, my error has now moved away from the undefined function level. I have looked through the PHP help from http://us3.php.net/manual/en/function.mssql-connect.php, and configured according to what has been listed in the user commentsThis is my error now: PHP Warning: mssql_connect(): Unable to connect to server: 192.168.10.128 in /usr/local/apache/htdocs/test.php on line 22 As some of you suggested, I find it surprising that after installing FreeTDS and referencing it when I was installing it using --with-sybase=/usr/local/freetds option when I installed the PHP, it kept on bringing me back errors saying that it cannot find it. I am not sure if it is the cause of why I still cannot connect. As for my php.info, I tried to run the search to find mssql values, but I cannot find any. Is this the reason why I still cannot connect to a different machine to its MS SQL using PHP? Have I missed something in my setup or something? Note: The setup for the database is accessible by another computer using the same server passwords, etc. I welcome any suggestions on t his. Alice == Alice Wei MIS 2009 School of Library and Information Science Indiana University Bloomington [EMAIL PROTECTED] From: Olavi ivask [EMAIL PROTECTED] Sent: Thursday, June 12, 2008 2:20 PM To: Wei, Alice J. Cc: php-db@lists.php.net Subject: RE: [PHP-DB] PHP to MS SQL Package Hello, Here is a good article about ms-sql PHP on Linux (http://www.devarticles.com/index2.php?option=contenttask=viewid=667pop=1page=0hide_js=1) Olavi Ivask On Thu, 2008-06-12 at 13:43 -0400, Wei, Alice J. wrote: Hi, After stopping the Apache server, I reinstalled PHP by adding the line you had below, and then restarted Apache. ./configure --with-apxs2=/usr/local/apache/bin/apxs \ --with-sybase=/usr/local/freetds --prefix=/usr/local/apache/php \ make make install After this has been completed, I am still getting the same error about how the function is not defined. Fatal error: Call to undefined function mssql_connect() in /usr/local/apache/htdocs/create_new_entry_master.php on line 20 Could there be other options? Or, am I missing something here? Alice == Alice Wei MIS 2009 School of Library and Information Science Indiana University Bloomington [EMAIL PROTECTED] From: Olavi ivask [EMAIL PROTECTED] Sent: Thursday, June 12, 2008 12:57 PM To: Wei, Alice J. Cc: php-db@lists.php.net Subject: Re: [PHP-DB] PHP to MS SQL Package Hi, you need to install freetds before compiling php. compile php: ./configure
Re: [PHP-DB] PHP to MS SQL Package
http://php.he.net/manual/en/mssql.installation.php Installation The MSSQL extension is enabled by adding extension=php_mssql.dll to php.ini. To get these functions to work, you have to compile PHP with --with-mssql[=DIR], where DIR is the FreeTDS install prefix. And FreeTDS should be compiled using --enable-msdblib. Did you actually do a compile ... --with-mssql=/usr/local/freetds ... I saw you asked ./configure [--with-apxs --with-mysql...] You actually meant mssql, right? But I didn't see a reply about that. I searched for --with-mssql in my emails and did not see that in your thread, but saw Claudio Saavedra's thread from Jan 12, 2007 'Problem with PHP 4.4.4 and MSSQL in Centos' also mentioning --with-sybase, but his solution was I fixed it by compiling again php with --with-mssql instead of --with-sybase. Now it works perfectly. So again, I'd recommend compiling --with-mssql. By the way anybody, why would I compile --with-sybase if I want to use MSSQL commands? I just checked my phpinfo on an install that has mysql and mssql. I don't even see a --with-mysql or --with-mssql like on previous servers, but I see additional .ini files parsed which mentions /etc/php.d/mssql.ini and /etc/php.d/mysqli.ini. Enjoy!
[PHP-DB] PHP to MS SQL Package
Hi, I am currently using a Linux box with Fedora 9.0 and I am trying to connect PHP to a MS SQL database. All the permissions on the MS SQL database is up to date and accurate, but I consistently get errors that say PHP Fatal error: Call to undefined function mssql_connect() in /usr/local/apache/htdocs/create_new_entry_master.php on line 20 I have looked into the options of using FreeBSD, as suggested on the http://us3.php.net/manual/en/function.mssql-connect.php#83196, but I am not sure if I could use it since I don't use a Windows Machine to run my PHP. Does anyone have any suggestions? Alice == Alice Wei MIS 2009 School of Library and Information Science Indiana University Bloomington [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP to MS SQL Package
Hi, you need to install freetds before compiling php. compile php: ./configure [--with-apxs --with-mysql...] --with-sybase=/usr/local/freetds make make install Olavi Ivask On Thu, 2008-06-12 at 12:14 -0400, Wei, Alice J. wrote: Hi, I am currently using a Linux box with Fedora 9.0 and I am trying to connect PHP to a MS SQL database. All the permissions on the MS SQL database is up to date and accurate, but I consistently get errors that say PHP Fatal error: Call to undefined function mssql_connect() in /usr/local/apache/htdocs/create_new_entry_master.php on line 20 I have looked into the options of using FreeBSD, as suggested on the http://us3.php.net/manual/en/function.mssql-connect.php#83196, but I am not sure if I could use it since I don't use a Windows Machine to run my PHP. Does anyone have any suggestions? Alice == Alice Wei MIS 2009 School of Library and Information Science Indiana University Bloomington [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] PHP to MS SQL Package
From: Olavi ivask [EMAIL PROTECTED] Sent: Thursday, June 12, 2008 12:57 PM To: Wei, Alice J. Cc: php-db@lists.php.net Subject: Re: [PHP-DB] PHP to MS SQL Package Hi, you need to install freetds before compiling php. compile php: ./configure [--with-apxs --with-mysql...] You actually meant mssql, right? I am getting mine to connect to mssql, and not mysql. --with-sybase=/usr/local/freetds make make install Olavi Ivask On Thu, 2008-06-12 at 12:14 -0400, Wei, Alice J. wrote: Hi, I am currently using a Linux box with Fedora 9.0 and I am trying to connect PHP to a MS SQL database. All the permissions on the MS SQL database is up to date and accurate, but I consistently get errors that say PHP Fatal error: Call to undefined function mssql_connect() in /usr/local/apache/htdocs/create_new_entry_master.php on line 20 I have looked into the options of using FreeBSD, as suggested on the http://us3.php.net/manual/en/function.mssql-connect.php#83196, but I am not sure if I could use it since I don't use a Windows Machine to run my PHP. Does anyone have any suggestions? Alice == Alice Wei MIS 2009 School of Library and Information Science Indiana University Bloomington [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP to MS SQL Package
Alice, make sure the php-mssql package is installed. # yum install php-mssql You shouldn't have to compile php or freetds as there are packages available to do what you want... Ken On Thu, Jun 12, 2008 at 11:14 AM, Wei, Alice J. [EMAIL PROTECTED] wrote: Hi, I am currently using a Linux box with Fedora 9.0 and I am trying to connect PHP to a MS SQL database. All the permissions on the MS SQL database is up to date and accurate, but I consistently get errors that say PHP Fatal error: Call to undefined function mssql_connect() in /usr/local/apache/htdocs/create_new_entry_master.php on line 20 I have looked into the options of using FreeBSD, as suggested on the http://us3.php.net/manual/en/function.mssql-connect.php#83196, but I am not sure if I could use it since I don't use a Windows Machine to run my PHP. Does anyone have any suggestions? Alice == Alice Wei MIS 2009 School of Library and Information Science Indiana University Bloomington [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Naturally, the common people don't want war, but they can always be brought to the bidding of the leaders. Tell them they are being attacked, and denounce the pacifists for lack of patriotism and endangering the country. It works the same in every country. --- Herman Goering, Hitler's Reichsmarschall, At the Nuremberg Trials -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] PHP to MS SQL Package
Hi, After stopping the Apache server, I reinstalled PHP by adding the line you had below, and then restarted Apache. ./configure --with-apxs2=/usr/local/apache/bin/apxs \ --with-sybase=/usr/local/freetds --prefix=/usr/local/apache/php \ make make install After this has been completed, I am still getting the same error about how the function is not defined. Fatal error: Call to undefined function mssql_connect() in /usr/local/apache/htdocs/create_new_entry_master.php on line 20 Could there be other options? Or, am I missing something here? Alice == Alice Wei MIS 2009 School of Library and Information Science Indiana University Bloomington [EMAIL PROTECTED] From: Olavi ivask [EMAIL PROTECTED] Sent: Thursday, June 12, 2008 12:57 PM To: Wei, Alice J. Cc: php-db@lists.php.net Subject: Re: [PHP-DB] PHP to MS SQL Package Hi, you need to install freetds before compiling php. compile php: ./configure [--with-apxs --with-mysql...] --with-sybase=/usr/local/freetds make make install Olavi Ivask On Thu, 2008-06-12 at 12:14 -0400, Wei, Alice J. wrote: Hi, I am currently using a Linux box with Fedora 9.0 and I am trying to connect PHP to a MS SQL database. All the permissions on the MS SQL database is up to date and accurate, but I consistently get errors that say PHP Fatal error: Call to undefined function mssql_connect() in /usr/local/apache/htdocs/create_new_entry_master.php on line 20 I have looked into the options of using FreeBSD, as suggested on the http://us3.php.net/manual/en/function.mssql-connect.php#83196, but I am not sure if I could use it since I don't use a Windows Machine to run my PHP. Does anyone have any suggestions? Alice == Alice Wei MIS 2009 School of Library and Information Science Indiana University Bloomington [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] PHP to MS SQL Package
From: Ken Keefe [EMAIL PROTECTED] Sent: Thursday, June 12, 2008 1:44 PM To: Wei, Alice J. Cc: php-db@lists.php.net Subject: Re: [PHP-DB] PHP to MS SQL Package Alice, make sure the php-mssql package is installed. # yum install php-mssql You shouldn't have to compile php or freetds as there are packages available to do what you want... I have just installed this gadget as you have listed, and then I have . The problem is that this does not get rid of what I had in my errors previously. PHP Fatal error: Call to undefined function mssql_connect() in /usr/local/apache/htdocs/create_new_entry_master.php on line 20 Code snippet: // connection to the database $dbhandle= mssql_connect($myServer, $myUser, $myPass) or die(Couldn't connect to SQL Server on $myServer); Ken On Thu, Jun 12, 2008 at 11:14 AM, Wei, Alice J. [EMAIL PROTECTED] wrote: Hi, I am currently using a Linux box with Fedora 9.0 and I am trying to connect PHP to a MS SQL database. All the permissions on the MS SQL database is up to date and accurate, but I consistently get errors that say PHP Fatal error: Call to undefined function mssql_connect() in /usr/local/apache/htdocs/create_new_entry_master.php on line 20 I have looked into the options of using FreeBSD, as suggested on the http://us3.php.net/manual/en/function.mssql-connect.php#83196, but I am not sure if I could use it since I don't use a Windows Machine to run my PHP. Does anyone have any suggestions? Alice == Alice Wei MIS 2009 School of Library and Information Science Indiana University Bloomington [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Naturally, the common people don't want war, but they can always be brought to the bidding of the leaders. Tell them they are being attacked, and denounce the pacifists for lack of patriotism and endangering the country. It works the same in every country. --- Herman Goering, Hitler's Reichsmarschall, At the Nuremberg Trials -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] PHP to MS SQL Package
Hello, Here is a good article about ms-sql PHP on Linux (http://www.devarticles.com/index2.php?option=contenttask=viewid=667pop=1page=0hide_js=1) Olavi Ivask On Thu, 2008-06-12 at 13:43 -0400, Wei, Alice J. wrote: Hi, After stopping the Apache server, I reinstalled PHP by adding the line you had below, and then restarted Apache. ./configure --with-apxs2=/usr/local/apache/bin/apxs \ --with-sybase=/usr/local/freetds --prefix=/usr/local/apache/php \ make make install After this has been completed, I am still getting the same error about how the function is not defined. Fatal error: Call to undefined function mssql_connect() in /usr/local/apache/htdocs/create_new_entry_master.php on line 20 Could there be other options? Or, am I missing something here? Alice == Alice Wei MIS 2009 School of Library and Information Science Indiana University Bloomington [EMAIL PROTECTED] From: Olavi ivask [EMAIL PROTECTED] Sent: Thursday, June 12, 2008 12:57 PM To: Wei, Alice J. Cc: php-db@lists.php.net Subject: Re: [PHP-DB] PHP to MS SQL Package Hi, you need to install freetds before compiling php. compile php: ./configure [--with-apxs --with-mysql...] --with-sybase=/usr/local/freetds make make install Olavi Ivask On Thu, 2008-06-12 at 12:14 -0400, Wei, Alice J. wrote: Hi, I am currently using a Linux box with Fedora 9.0 and I am trying to connect PHP to a MS SQL database. All the permissions on the MS SQL database is up to date and accurate, but I consistently get errors that say PHP Fatal error: Call to undefined function mssql_connect() in /usr/local/apache/htdocs/create_new_entry_master.php on line 20 I have looked into the options of using FreeBSD, as suggested on the http://us3.php.net/manual/en/function.mssql-connect.php#83196, but I am not sure if I could use it since I don't use a Windows Machine to run my PHP. Does anyone have any suggestions? Alice == Alice Wei MIS 2009 School of Library and Information Science Indiana University Bloomington [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP to MS SQL Package
Make sure some where in your php.ini you have a line that looks like this and is not commented out: extension=mssql.so I haven't used a fedora box as a php webserver in over a year, so my memory of their config file layout is pretty rusty. However, I'm pretty sure they consolidate everything into a single .ini file. I always add a phpinfo.php file to my project so I can run it and see which .ini file apache is using to configure php. All you have to put in the phpinfo.php file is this line: ?php phpinfo(); ? If you visit that page and look around, it will tell you where the php.ini file is. Also, once you have mssql enabled, there will be a section in the phpinfo.php page with all the mssql options. So, looking at the phpinfo.php file is another good way to tell if you have mssql installed properly. Good luck! Ken On Thu, Jun 12, 2008 at 12:58 PM, Wei, Alice J. [EMAIL PROTECTED] wrote: From: Ken Keefe [EMAIL PROTECTED] Sent: Thursday, June 12, 2008 1:44 PM To: Wei, Alice J. Cc: php-db@lists.php.net Subject: Re: [PHP-DB] PHP to MS SQL Package Alice, make sure the php-mssql package is installed. # yum install php-mssql You shouldn't have to compile php or freetds as there are packages available to do what you want... I have just installed this gadget as you have listed, and then I have . The problem is that this does not get rid of what I had in my errors previously. PHP Fatal error: Call to undefined function mssql_connect() in /usr/local/apache/htdocs/create_new_entry_master.php on line 20 Code snippet: // connection to the database $dbhandle= mssql_connect($myServer, $myUser, $myPass) or die(Couldn't connect to SQL Server on $myServer); Ken On Thu, Jun 12, 2008 at 11:14 AM, Wei, Alice J. [EMAIL PROTECTED] wrote: Hi, I am currently using a Linux box with Fedora 9.0 and I am trying to connect PHP to a MS SQL database. All the permissions on the MS SQL database is up to date and accurate, but I consistently get errors that say PHP Fatal error: Call to undefined function mssql_connect() in /usr/local/apache/htdocs/create_new_entry_master.php on line 20 I have looked into the options of using FreeBSD, as suggested on the http://us3.php.net/manual/en/function.mssql-connect.php#83196, but I am not sure if I could use it since I don't use a Windows Machine to run my PHP. Does anyone have any suggestions? Alice == Alice Wei MIS 2009 School of Library and Information Science Indiana University Bloomington [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Naturally, the common people don't want war, but they can always be brought to the bidding of the leaders. Tell them they are being attacked, and denounce the pacifists for lack of patriotism and endangering the country. It works the same in every country. --- Herman Goering, Hitler's Reichsmarschall, At the Nuremberg Trials -- Naturally, the common people don't want war, but they can always be brought to the bidding of the leaders. Tell them they are being attacked, and denounce the pacifists for lack of patriotism and endangering the country. It works the same in every country. --- Herman Goering, Hitler's Reichsmarschall, At the Nuremberg Trials -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] PHP to MS SQL Package
Hi, I hope this would allow me to address this problem to a step further now. After getting FreeTDS installed, my error has now moved away from the undefined function level. I have looked through the PHP help from http://us3.php.net/manual/en/function.mssql-connect.php, and configured according to what has been listed in the user commentsThis is my error now: PHP Warning: mssql_connect(): Unable to connect to server: 192.168.10.128 in /usr/local/apache/htdocs/test.php on line 22 As some of you suggested, I find it surprising that after installing FreeTDS and referencing it when I was installing it using --with-sybase=/usr/local/freetds option when I installed the PHP, it kept on bringing me back errors saying that it cannot find it. I am not sure if it is the cause of why I still cannot connect. As for my php.info, I tried to run the search to find mssql values, but I cannot find any. Is this the reason why I still cannot connect to a different machine to its MS SQL using PHP? Have I missed something in my setup or something? Note: The setup for the database is accessible by another computer using the same server passwords, etc. I welcome any suggestions on t his. Alice == Alice Wei MIS 2009 School of Library and Information Science Indiana University Bloomington [EMAIL PROTECTED] From: Olavi ivask [EMAIL PROTECTED] Sent: Thursday, June 12, 2008 2:20 PM To: Wei, Alice J. Cc: php-db@lists.php.net Subject: RE: [PHP-DB] PHP to MS SQL Package Hello, Here is a good article about ms-sql PHP on Linux (http://www.devarticles.com/index2.php?option=contenttask=viewid=667pop=1page=0hide_js=1) Olavi Ivask On Thu, 2008-06-12 at 13:43 -0400, Wei, Alice J. wrote: Hi, After stopping the Apache server, I reinstalled PHP by adding the line you had below, and then restarted Apache. ./configure --with-apxs2=/usr/local/apache/bin/apxs \ --with-sybase=/usr/local/freetds --prefix=/usr/local/apache/php \ make make install After this has been completed, I am still getting the same error about how the function is not defined. Fatal error: Call to undefined function mssql_connect() in /usr/local/apache/htdocs/create_new_entry_master.php on line 20 Could there be other options? Or, am I missing something here? Alice == Alice Wei MIS 2009 School of Library and Information Science Indiana University Bloomington [EMAIL PROTECTED] From: Olavi ivask [EMAIL PROTECTED] Sent: Thursday, June 12, 2008 12:57 PM To: Wei, Alice J. Cc: php-db@lists.php.net Subject: Re: [PHP-DB] PHP to MS SQL Package Hi, you need to install freetds before compiling php. compile php: ./configure [--with-apxs --with-mysql...] --with-sybase=/usr/local/freetds make make install Olavi Ivask On Thu, 2008-06-12 at 12:14 -0400, Wei, Alice J. wrote: Hi, I am currently using a Linux box with Fedora 9.0 and I am trying to connect PHP to a MS SQL database. All the permissions on the MS SQL database is up to date and accurate, but I consistently get errors that say PHP Fatal error: Call to undefined function mssql_connect() in /usr/local/apache/htdocs/create_new_entry_master.php on line 20 I have looked into the options of using FreeBSD, as suggested on the http://us3.php.net/manual/en/function.mssql-connect.php#83196, but I am not sure if I could use it since I don't use a Windows Machine to run my PHP. Does anyone have any suggestions? Alice == Alice Wei MIS 2009 School of Library and Information Science Indiana University Bloomington [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP to MS SQL Package
That error message tells you that you are getting closer. Next step would be to make sure you have a connection to that system: $ ping 192.168.10.128 Next thing I would do is see if that port is open on the server: $ telnet 192.168.10.128 1433 If it says something about Escape character is ... then the SQL server is listening and no firewalls or anything are getting in the way. Finally, you probably need to add an entry at the bottom of your /etc/freetds/freetds.conf file that looks like this: [SomeNameForTheServer] host = 192.168.10.128 port = 1433 tds version = 8.0 Then, in your php code, use the name you give (SomeNameForTheServer) as the host instead of the IP address. Good luck. Ken On Thu, Jun 12, 2008 at 3:53 PM, Wei, Alice J. [EMAIL PROTECTED] wrote: Hi, I hope this would allow me to address this problem to a step further now. After getting FreeTDS installed, my error has now moved away from the undefined function level. I have looked through the PHP help from http://us3.php.net/manual/en/function.mssql-connect.php, and configured according to what has been listed in the user commentsThis is my error now: PHP Warning: mssql_connect(): Unable to connect to server: 192.168.10.128 in /usr/local/apache/htdocs/test.php on line 22 As some of you suggested, I find it surprising that after installing FreeTDS and referencing it when I was installing it using --with-sybase=/usr/local/freetds option when I installed the PHP, it kept on bringing me back errors saying that it cannot find it. I am not sure if it is the cause of why I still cannot connect. As for my php.info, I tried to run the search to find mssql values, but I cannot find any. Is this the reason why I still cannot connect to a different machine to its MS SQL using PHP? Have I missed something in my setup or something? Note: The setup for the database is accessible by another computer using the same server passwords, etc. I welcome any suggestions on t his. Alice == Alice Wei MIS 2009 School of Library and Information Science Indiana University Bloomington [EMAIL PROTECTED] From: Olavi ivask [EMAIL PROTECTED] Sent: Thursday, June 12, 2008 2:20 PM To: Wei, Alice J. Cc: php-db@lists.php.net Subject: RE: [PHP-DB] PHP to MS SQL Package Hello, Here is a good article about ms-sql PHP on Linux (http://www.devarticles.com/index2.php?option=contenttask=viewid=667pop=1page=0hide_js=1) Olavi Ivask On Thu, 2008-06-12 at 13:43 -0400, Wei, Alice J. wrote: Hi, After stopping the Apache server, I reinstalled PHP by adding the line you had below, and then restarted Apache. ./configure --with-apxs2=/usr/local/apache/bin/apxs \ --with-sybase=/usr/local/freetds --prefix=/usr/local/apache/php \ make make install After this has been completed, I am still getting the same error about how the function is not defined. Fatal error: Call to undefined function mssql_connect() in /usr/local/apache/htdocs/create_new_entry_master.php on line 20 Could there be other options? Or, am I missing something here? Alice == Alice Wei MIS 2009 School of Library and Information Science Indiana University Bloomington [EMAIL PROTECTED] From: Olavi ivask [EMAIL PROTECTED] Sent: Thursday, June 12, 2008 12:57 PM To: Wei, Alice J. Cc: php-db@lists.php.net Subject: Re: [PHP-DB] PHP to MS SQL Package Hi, you need to install freetds before compiling php. compile php: ./configure [--with-apxs --with-mysql...] --with-sybase=/usr/local/freetds make make install Olavi Ivask On Thu, 2008-06-12 at 12:14 -0400, Wei, Alice J. wrote: Hi, I am currently using a Linux box with Fedora 9.0 and I am trying to connect PHP to a MS SQL database. All the permissions on the MS SQL database is up to date and accurate, but I consistently get errors that say PHP Fatal error: Call to undefined function mssql_connect() in /usr/local/apache/htdocs/create_new_entry_master.php on line 20 I have looked into the options of using FreeBSD, as suggested on the http://us3.php.net/manual/en/function.mssql-connect.php#83196, but I am not sure if I could use it since I don't use a Windows Machine to run my PHP. Does anyone have any suggestions? Alice == Alice Wei MIS 2009 School of Library and Information Science Indiana University Bloomington [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Naturally, the common people don't want war, but they can always be brought to the bidding of the leaders. Tell them they are being attacked, and denounce the pacifists for lack of patriotism
[PHP-DB] PHP and MS SQL Server 7.0
I would like to use PHP to open a connection to a MS SQL server, query the database, and then use the query results to generate dynamic content for a mass HTML e-mail campaign. Is it possible to execute PHP scripts in an HTML file or must the file have a .php extension? I'm limited by the software my employer uses (UnityMail, maybe someone's familiar with it?) which requires that the HTML code for the message body be pasted into a client-side form that the software then uses to generate the message and deliver it to the list of recipients. Any help is greatly appreciated! Cheers, Michael Morrison Valparaiso University http://www.therainforestsite.com/ http://www.thehungersite.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] PHP and MS-SQL
Thanks Frank! -Original Message- From: Frank M. Kromann [mailto:frank;kromann.info] Sent: Sunday, October 27, 2002 4:22 AM To: Axel Bergmann; [EMAIL PROTECTED] Subject: RE: [PHP-DB] PHP and MS-SQL Hi, It is true that FreeTDS works with MS SQL Server, but I think you need a bit more info: Sybase and MS SQL Server used to be the same product back when 4.x was released. Then Microsoft released 6.0 including a set of C libraries and everything was fine. Microsoft has not released new versions of the C libraries but they have added a lot of new features to the server with version 6.5, 7.0 and 2000. These features are not available from the C libraries so no matter if you are using the native MSSQL extension for Win32 or you use the Sybase extension with FreeTDS you are limited to the features available in version 6.0 of MS SQL Server. These limitations include char and varchar columns with maximum 255 bytes. No support for nchar, nvarchar or ntext and other types as well. If you can design your tables without using the new features you should be able to make it work. One of the big differences in the SQL is support for views and subselects in MS SQL Server but stuff like LIMIT is not supported (though you can do a select top * ...). - Frank Thanks John! Say, are there any arguments not to use MS-SQL? Did you run into any problems? Thanks, Axel -Original Message- From: Negretti, John (CCI-San Diego) [mailto:John.Negretti;cox.com] Sent: Friday, October 25, 2002 3:14 PM To: Axel; [EMAIL PROTECTED] Subject: RE: [PHP-DB] PHP and MS-SQL Axel, Well, I'm not sure what everyone will tell you, but this is what I did. I used MyODBC (on windows) to connect to SQL Server using the built-in odbc_***() PHP functions. There is also the matter of changing your SQL Statements to be compatible with SQL Server. MySQL and SQL Server have quite a few differences with SQL Statements. As far as the rest of your code, it should not matter if it's on UNIX or Windows. John Negretti Web Applications Developer Cox Communications www.cox.com -Original Message- From: Axel [mailto:bergmann;hi.net] Sent: Friday, October 25, 2002 6:57 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] PHP and MS-SQL I want to apologize for my ignorance in advance... I'm developing PHP code with MySQL on Unix platforms for quite a while. Now I'm asked to use my unix based PHP code with a MS-SQL database on a Microsoft platform. So while having the php code on a unix platform the MS-SQL database is obviously sitting on a Microsoft platform. Can this work and if so how can I do this? Thanks, Axel __ Axel Bergmann ICQ#: 114599496 Current ICQ status: + More ways to contact me __ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] PHP and MS-SQL
Hi, It is true that FreeTDS works with MS SQL Server, but I think you need a bit more info: Sybase and MS SQL Server used to be the same product back when 4.x was released. Then Microsoft released 6.0 including a set of C libraries and everything was fine. Microsoft has not released new versions of the C libraries but they have added a lot of new features to the server with version 6.5, 7.0 and 2000. These features are not available from the C libraries so no matter if you are using the native MSSQL extension for Win32 or you use the Sybase extension with FreeTDS you are limited to the features available in version 6.0 of MS SQL Server. These limitations include char and varchar columns with maximum 255 bytes. No support for nchar, nvarchar or ntext and other types as well. If you can design your tables without using the new features you should be able to make it work. One of the big differences in the SQL is support for views and subselects in MS SQL Server but stuff like LIMIT is not supported (though you can do a select top * ...). - Frank Thanks John! Say, are there any arguments not to use MS-SQL? Did you run into any problems? Thanks, Axel -Original Message- From: Negretti, John (CCI-San Diego) [mailto:John.Negretti;cox.com] Sent: Friday, October 25, 2002 3:14 PM To: Axel; [EMAIL PROTECTED] Subject: RE: [PHP-DB] PHP and MS-SQL Axel, Well, I'm not sure what everyone will tell you, but this is what I did. I used MyODBC (on windows) to connect to SQL Server using the built-in odbc_***() PHP functions. There is also the matter of changing your SQL Statements to be compatible with SQL Server. MySQL and SQL Server have quite a few differences with SQL Statements. As far as the rest of your code, it should not matter if it's on UNIX or Windows. John Negretti Web Applications Developer Cox Communications www.cox.com -Original Message- From: Axel [mailto:bergmann;hi.net] Sent: Friday, October 25, 2002 6:57 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] PHP and MS-SQL I want to apologize for my ignorance in advance... I'm developing PHP code with MySQL on Unix platforms for quite a while. Now I'm asked to use my unix based PHP code with a MS-SQL database on a Microsoft platform. So while having the php code on a unix platform the MS-SQL database is obviously sitting on a Microsoft platform. Can this work and if so how can I do this? Thanks, Axel __ Axel Bergmann ICQ#: 114599496 Current ICQ status: + More ways to contact me __ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PHP and MS-SQL
I want to apologize for my ignorance in advance... I'm developing PHP code with MySQL on Unix platforms for quite a while. Now I'm asked to use my unix based PHP code with a MS-SQL database on a Microsoft platform. So while having the php code on a unix platform the MS-SQL database is obviously sitting on a Microsoft platform. Can this work and if so how can I do this? Thanks, Axel __ Axel Bergmann ICQ#: 114599496 Current ICQ status: + More ways to contact me __ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP and MS-SQL
yes this works. if your code is going to remian on Unix you'll have to install freetds (www.freetds.org). there are instructions on www.php.net/mssql for install in the comments... when you get to the site(freetds.org) I know it says Sysbase..but it is what you're looking for. hope this helps jd Axel [EMAIL PROTECTED] To: [EMAIL PROTECTED] et cc: Subject: [PHP-DB] PHP and MS-SQL 10/25/2002 09:57 AM I want to apologize for my ignorance in advance... I'm developing PHP code with MySQL on Unix platforms for quite a while. Now I'm asked to use my unix based PHP code with a MS-SQL database on a Microsoft platform. So while having the php code on a unix platform the MS-SQL database is obviously sitting on a Microsoft platform. Can this work and if so how can I do this? Thanks, Axel __ Axel Bergmann ICQ#: 114599496 Current ICQ status: + More ways to contact me __ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] PHP and MS-SQL
Great, thanks a bunch! -Original Message- From: [EMAIL PROTECTED] [mailto:Jeffrey_N_Dyke;Keane.com] Sent: Friday, October 25, 2002 3:11 PM To: Axel Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] PHP and MS-SQL yes this works. if your code is going to remian on Unix you'll have to install freetds (www.freetds.org). there are instructions on www.php.net/mssql for install in the comments... when you get to the site(freetds.org) I know it says Sysbase..but it is what you're looking for. hope this helps jd Axel [EMAIL PROTECTED] To: [EMAIL PROTECTED] et cc: Subject: [PHP-DB] PHP and MS-SQL 10/25/2002 09:57 AM I want to apologize for my ignorance in advance... I'm developing PHP code with MySQL on Unix platforms for quite a while. Now I'm asked to use my unix based PHP code with a MS-SQL database on a Microsoft platform. So while having the php code on a unix platform the MS-SQL database is obviously sitting on a Microsoft platform. Can this work and if so how can I do this? Thanks, Axel __ Axel Bergmann ICQ#: 114599496 Current ICQ status: + More ways to contact me __ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP and MS SQL 2000 Performance
Am Mon, 19 Nov 2001 schrieb John Lim: Are you using ODBC? We recently had similar problems, and it turned out that we had SQL tracing enabled, and every single ODBC function call was being written to SQL.LOG And added, such a traced logfile can grow up to some megabyte of data. I know that from an other db-connectiontool. Has someone made expearance with using php-connections to a ms-sqlserver from a linux-box (odbc-connections from linux)? Regards, Ruprecht -- For germans Vielleicht zufällig ein Projekt zu vergeben und nun auf der Suche nach einem Freelancer? Dann doch gleichmal vorbeischauen unter http://www.gulp.de/profil/rhelms.html -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] PHP and MS SQL 2000 Performance
Ruprecht, SQLServer from Linux is pretty straightfoward. If you want full SQLServer2000 support, you will want to use ODBC. There is a HOWTO at www.iodbc.org for linking PHP --with-iodbc. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, November 19, 2001 3:11 PM To: John Lim; [EMAIL PROTECTED] Subject: Re: [PHP-DB] PHP and MS SQL 2000 Performance Am Mon, 19 Nov 2001 schrieb John Lim: Are you using ODBC? We recently had similar problems, and it turned out that we had SQL tracing enabled, and every single ODBC function call was being written to SQL.LOG And added, such a traced logfile can grow up to some megabyte of data. I know that from an other db-connectiontool. Has someone made expearance with using php-connections to a ms-sqlserver from a linux-box (odbc-connections from linux)? Regards, Ruprecht -- For germans Vielleicht zufällig ein Projekt zu vergeben und nun auf der Suche nach einem Freelancer? Dann doch gleichmal vorbeischauen unter http://www.gulp.de/profil/rhelms.html -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] PHP and MS SQL 2000 Performance
We're running W2K, IIS 5, PHP 4, and SQL Server 2000 and performance seems to be really slow. We're using a simple connect PHP script to query a table that has only 1 record in it, and it takes approximately 20 seconds to load. This seems to be very slow. Is this normal or does anyone have suggestions how to speed things up? Thanks! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] PHP and MS SQL 2000 Performance
I run SQL Server on my Pentium III 800mhz laptop which also runs IIS 5 and a variety of other services (including the PHP cgi) and have not seen any type of performance problems. First, are you using the mssql.dll to connect or ODBC? Second, are you running PHP as a cgi or ISAPI plug-in? Third, is performance from an ODBC client and/or remote Query Analyzer client slow performing the same queries? Fourth, did you check your SQL Server box and look at the activity on it? Is SQL Server or some other service hogging resources? Thanks, Joshua Hoover We're only running one database on the system. The sample databases that come with the software are still on there, but they're not being used at all - this system is still in the testing stage. We're running an Athlon 1.2 GHz processor with 512 MB RAM. Gadam [EMAIL PROTECTED] wrote in message 001c01c170b4$266aeb50$0100a8c0@fintani">news:001c01c170b4$266aeb50$0100a8c0@fintani... MS SQL has generally very slow performance and is consuming a lot of system resources. Are you running any other databases on the SQL server, apart from the one you are querying? Could it be that your system has very small processing power? In any case, these possibilities wouldn't justify suck a long delay, unless you SQL server is overcrowded with other huge databases that you use... George -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] PHP and MS SQL 2000 Performance
Are you using ODBC? We recently had similar problems, and it turned out that we had SQL tracing enabled, and every single ODBC function call was being written to SQL.LOG, slowing things down, so a simple query took 7 minutes. Joshua Hoover [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I run SQL Server on my Pentium III 800mhz laptop which also runs IIS 5 and a variety of other services (including the PHP cgi) and have not seen any type of performance problems. First, are you using the mssql.dll to connect or ODBC? Second, are you running PHP as a cgi or ISAPI plug-in? Third, is performance from an ODBC client and/or remote Query Analyzer client slow performing the same queries? Fourth, did you check your SQL Server box and look at the activity on it? Is SQL Server or some other service hogging resources? Thanks, Joshua Hoover We're only running one database on the system. The sample databases that come with the software are still on there, but they're not being used at all - this system is still in the testing stage. We're running an Athlon 1.2 GHz processor with 512 MB RAM. Gadam [EMAIL PROTECTED] wrote in message 001c01c170b4$266aeb50$0100a8c0@fintani">news:001c01c170b4$266aeb50$0100a8c0@fintani... MS SQL has generally very slow performance and is consuming a lot of system resources. Are you running any other databases on the SQL server, apart from the one you are querying? Could it be that your system has very small processing power? In any case, these possibilities wouldn't justify suck a long delay, unless you SQL server is overcrowded with other huge databases that you use... George -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] PHP and MS SQL 2000 Performance
First, are you using the mssql.dll to connect or ODBC? Using mssql.dll Second, are you running PHP as a cgi or ISAPI plug-in? As a CGI under the Home Directory tab Third, is performance from an ODBC client and/or remote Query Analyzer client slow performing the same queries? Performance from the Query Analyzer is extremely fast - pulls up 2000 records in like 3 seconds. Fourth, did you check your SQL Server box and look at the activity on it? Is SQL Server or some other service hogging resources? SQL Server is taking up about 40MB of memory, but not much of anything else going on. Thanks, Michael Thanks, Joshua Hoover We're only running one database on the system. The sample databases that come with the software are still on there, but they're not being used at all - this system is still in the testing stage. We're running an Athlon 1.2 GHz processor with 512 MB RAM. Gadam [EMAIL PROTECTED] wrote in message 001c01c170b4$266aeb50$0100a8c0@fintani">news:001c01c170b4$266aeb50$0100a8c0@fintani... MS SQL has generally very slow performance and is consuming a lot of system resources. Are you running any other databases on the SQL server, apart from the one you are querying? Could it be that your system has very small processing power? In any case, these possibilities wouldn't justify suck a long delay, unless you SQL server is overcrowded with other huge databases that you use... George -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] PHP and MS SQL 2000 Performance
I'm using the php_mssql.dll extension/connection. John Lim [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Are you using ODBC? We recently had similar problems, and it turned out that we had SQL tracing enabled, and every single ODBC function call was being written to SQL.LOG, slowing things down, so a simple query took 7 minutes. Joshua Hoover [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I run SQL Server on my Pentium III 800mhz laptop which also runs IIS 5 and a variety of other services (including the PHP cgi) and have not seen any type of performance problems. First, are you using the mssql.dll to connect or ODBC? Second, are you running PHP as a cgi or ISAPI plug-in? Third, is performance from an ODBC client and/or remote Query Analyzer client slow performing the same queries? Fourth, did you check your SQL Server box and look at the activity on it? Is SQL Server or some other service hogging resources? Thanks, Joshua Hoover We're only running one database on the system. The sample databases that come with the software are still on there, but they're not being used at all - this system is still in the testing stage. We're running an Athlon 1.2 GHz processor with 512 MB RAM. Gadam [EMAIL PROTECTED] wrote in message 001c01c170b4$266aeb50$0100a8c0@fintani">news:001c01c170b4$266aeb50$0100a8c0@fintani... MS SQL has generally very slow performance and is consuming a lot of system resources. Are you running any other databases on the SQL server, apart from the one you are querying? Could it be that your system has very small processing power? In any case, these possibilities wouldn't justify suck a long delay, unless you SQL server is overcrowded with other huge databases that you use... George -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]