Thanks rnahi for pointing out my errors in the code and the formatting error I used in posting my code.
The errors in the code, when corrected only made for more errors when it was run. And the code reference that you politely pointed out to me is all well and good if I were using mySQL but I'm not. I am using MS SQL2000, OS is Win2000, and IIS 5.
I have been going around in circles with no luck connecting to SQL2000.
Thanks again and any futher help will be appretiated.
What goes for connecting to MySQL using DBI generally goes for connecting to any database system using DBI. I've successfully switched a script between MSSQL2K, MySQL, and PostgreSQL with minimal changes.
--
Grant me the wisdom to shut my mouth when I don't know what I'm talking about.