I've been given a quick task to perform which involves updating a database on a server. I have little or no idea how to do this and I need to get it done today. The main problem is that i've been given a non-perl code snippet ( VB )

sub open_conn
 ' Connect to the Onepoint Database for a list of all hosts
 dim strConnect: strConnect = "Provider=SQLOLEDB.1;Data Source=iblons3
+506\oi_c1_prd4;Initial Catalog=OMDPortal;User ID=OMDPortal_General;Pa
+ssword=oBfuScaTed;"
 set oConn = CreateObject("ADODB.Connection")
 oConn.Open strConnect
 
end sub
[download]

which is what is currently used and I want to perform the same thing with perl. If anyone could point me in the right direction i'll buy them a beer. Jeff

Password obfuscated by holli