Re: module for accessing MSSQL

2009-07-07 Thread practicalperl
Thanks all for the helps. Now I know there are at least two correct ways for it. -- To unsubscribe, e-mail: beginners-unsubscr...@perl.org For additional commands, e-mail: beginners-h...@perl.org http://learn.perl.org/

Re: module for accessing MSSQL

2009-07-07 Thread Brent Clark
practicalp...@gmail.com wrote: Hello, what's the standard module for accessing MSSQL? I searched on CPAN but found a lot. The program should be run on Linux, not Windows. Thanks. Hiya I use perl on with FreeBSD and Linux but via Freetds. It works and it works very well. You will need DB

Re: module for accessing MSSQL

2009-07-07 Thread Dan
On Tue, 2009-07-07 at 16:50 +0800, practicalp...@gmail.com wrote: > On Tue, Jul 7, 2009 at 4:46 PM, Cristi Ocolisan wrote: > > Hi, > > > > > > > > You'll need DBD::ODBC module. > > > > thanks. > can DBD::ODBC be run under Linux? Sure does. You'll need freetds, and setting up the odbc.ini file is

AW: Edit text file using perl script

2009-07-07 Thread Thomas Bätzler
Alpesh Naik wrote: > Hi Thomas, > and thanks for the reply, > > Given below is my code, > > #!/usr/bin/perl #!/usr/bin/perl -w => You should always enable warnings. > use strict; > > print "Content-type:text/html\n\n"; > use CGI; > my $query = new CGI; => If you're using CGI, then you should

AW: Perl DBI error

2009-07-07 Thread Thomas Bätzler
Dave Tang asked: > I am having a problem with binding a variable when executing on a DBI > object. [...] "You can only reliably bind values, not field or table names. Database that plan query execution won't accept this, because they need table and field names to make their query execution p

Re: module for accessing MSSQL

2009-07-07 Thread practicalperl
On Tue, Jul 7, 2009 at 4:46 PM, Cristi Ocolisan wrote: > Hi, > > > > You'll need DBD::ODBC module. > thanks. can DBD::ODBC be run under Linux? -- To unsubscribe, e-mail: beginners-unsubscr...@perl.org For additional commands, e-mail: beginners-h...@perl.org http://learn.perl.org/

Re: module for accessing MSSQL

2009-07-07 Thread Owen
> On Tue, Jul 7, 2009 at 4:36 PM, Owen wrote: >> >> >>> what's the standard module for accessing MSSQL? >>> I searched on CPAN but found a lot. >>> The program should be run on Linux, not Windows. >>> Thanks. >> >> >> >> >> You probably want to install DBI and then DBD-mysql >> > > sorry, I said M

RE: module for accessing MSSQL

2009-07-07 Thread Cristi Ocolisan
Hi, You'll need DBD::ODBC module. Find documentation here: http://search.cpan.org/~mjevans/DBD-ODBC-1.22/ODBC.pm HTH Cristi -Original Message- From: practicalp...@gmail.com [mailto:practicalp...@gmail.com] Sent: Tuesday, July 07, 2009 11:39 AM To: Perl Beginners Subject:

Re: module for accessing MSSQL

2009-07-07 Thread Gurunandan R. Bhat
If you are on a Linux server then DBD::Sybase is your best bet. It uses freetds to connect to MS-SQL server. If on a Windows then DBD::ODBC is your friend. REgards Guru On Tue, 2009-07-07 at 16:11 +0800, practicalp...@gmail.com wrote: > Hello, > > what's the standard module for accessing MSSQ

Re: module for accessing MSSQL

2009-07-07 Thread practicalperl
On Tue, Jul 7, 2009 at 4:36 PM, Owen wrote: > > >> what's the standard module for accessing MSSQL? >> I searched on CPAN but found a lot. >> The program should be run on Linux, not Windows. >> Thanks. > > > > > You probably want to install DBI and then DBD-mysql > sorry, I said MSSQL not Mysql. -

Re: module for accessing MSSQL

2009-07-07 Thread Owen
> what's the standard module for accessing MSSQL? > I searched on CPAN but found a lot. > The program should be run on Linux, not Windows. > Thanks. You probably want to install DBI and then DBD-mysql Once you have installed DBI, read its documentation. It will give you lots of information.

Perl DBI error

2009-07-07 Thread Dave Tang
Hi everybody, I am having a problem with binding a variable when executing on a DBI object. The code goes: #!/usr/bin/perl use warnings; use strict; use DBI; #DBI variables my $database = 'databaseName'; my $hostname = 'localhost'; my $dsn = "DBI:mysql:database=$database;host=$hostname"; my

module for accessing MSSQL

2009-07-07 Thread practicalperl
Hello, what's the standard module for accessing MSSQL? I searched on CPAN but found a lot. The program should be run on Linux, not Windows. Thanks. -- To unsubscribe, e-mail: beginners-unsubscr...@perl.org For additional commands, e-mail: beginners-h...@perl.org http://learn.perl.org/