Re: Is PERL --> MS SQL really that difficult?

2007-04-26 Thread Martin J. Evans
Robert Denton wrote: Okay, as it tunrs out maybe it is not all that difficult afterall... With the help from someone form the FreeTDS developers team I got it to work. All I had to do was the following: I'm happy you are up and running. ~~ Since I just got this set up for myself

Re: Is PERL --> MS SQL really that difficult?

2007-04-26 Thread Robert Denton
Okay, as it tunrs out maybe it is not all that difficult afterall... With the help from someone form the FreeTDS developers team I got it to work. All I had to do was the following: ~~ Since I just got this set up for myself... odbc.ini: [ODBC Data Sources] TEST = Microsoft SQL Serv

RE: Gofer to PC (was: Is PERL --> MS SQL really that difficult?)

2007-04-26 Thread Garrett, Philip \(MAN-Corporate\)
Robert Denton wrote: > These look like some great options and I will keep them in mind for > future projects, especially DBI::Gofer. In this instance, however, > the server I am working with is "production frozen" so to speak and I > cannot install anything on it at all. All I can do is ask it fo

Re: Gofer to PC (was: Is PERL --> MS SQL really that difficult?)

2007-04-26 Thread Robert Denton
These look like some great options and I will keep them in mind for future projects, especially DBI::Gofer. In this instance, however, the server I am working with is "production frozen" so to speak and I cannot install anything on it at all. All I can do is ask it for information. I am

Gofer to PC (was: Is PERL --> MS SQL really that difficult?)

2007-04-26 Thread Tim Bunce
On Wed, Apr 25, 2007 at 05:24:40PM -0400, Robert Denton wrote: > Is it just me, or is using perl on a linux server to extract > information from an MS SQL server insanely difficult? Has no one > else struggled with this? Here is my set up: > > FC4 -> PERL w/DBI -> DBD::ODBC -> unixODBC -> Fr

Re: Is PERL --> MS SQL really that difficult?

2007-04-26 Thread Martin Evans
Robert Denton wrote: Is it just me, or is using perl on a linux server to extract information from an MS SQL server insanely difficult? Has no one else struggled with this? It is not that difficult but you've taken a free route which is slightly harder than a few commercial ones. You haven't

Re: Is PERL --> MS SQL really that difficult?

2007-04-26 Thread Peter J. Holzer
On 2007-04-25 17:24:40 -0400, Robert Denton wrote: > Can't connect to data source driver={SQL Server};Server=<192.168.0.149>; > database=;uid=; pwd=;, no database driver > specified and DBI_DSN env var not set at ./feedback.pl line 11 [...] > > $dbh = DBI->connect( $data_source, $username, $pass

Re: Is PERL --> MS SQL really that difficult?

2007-04-26 Thread Tim Bunce
On Wed, Apr 25, 2007 at 05:24:40PM -0400, Robert Denton wrote: > > $dbh = DBI->connect( $data_source, $username, $password ); > > And my $data_source var is set to this: > > my $data_source = 'driver={SQL > Server};Server=<192.168.0.149>;database=;uid=; > pwd=;'; That needs to have "dbi:ODBC:

Re: Is PERL --> MS SQL really that difficult?

2007-04-25 Thread Cosimo Streppone
Robert Denton wrote: Is it just me, or is using perl on a linux server to extract information from an MS SQL server insanely difficult? Has no one else struggled with this? Here is my set up: It's just you and probably someone else. FC4 -> PERL w/DBI -> DBD::ODBC -> unixODBC -> FreeTDS

RE: Is PERL --> MS SQL really that difficult?

2007-04-25 Thread Simon Windsor
: 25 April 2007 23:10 To: dbi-users@perl.org Subject: Re: Is PERL --> MS SQL really that difficult? "Why can't we all just get along?" --unknown (by me) I understood from the start that I would be raging against the machine but I was hoping there would be fellow ragers to hel

Re: Is PERL --> MS SQL really that difficult?

2007-04-25 Thread Robert Denton
"Why can't we all just get along?" --unknown (by me) I understood from the start that I would be raging against the machine but I was hoping there would be fellow ragers to help me along. I am _so_ close. I can feel it. But I really need some help to get it the rest of the way. Robert O

Is PERL --> MS SQL really that difficult?

2007-04-25 Thread Robert Denton
Is it just me, or is using perl on a linux server to extract information from an MS SQL server insanely difficult? Has no one else struggled with this? Here is my set up: FC4 -> PERL w/DBI -> DBD::ODBC -> unixODBC -> FreeTDS The irony is that all I need to do is a single simple select from