Re: perl and switching between different version servers

[marto]

"My problem is I've been left with a perl script by the programmer and the following directions:"switch from sql server 2005 to sql 2000 to run the perl script."

So are you currently running SQL server 2005? Does this code actually work as you expect it to? Have you considered asking the programmer who wrote this for an explanation of this? I don't see any SQL which I think would require one version of SQL Server over the other. Could there be problems with the ODBC drivers/DSNs on your system?

[phineas629]

Hi Marto,

Does it have anything to do with the connection using WIN32::ODBC;? Should I consider connecting to through the DBI module instead? The programmer is no longer around and I'm just stuck with this code.

thanks

[marto]

Please consider answering the questions I asked regards the code.

[phineas629]

"So are you currently running SQL server 2005? Does this code actually work as you expect it to? Have you considered asking the programmer who wrote this for an explanation of this? I don't see any SQL which I think would require one version of SQL Server over the other. Could there be problems with the ODBC drivers/DSNs on your system?"

The original DB resides on a 2005 server. I have to copy the DB from 2005 and insert it to a 2008r2 server. Then I export the DB from 2008r2 to the 2000 server so I can run the perl script. After the perl script runs then I bring the DB back to its orginal 2005 server.

The perl script works but the process takes a while when I'm working with so many databases. I assume there has got to be an easier solution.

The programmer is no longer around.

I have a feeling it is related to the ODBC drivers/DSNs on my system. But I don't know much about how ODBC works beyond me being able to use it to connect to DBs.

Once again thanks!