Hi,
I wonder if anyone can help please.
I need to retrieve data from a server running NT4SP5 MS SQL Server. The
server is NTSERV (distinguished name NT SQL SERVER), the table is data::stats
and the fields are name, id, number, status so the select reads "SELECT
name,id,number,status FROM data::stats WHERE status>0" This works fine using
the MS SQL Client on ither the server itself or from the web server "WEB".
I have installed ActivePerl and the DBD stuff on WEB and all the tests run
OK. Finally, I can create an html test page on the fly so the web server
(also NT4 running IIS) can see and run the perl scripts.
All I need to do is collect the data from the select statement (about 12
rows) and display in simple columns with a little header. Do you think I can
get the data in!
Ideas would be welcome; unfortunately I'm about 800 miles from the server so
I have to ftp the script onto the box, the manager there has to move it into
cgi-bin and then test it!
--
Best wishes,
Derek Harding, (BA MIAP)
ICT & Network Manager
[EMAIL PROTECTED]
