OpenSUSE :: FreeTDS And PHP With MSSQL Support Built In?
Aug 16, 2009
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.
I 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)
I 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
i tried to install wine in SLED11 but i got this error : configure: error: X development files not found. Wine will be built without X support, which probably isn't what you want.You will need to install development packages of Xlib/Xfree86 at the very least. Use the --without-x option if you really want this.
We're planning on getting computers with built-in Agere et131x NICs, and were wondering if these would be automatically detected/installed upon installing CentOS 5.3 ?
I 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?
Is there a way to programmatically determine whether a particular driver support is built-in rather than a loadable module? I'd be grateful if somebody would share how. I have written a shell script using the RTC (real time clock). I can check whether the rtc-cmos kernel module exists and load the module accordingly as needed, but I don't know how to determine when the driver is built-in. Of course, if the driver is built-in then the module does not exist.
I seem to recall there is a method to query the kernel config file (/proc/config.gz), through which I probably could grep for the CONFIG_RTC_DRV_CMOS parameter. I also can check whether /proc/driver/rtc exists. If that file exists then either the driver is built-in or the module was loaded.I realize the rtc-cmos driver is built-in with the standard Debian kernel build, but I still would like a way to query where the driver is supported.Is there a straightforward or direct method to query the kernel whether a particular driver is built-in?
Code: # /usr/local/etc/freetds.conf # $Id: freetds.conf,v 1.12 2007/12/25 06:02:36 jklowden Exp $ # # This file is installed by FreeTDS if no file by the same # name is found in the installation directory.
I'm attempting to get freetds and sybase up and running on my centos server, mainly for nagios - MSSQL checks. I've installed freetds freetds-devel ok but am having issues getting SYBASE installed. I've had a go via cpan but get a failure on the sybase environment variable. I've set it to /etc where the conf file is located as well as trying /urr/lib64 for the tds libs, but no joy. Has anyone had much luck with this on centos?
I am working on a project where I need to connect to a remote MS SQL Server database with PHP from a CentOS 5.5 server. I was able to get it installed and working on my Mac OS X 10.6 laptop with unixODBC and FreeTDS. However, I am unable to get it configured on my CentOS server. unixODBC and FreeTDS were installed, but when I try to connect, I get the following error message:
From what I could find by scouring the internets,it appears that I have 32 bit unixODBC (or FreeTDS, I'm not sure) installed (libtdsodbc.so.0 is symlinked to libtdsodbc.so.0.0.0) and it needs to be 64 bit. However, when I try to install the 64 bit version with
yum install freetds.x86_64
I get a message that it is already installed.Is there something else I need to do to get around this error? I'm a developer and not a server, so I'm not sure where else to go.
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.
Since some days a try to activate my web cam in a Sony VAIO VGN-FZ21Z. I had no success in openSUSE 11.3, neither Gnome nor KDE, neither 32 bit nor 64 bit. (It works in VISTA, not in Fedora and not in Mint).
Code: alfredo@linux-7zs0:~> lsusb Bus 001 Device 002: ID 05ca:183b Ricoh Co., Ltd Visual Communication Camera VGP-VCC8 [R5U870] Kopete: no web cam. Linux UVC drivers: -; Gspca: -; Microdia: -. Searching for "R5U870": links lead to old sites or ERROR.
I'm having some trouble installing SLES using "live installer" during the install process I get an error installing grub: Error 15: File not found.
I also tried dd to the drive (as I have done many times with opensuse) but I could not boot to the drive. I wanted to use SLES so that I could purchase support in the future if needed. The supportability report showed that all the packages were supported.
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
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.
I have on my Asus x59sl laptop webcam with built-in webcam. Here is the lsusb output:
Code:
Bus 001 Device 001: ID 1d6b:0002 Linux Foundation 2.0 root hub Bus 001 Device 003: ID 04f2:b012 Chicony Electronics Co., Ltd 1.3 MPixel UVC Webcam Bus 001 Device 005: ID 0bda:0116 Realtek Semiconductor Corp. Mass Storage Device Bus 002 Device 001: ID 1d6b:0001 Linux Foundation 1.1 root hub
There is no audio output to the speakers when listening to, or while recording from Line-in. Enabling software sound playthrough in Audacity did not help. Audacity simply froze. But I can make fine recordings from Line-in and play the recorded files. Also no sound from cd-audio. KsCD begins playback, but no sound. Only VLC works with cd-audio. Maybe some slider settings that I missed? This is what I did so far: Advanced Linux Sound Architecture Driver Version 1.0.20
It 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.
I 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:
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.
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 ?
New eeePC 1015PEM netbook, 2GB RAM, 250GB HDD. Came with Win 7 Starter; I retained this and installed openSUSE 11.3 alongside. Everything works well in Win 7 Most things also work well in oS 11.3, but there is a knotty problem with audio from the built-in speakers. Headphones are OK, but the speakers don't work reliably. Others have reported this on similar machines, and a number of "fixes" have been proposed in a wide range of forums, but so far I haven't found any that work.
I've actually installed oS 11.3 twice. After the first install I had no speaker sound at all, but after a day or two fiddling around it started to work of its own accord for no reason I could point to. For unrelated reasons (a silly mistake by me in Win 7) I then had to re-install oS 11.3 from scratch. This time the speaker sound worked after install, but then it dropped out again a couple of days later. Headphone audio has remained OK throughout.
I'm aware of and have applied the acpi_osi=Linux kernel parameter to enable the Fn keys on the machine (including sound volume and mute/unmute), so it's not that. I've combed the forums and Google extensively for other suggestions, and have tried them - including installing alsamixergui. I've also installed a properly matched ALSA KMP which changed some of the alsamixer controls but didn't cure the problem. Since it all works very well in Win7 and works sometimes in oS 11.3, I conclude that the problem is not with hardware but is something in software.
I am trying to switch from the video device built into the mother board, to a card i just put into my machine. I'm using gnome and don't know where to start. I shouldn't need new drivers (based on a possible misunderstanding) because I am going from a nvidia 6100 to a 8600. I have looked in various places like the control center but haven't had any luck. I just started using linux and have very little experience in the terminal. Issues with the current card are stopping me in my learning process.
I was wondering - is there any multi touch gesture support in openSuse 11.4? I have enabled multi touch scrolling under the 'Mouse' module in Yast, and it works fine. However, i was wondering if a multi touch gesture set is available - such as pinch zoom, or even custom gestures mapped to keyboard combos - e.g. using a spiral to launch terminal?
System - Acer Aspire One D255 (n550 version) Mouse Pad - SynPS/2 Synaptics TouchPad
I have a Toshiba Satellite L550 laptop with Suse 11.3 dual booting with Windows 7. Windows can detect the built in wireless card but not Suse, what can I do to get the wireless recognized in Suse.
I installed Open Suse 11.3, but no support mp3, mp4, dvd. The question is about openSUSE 11.X Addon NonOss. If I install this addon it has this support?
I'm trying to find out when QME2572 (Qlogic) card became support by the kernel. We have a RHEL 5.1 system that is moving to new hardware, however the kernel at this release doesn't support the new hardware, due to the Qlogic card change. I tired the Redhat KB and Bugzilla. Is there a Kernel change list etc I can search. Never really played around with the kernel too much so I'm just after some pointers for looking up this information. Offically its not supported until Redhat 5.3, I'm trying trying to research kernel info so I can tell the customer they have to upgrade.