On my LAMP server (recently installed, latest CentOS) i want to use php-mssql to connect to a remote MSSQL server. Therefore i need php-mssql. If i run "yum install php-mssql" it tells me "No package php-mssql available.".
On a older installation (2 years old, but up2date) i had no problem installing php-mssql. I cant tell the difference. I've read this tread:
[URL]
Also "yum install --enablerepo=extras php-mssql" didnt helped me.
I just succesfully installed Centos 5.5 64bit with following package:
- httpd 2.2.3-43
- php-mysql 5.1.6-27
- mysql 5.0.77-4
and all these packages are running ok.
My question is how do i connect from Centos to another MSSQL server using PHP? I had read several article but cannot find the best way to achieve this because most of the instruction seems to be quite complicated. I found somewhere in this forum that all it need just this simple command: "yum --enablerepo=extras install php-mssql freetds". While others article said that i need to install "FreeTDS" and some ODBC driver. I'm a little bit curious since most of that article are using an older version of Centos and PHP.
How to add port of MSSQL(1433) to httpd_can_network_connect_db or add some changes in apache policy? I know about httpd_can_network_connect but this is not my way.
View 6 Replies View RelatedI need CentOS to communicate with an MS SQL Server 2000.I have installed FreeTDS and PHP and the following work:TSQL (using and selecting from the SQL Server)PHP from Shell (running a script from the shell)
View 5 Replies View Relatedmy company's current server is running on windows... so i want to change it to centos linux.. but my problem is they want mssql running on it..Is it possible to run MSSQL in centos 5?I want to run MySQL and MSSQL in centos 5, both DB.
View 4 Replies View RelatedI was building yesterday the boost-1.45.0 RPM package for CentOS 5.5.
View 3 Replies View RelatedI am running openSUSE 11.2 and would like to connect to MsSQL using PHP5.3.0 (I do connect to MySQL 5.1.45). Lots of info is available on the Google but nothing on SUSE. I installed "freeTDS" and "PHP5-PDO" objects but am not sure which way to go. Is ODBC another option? speed/functions?
View 9 Replies View RelatedI have been using Suse since version 6, now I installed 11.4 64bit - great distro, but still have no PHP5-MSSQL support. Why is that? FC supports it, why not Suse?
Is there, maybe, a current 64bit PHP5-MSSQL RPM from custom repository?
Workaround: Is there another way (or even different ways?) to connect to MSSQL server from PHP and if yes
1. Am i able to host a MSSQL DB and use it on MySQL?
2. Where is the download link for MySQL server on Linuix (CentOS) as i can't seem to find it for linuix and is it possible to have a gui for MySQL on it if so which program would you recommend?
I am relatively new to the world of linux and PHP. I need to set up my PHP to work with the extension mssql as I have a mssql DB on another server that my websites connects to. I have followed this guide [URL] but get the following error when I run the command isql -v mstest satest satest which is under step 5.
[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
[ISQL]ERROR: Could not SQLConnect
Can we get this built into the distribution? This would really set it apart from other distributions that don't have this included. And it would most likely make a lot of PHP developer lives a bit easier.
View 7 Replies View RelatedIt took a while but I got my home webserver setup and running with mysql. Now I want to import a 70MB MSSQL backup file from my hosting company. I noticed phpMyAdmin can import up to 2MB. Any suggestions on how to do this for a larger file. I do have access to the server running SSH so I'm not opposed to using the command line if I need to.
View 2 Replies View RelatedI want to import data from MySQL to MSSQL. I've been searching in the web, and I can't find a good and straight answer. How can I do it?
View 2 Replies View RelatedI get this error when running my program under linux; under windows it works as expected:
Code:
$ ./mssql_test
("QSQLITE", "QMYSQL3", "QMYSQL", "QODBC3", "QODBC")
qGetStringData: Error while fetching data ("[FreeTDS][SQL Server]Program type out of range")
QVariant(int, 1) QVariant(QString, "")
I can retrieve int's just fine, but not nvarchar's. I'm using unixODBC 2.2.12 and FreeTDS 0.82. The funny thing is, that I can use isql and tsql with no problem. The mssql_test program:
Code:
#include <QSqlDatabase>
#include <QSqlError>
#include <QSqlQuery>
#include <QDateTime>
#include <QDebug>
#include <QVariant>
#include <QStringList>
#include <QSqlRecord> .....
The same error and output continue for the next records. These have cut out. I've been looking for a solution of a couple of days now, with no luck.
I am migrating SugarCRM from windows server to a linux server. But the main problem is the database. How will I import the data from MSSQL of windows to MYSQL of Linux ?
View 5 Replies View RelatedWhy does centos-release-notes have any dependancies ?
I can see no reason why centos-relese-notes should depend on centos-release when I try "yum erase centos-release-notes" I am told there are 72 dependancies including completely irrelevant packages such as tar all because of this unnecessary dependancy.
The centos-release-notes package simply contains a bunch of text/html files that nothing else relies upon, so why the dependancies ?
I am trying to see if there is an authbind equivalent or authbind package for CentOS/RHEL? x If so, where can I get more info and download it? It seems to be only available for Debian and Ubuntu.
View 3 Replies View RelatedError installing mod_ssl on centos 5.7. Do not install the mod_ssl module says there is a package conflict, some way to fix it?. is a 64-bit
[Code]...
Does anyone have a simple to use bash script or some such that will convert MSSQL dump files to MySQL formatted dump files?
View 6 Replies View RelatedToday, I try to update firefox by Package Updater but show error by bellow. "Missing Dependency: xulrunner >= 1.9.0.19-1 is needed by package firefox-3.0.19-1.el5.centos.x86_64 (CentOS5updates)"
View 6 Replies View RelatedIs there an RPM package for mpfr?
View 1 Replies View RelatedI'm trying to figure out how to retrieve SNORT from a repository and I'm stuck. How can I find the latest version and install it?
View 4 Replies View RelatedI am using CentOS5.5 and I want to install few packages through yum.
like gnome-libs,XFree-libs etc. But when I run yum install gnome-libs it gives no
package available.
how to update yum to make these package available?
I am new user for centos. I dun my installation (centos 5) without GUI. I type the command yum groupinstall "GUI", yum groupinstall "XFCE-4.4", yum groupinstall "GUI", yum groupinstall "X11", and so. But the System says no packages available. So what can I do.
View 10 Replies View RelatedI've try to install vlc via Yum command..... but said that there isn't package. What can I do for install vlc (and this is the same thing for Firefox .....)
Here the result:
[root@localhost Bruno]# yum install vlc
Loaded plugins: fastestmirror, priorities
Loading mirror speeds from cached hostfile
* addons: it.centos.contactlab.it
* base: it.centos.contactlab.it
* extras: ftp.plusline.de
* updates: centos.de-mirror-server.de
Setting up Install Process
No package vlc available.
Nothing to do
I've also tru to update Yum ..... same answer ......
[root@localhost Bruno]# yum update
Loaded plugins: fastestmirror, priorities
Loading mirror speeds from cached hostfile
* addons: it.centos.contactlab.it
* base: it.centos.contactlab.it
* extras: ftp.plusline.de
* updates: centos.de-mirror-server.de
Setting up Update Process
No Packages marked for Update
I install php in my centos 5.5 , but when I use yum install krb5 gcc-g77 libpng10 libpng10-devel I get the messages. No package available. The centos it's don't support these package?
View 2 Replies View RelatedI'm looking for a package rpm for httpd 2.2.19 and the only repository I have found so far is cent.alt.ru repository. Any guidance/advice on using this repository? Or know of any trusted repositories with httpd 2.2.19?
View 7 Replies View RelatedIs there an equivalent of synaptic package manager of ubuntu in CentOS?
View 1 Replies View RelatedI have installed a base 5.2 server. I updated the network proxies in preferences and also updated the values for internet access. I can't get the package updater to work. I can use "yum update" and this work but I don't want to update everything. I have allowed a full update and one or more of them is affecting an IOZone test I am running to fiber storage. If I run the test to the base install, it completes OK. If I run the test after all the updates, the test fails with file writes and test files diaappearing. In any case, I would like to use the software updated hoping this will allow me to selectively add the updates.There is about 400 updates that get applied. I am currently getting the 5.3 image and will do and install with that to see if the test runs.
View 3 Replies View Relatedyum-priorities package for 5.3 is listed here:
[URL]
but for 5.4 it does not exist:
[URL]
Is this intended?