Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

Re: perl and switching between different version servers

by marto (Bishop)
on Nov 21, 2012 at 15:53 UTC ( #1004944=note: print w/ replies, xml ) Need Help??


in reply to perl and switching between different version servers

"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?


Comment on Re: perl and switching between different version servers
Re^2: perl and switching between different version servers
by phineas629 (Novice) on Dec 05, 2012 at 21:18 UTC

    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

      Please consider answering the questions I asked regards the code.

        "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!

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1004944]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (6)
As of 2014-12-26 01:47 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (163 votes), past polls