I have been using FreeTDS (0.53) and DBD::Sybase (0.91) to successfully talk to
both MSSQL 7 as well SQL 2000 servers from Solaris.
- Original Message -
From: Murali Kanaga
Sent: Tuesday, January 15, 2002 10:26 AM
To: '[EMAIL PROTECTED]'
Subject: Accessing MS SQL server data from
Alternately - if things get more complex, that is...
use Spreadsheet::WriteExcel;
- Original Message -
From: Sterin, Ilya
Sent: Monday, December 17, 2001 8:20 AM
To: 'Nguyen, David M '; ''[EMAIL PROTECTED] ' '
Subject: RE: How to?
Excel downloads CSV and HTML tables just fine, so what
DBI Gurus,
I am executing a storedprocedure in place of a query:
$dbh-prepare(sp_helptext usp_blah_blah);
Am getting the source of the stored procedure all right (BTW, am talking to MSSQL).
But my complaint is that each line is being returned as a different row..
Is there a trick I can do
May be a simple Q...
How do I get column names and order of column names
for a select * from ... query.
I dont want to use selecthash_ref just for column names.
Thanks in advance,
--MVRamana
_
Get your FREE download of MSN
select * from catalog with (UPDLOCK ROWLOCK)
where product = 'acs-101'
gives me Table level lock (as can be seen through 'sp_lock' stored proc)!
ActivePerl Build 629
DBI 1.14
W2K
Any Clues?
Thanks,
MVRamana
_
Get your FREE
Hi,
I use PerlScript (ActiveX compliant engine) in ASP
pages and connect to MSSQL using DBI.
All is well for first HTTP request. But for all subsequent
requests, I get empty response. If I touch the .asp file
(ie change the time stamp), it works again, but for only one request.
This problem is
I guess, it should be possible.
But I have NOT been able to accomplish this.
Any clue/help will be greatly appreciated.
Thanks,
MVRamana
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
Is there a way to tie DBI so that
I can use the DB as a Perl datastructure?
DB contents accessible as Perl data and any mods form perl go back to DB?
--MVRamana
_
Get your FREE download of MSN Explorer at http://explorer.msn.com