[opensuse] How to connect to MSSQL database?

Cody Nelson

21 Feb 2007 21 Feb '07

23:13

I seam to be having problems using perl or php to connect to a MSSQL database. The docs from both claim MSSQL support is built in, but the errors I get kind of suggest otherwise. Does Suse do something weird that I need to turn on, or do I have to break the Suse RPM manager and compile my own with the support built in? -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Show replies by date

Anders Johansson

21 Feb 21 Feb

23:18

On Thursday 22 February 2007 00:13, Cody Nelson wrote:

...

I seam to be having problems using perl or php to connect to a MSSQL database. The docs from both claim MSSQL support is built in, but the errors I get kind of suggest otherwise.

Does Suse do something weird that I need to turn on, or do I have to break the Suse RPM manager and compile my own with the support built in?

The support is separated into packages, so that people who don't want it don't have to install it. I don't find that particularly weird For perl support, install perl-DBD-mysql, for php install php5-mysql -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Cristian Rodriguez R.

22 Feb 22 Feb

00:39

Cody Nelson escribió:

...

I seam to be having problems using perl or php to connect to a MSSQL database. The docs from both claim MSSQL support is built in, but the errors I get kind of suggest otherwise.

Does Suse do something weird that I need to turn on, or do I have to break the Suse RPM manager and compile my own with the support built in?

At least with PHP, you cannot connect to MSSQL at the moment, since there is no official nor Buildservice only packages. (altough I already packaged the needed libraries, Im yet to enable mssql support in buildservice PHP packages) I have no idea of perl.

J Sloan

00:47

Cristian Rodriguez R. wrote:

...

Cody Nelson escribió:

...
I seam to be having problems using perl or php to connect to a MSSQL database. The docs from both claim MSSQL support is built in, but the errors I get kind of suggest otherwise.

Does Suse do something weird that I need to turn on, or do I have to break the Suse RPM manager and compile my own with the support built in?

At least with PHP, you cannot connect to MSSQL at the moment, since there is no official nor Buildservice only packages. (altough I already packaged the needed libraries, Im yet to enable mssql support in buildservice PHP packages)

Is there a php-sybase module? That worked with peecee sql, last I checked. Joe -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

George Stoianov

15:15

Are you talking about MS SQL Server or MySQL??? -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Jose

23 Feb 23 Feb

04:35

New subject: [opensuse] Switch box problem

Hi List, I just got one of those switch boxes to change from computer to computer, and when I hop from server to another I loose the mouse, keyboard is ok, but how to avoid/fix this problem? The box is a cheap KVM 4 port switch ,model kys-104, box says it does support Linux, so I don't know wher is the problem. Any advice, my mouse if an (gasp) Microsoft intellimouse optical usb, connected to the box using a usb to ps2 convertor, I remember having the same problem with early versions of redhat, I have a suse 10.2 and Centos 4 which I need to switch to from time to time. Any advice would be welcome, thanks Jose -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

John Andersen

04:44

New subject: [opensuse] Switch box problem

On Thursday 22 February 2007, Jose wrote:

...

connected to the box using a usb to ps2 convertor

There's your problem. PS2 was never intended for hotplug. -- _____________________________________ John Andersen

Randall R Schulz

05:07

New subject: [opensuse] Switch box problem

On Thursday 22 February 2007 20:44, John Andersen wrote:

...

On Thursday 22 February 2007, Jose wrote:

...
connected to the box using a usb to ps2 convertor

There's your problem. PS2 was never intended for hotplug.

No, but a properly designed PS/2 KVM maintains signals on all its computer side interfaces regardless of which one is currently being sent signals from the real mouse and keyboard. I've had good luck with Linksys PS/2 KVMs. It's my fancy (and expensive) DVI / USB KVM that messes up. It doesn't seem to bother my iMac, but it gives one of my Linux boxes indigestion with the appearance (according to the kernel logs) of frequent USB device disappearance and reappearance. Randall Schulz -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Carl Hartung

05:13

New subject: [opensuse] Switch box problem

On Thu February 22 2007 23:44, John Andersen wrote:

...

On Thursday 22 February 2007, Jose wrote:

...
connected to the box using a usb to ps2 convertor

There's your problem. PS2 was never intended for hotplug.

I thought the whole idea of a KVM switch was to provide 'stealth' hotplugging of the (K)eyboard (V)ideo and (M)ouse? Carl -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

John Andersen

06:47

New subject: [opensuse] Switch box problem

On Thursday 22 February 2007, Carl Hartung wrote:

...

I thought the whole idea of a KVM switch was to provide 'stealth' hotplugging of the (K)eyboard (V)ideo and (M)ouse?

Depends on the quality.... I've been through a lot of them that didn't work, and the symptoms were as the OP posted. I'd convert to usb everywhere and see if the problem goes away. -- _____________________________________ John Andersen -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

James Knott

12:23

New subject: [opensuse] Switch box problem

Carl Hartung wrote:

...

On Thu February 22 2007 23:44, John Andersen wrote:

...
On Thursday 22 February 2007, Jose wrote:

...
connected to the box using a usb to ps2 convertor

There's your problem. PS2 was never intended for hotplug.

I thought the whole idea of a KVM switch was to provide 'stealth' hotplugging of the (K)eyboard (V)ideo and (M)ouse?

Carl

There are (were?) some cheap KVMs that were essentially big mechanical switches that didn't do that. However, I've got what was a fairly expensive, good quality switch (Protec Bytelan) that exhibits that problem. My question is why does it affect only Linux? I've never seen the problem with OS/2 or Windows. Also, with the 2.4 kernel, it was possible to clear the problem, but not 2.6, by switching to a text console and back to desktop. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Jose

17:21

New subject: [opensuse] Switch box problem

James Knott wrote:

...

Carl Hartung wrote:

...
On Thu February 22 2007 23:44, John Andersen wrote:

...
On Thursday 22 February 2007, Jose wrote:

...
connected to the box using a usb to ps2 convertor

There's your problem. PS2 was never intended for hotplug.

I thought the whole idea of a KVM switch was to provide 'stealth' hotplugging of the (K)eyboard (V)ideo and (M)ouse?

Carl

There are (were?) some cheap KVMs that were essentially big mechanical switches that didn't do that. However, I've got what was a fairly expensive, good quality switch (Protec Bytelan) that exhibits that problem. My question is why does it affect only Linux? I've never seen the problem with OS/2 or Windows. Also, with the 2.4 kernel, it was possible to clear the problem, but not 2.6, by switching to a text console and back to desktop.

Hi List Thanks for all of the responses, I think I would return the item and get a usb switch instead, or get a Link Sys switch, I heard those are better. J -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Jerry Feldman

21:14

New subject: [opensuse] Switch box problem

On Fri, 23 Feb 2007 12:21:00 -0500 Jose wrote:

...

Thanks for all of the responses, I think I would return the item and get a usb switch instead, or get a Link Sys switch, I heard those are better. I would probably recommend that approach. One of the things I preferred about the Cybex and the Linksys is that they both responded to a keyboard sequence to switch, so I didn't have to press a button. Also some of the new ones have a speaker port so you can share the speakers or headphones.

Another anomaly I observed (with both the Linksys and Belkin) is that if the (SuSE LInux) laptop went into sleep mode, it would lose the mouse. Not sure why. If I recall, this happened on 2 different laptops and 2 different versions of SuSE Linux. -- Jerry Feldman Boston Linux and Unix user group http://www.blu.org PGP key id:C5061EA9 PGP Key fingerprint:053C 73EC 3AC1 5C44 3E14 9245 FB00 3ED5 C506 1EA9

Greg Freemyer

22:18

New subject: [opensuse] Switch box problem

On 2/23/07, Jerry Feldman wrote:

...

On Fri, 23 Feb 2007 12:21:00 -0500 Jose wrote:

...
Thanks for all of the responses, I think I would return the item and get a usb switch instead, or get a Link Sys switch, I heard those are better. I would probably recommend that approach. One of the things I preferred about the Cybex and the Linksys is that they both responded to a keyboard sequence to switch, so I didn't have to press a button. Also some of the new ones have a speaker port so you can share the speakers or headphones.

Another anomaly I observed (with both the Linksys and Belkin) is that if the (SuSE LInux) laptop went into sleep mode, it would lose the mouse. Not sure why. If I recall, this happened on 2 different laptops and 2 different versions of SuSE Linux.

I bought an IOgear 8-port PS/2 based switch last summer. I've got various SUSE boxes hooked up (2.4 & 2.6 kernels) I've got a Win2K & a Win2003 box. So far zero problems, but I often run the Linux boxes in pure CLI. Greg -- Greg Freemyer The Norcross Group Forensics for the 21st Century -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

James Knott

12:14

New subject: [opensuse] Switch box problem

Jose wrote:

...

Hi List,

I just got one of those switch boxes to change from computer to computer, and when I hop from server to another I loose the mouse, keyboard is ok, but how to avoid/fix this problem?

The box is a cheap KVM 4 port switch ,model kys-104, box says it does support Linux, so I don't know wher is the problem.

Any advice, my mouse if an (gasp) Microsoft intellimouse optical usb, connected to the box using a usb to ps2 convertor, I remember having the same problem with early versions of redhat, I have a suse 10.2 and Centos 4 which I need to switch to from time to time.

Any advice would be welcome, thanks

That's a common problem that I've only seen with Linux. I haven't had it happen with Windows or OS/2. With earlier kernels, you could clear the problem by switching to a command terminal and then back to the desktop. However, that doesn't seem to work with the 2.6 kernel. I've heard a USB mouse (that's USB all the way, not through a PS/2 adapter) and KVM works, but don't have any experience with one of those. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Doug McGarrett

22:45

New subject: [opensuse] Switch box problem

On Friday 23 February 2007 07:14, James Knott wrote:

...

Jose wrote:

...
Hi List,

I just got one of those switch boxes to change from computer to computer, and when I hop from server to another I loose the mouse, keyboard is ok, but how to avoid/fix this problem?

The box is a cheap KVM 4 port switch ,model kys-104, box says it does support Linux, so I don't know wher is the problem.

Any advice, my mouse if an (gasp) Microsoft intellimouse optical usb, connected to the box using a usb to ps2 convertor, I remember having the same problem with early versions of redhat, I have a suse 10.2 and Centos 4 which I need to switch to from time to time.

Any advice would be welcome, thanks

That's a common problem that I've only seen with Linux. I haven't had it happen with Windows or OS/2. With earlier kernels, you could clear the problem by switching to a command terminal and then back to the desktop. However, that doesn't seem to work with the 2.6 kernel. I've heard a USB mouse (that's USB all the way, not through a PS/2 adapter) and KVM works, but don't have any experience with one of those.

I've seen this happen with an old version of Windows. I'm not sure whether the problem exists with the OS or with the computer itself. But I do know the cure: you don't use a passive switch box, you have to buy a more expensive electronic switch box, and the problem should go away. Buy the switch with a money-back guarantee, in case it doesn't. BTW, you should be able to switch printers with a cheapie. I believe. --doug -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Jerry Feldman

21:09

New subject: [opensuse] Switch box problem

...

The box is a cheap KVM 4 port switch ,model kys-104, box says it does support Linux, so I don't know wher is the problem. I used to have a 4 port Linksys (low end) PS/2 KVM, and recently I switched to a Belkin 2-port USB that I use at work to switch between my corporate Windows Thinkpad and the HP Integrity (IA64) server under my desk. It generally works fine. The reason that some of these are not supported under Linux is that they supply software you can use to switch without having to press a button. On occasion, I have switched and lost the keyboard, but a switch back and forth usually clears the

On Thu, 22 Feb 2007 23:35:14 -0500 Jose wrote: problem. Another problem I've had was that somehow the Linux side behaves as if I have Caps Lock on and can't turn it off, but I've only seen that happen twice. I've also used a relatively high end Cybex (now Switchview). -- Jerry Feldman Boston Linux and Unix user group http://www.blu.org PGP key id:C5061EA9 PGP Key fingerprint:053C 73EC 3AC1 5C44 3E14 9245 FB00 3ED5 C506 1EA9

Tom Patton

13:33

On Wed, 2007-02-21 at 21:39 -0300, Cristian Rodriguez R. wrote:

...

Cody Nelson escribió:

...

At least with PHP, you cannot connect to MSSQL at the moment, since there is no official nor Buildservice only packages. (altough I already packaged the needed libraries, Im yet to enable mssql support in buildservice PHP packages)

I'm using php5 (php5-5.2.0-10) and mysql for zoneminder. I don't recall any problems with the suse dvd install. Tom -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Cody Nelson

27 Feb 27 Feb

23:35

MS SQL, I have no problems with mysql, but I need to connect to to some other mssql database that I have no say over. On 2/21/07, Cristian Rodriguez R. wrote:

...

Cody Nelson escribió:

...
I seam to be having problems using perl or php to connect to a MSSQL database. The docs from both claim MSSQL support is built in, but the errors I get kind of suggest otherwise.

Does Suse do something weird that I need to turn on, or do I have to break the Suse RPM manager and compile my own with the support built in?

At least with PHP, you cannot connect to MSSQL at the moment, since there is no official nor Buildservice only packages. (altough I already packaged the needed libraries, Im yet to enable mssql support in buildservice PHP packages)

I have no idea of perl.

-- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

George Stoianov

23:42

On 2/27/07, Cody Nelson wrote:

...

MS SQL, I have no problems with mysql, but I need to connect to to some other mssql database that I have no say over.

What language? Did you check MS's website for drivers?

...

On 2/21/07, Cristian Rodriguez R. wrote:

...
Cody Nelson escribió:

...
I seam to be having problems using perl or php to connect to a MSSQL database. The docs from both claim MSSQL support is built in, but the errors I get kind of suggest otherwise.

Does Suse do something weird that I need to turn on, or do I have to break the Suse RPM manager and compile my own with the support built in?

At least with PHP, you cannot connect to MSSQL at the moment, since there is no official nor Buildservice only packages. (altough I already packaged the needed libraries, Im yet to enable mssql support in buildservice PHP packages)

I have no idea of perl.

-- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

-- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Cody Nelson

28 Feb 28 Feb

00:18

Umm what? MS website for linux drivers?? Let me explain again in greater detail. This is a suse 10 box, that needs to connect to a MS SQL database, trying PHP or perl. I think they both claim to have support for MSSQL compiled in, however that doesn't seam to be the case, or there needs to be something werd I have to do to enable it. (wouldn't surprise me, had to do all kinds of weird things w/ Suse since 8.x to get compiled in features to work) Let me State again, Database is MS SQl, not MySQL. it has been a few weeks since I went on vacation and am now picking this project back up, so I don't have exacts right now. On 2/27/07, George Stoianov wrote:

...

On 2/27/07, Cody Nelson wrote:

...
MS SQL, I have no problems with mysql, but I need to connect to to some other mssql database that I have no say over.

What language? Did you check MS's website for drivers?

...
On 2/21/07, Cristian Rodriguez R. wrote:

...
Cody Nelson escribió:

...
I seam to be having problems using perl or php to connect to a MSSQL database. The docs from both claim MSSQL support is built in, but the errors I get kind of suggest otherwise.

Does Suse do something weird that I need to turn on, or do I have to break the Suse RPM manager and compile my own with the support built in?

At least with PHP, you cannot connect to MSSQL at the moment, since there is no official nor Buildservice only packages. (altough I already packaged the needed libraries, Im yet to enable mssql support in buildservice PHP packages)

I have no idea of perl.

-- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

-- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

-- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Kevin Donnelly

07:34

On Wednesday 28 February 2007 00:18, Cody Nelson wrote:

...

This is a suse 10 box, that needs to connect to a MS SQL database, trying PHP or perl. I think they both claim to have support for MSSQL compiled in, however that doesn't seam to be the case, or there needs to be something werd I have to do to enable it.

I believe Cristian Rodriguez (PHP maintainter for SUSE) answered a similar query a few days ago to the effect that the MSSQL module for SUSE's PHP5 is not working yet. I don't know whether the PHP4 one works or not. -- Pob hwyl / Best wishes Kevin Donnelly www.kyfieithu.co.uk - KDE yn Gymraeg www.klebran.org.uk - Gwirydd gramadeg rhydd i'r Gymraeg www.eurfa.org.uk - Geiriadur rhydd i'r Gymraeg www.rhedadur.org.uk - Rhedeg berfau Cymraeg -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Ciro Iriarte

4 Mar 4 Mar

05:33

2007/2/27, Cody Nelson :

...

Umm what? MS website for linux drivers??

Let me explain again in greater detail. This is a suse 10 box, that needs to connect to a MS SQL database, trying PHP or perl. I think they both claim to have support for MSSQL compiled in, however that doesn't seam to be the case, or there needs to be something werd I have to do to enable it. (wouldn't surprise me, had to do all kinds of weird things w/ Suse since 8.x to get compiled in features to work)

Let me State again, Database is MS SQl, not MySQL.

it has been a few weeks since I went on vacation and am now picking this project back up, so I don't have exacts right now.

What about freetds?, if i'm not wrong, it provides ODBC drivers for MSSQL, and PHP must work with ODBC.... Ciro -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

6260

Age (days ago)

6271

Last active (days ago)

List overview

Download

22 comments

16 participants

participants (16)

Anders Johansson
Carl Hartung
Ciro Iriarte
Cody Nelson
Cristian Rodriguez R.
Doug McGarrett
George Stoianov
Greg Freemyer
J Sloan
James Knott
Jerry Feldman
John Andersen
Jose
Kevin Donnelly
Randall R Schulz
Tom Patton