Newbie - Access to SQL Server db thru Perl

2006-08-10 Thread Powers.Chris
Hello, I'm just trying to come up to speed on all of this and wanted to make sure I'm following along with what I need to do: In order for me to use Perl to access MS SQL Server, I need to install both the DBI-1.52 module & the DBD-ODBC module, is this correct? The DBI module will install dbi.

Problem getting Perl - SQL Server connect working - syntax error?

2006-08-15 Thread Powers.Chris
Hello, I'm trying to figure out what syntax issue I have with my Perl code. I am new at this, so it's probably something basic - simple syntax, but I don't see it and have looked thru some examples I've found online and still no luck. It's a Windows Server, SQL Server db, if it makes a differe

Problem getting Perl - SQL Server connect working - syntax error?

2006-08-15 Thread Powers.Chris
OK, someone did point out a syntax error (thanks!), but may have found the glitch...this may sound basic, but I don't know... Do I need to already have created a DSN file somewhere that this Perl code uses? I've been able to go thru the ODBC applet in MS Server and create user, system and file