Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

Re: DBI and FreeTDS Named Instances

by dreadpiratepeter (Priest)
on Aug 10, 2009 at 23:59 UTC ( #787445=note: print w/ replies, xml ) Need Help??


in reply to DBI and FreeTDS Named Instances

If you are running on windows, you don't need to pass the username and password fields, they should get picked up automatically from your login.



-pete
"Worry is like a rocking chair. It gives you something to do, but it doesn't get you anywhere."


Comment on Re: DBI and FreeTDS Named Instances
Re^2: DBI and FreeTDS Named Instances
by tux402 (Acolyte) on Aug 11, 2009 at 02:30 UTC
    Yes that's true, and that works fine, but we are trying to pull from a Linux server. This makes the connection that much trickier.
      in that case the issue is going to be a configuration issue with freetds. It took me forever to get it right. remember that you have to configure the servers in freetds.conf and the dbs in the .odbc.conf file in the home directory of the user running the code.


      -pete
      "Worry is like a rocking chair. It gives you something to do, but it doesn't get you anywhere."
        Ok, I think I understand the config files. It's unfortunate that this has become less portable because of that. Would you happen to have an example dsn that uses the config file? Or does freetds automatically look at the file if the dsn is missing information?
        ^ oops, didn't log in before I posted.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (5)
As of 2014-08-22 01:16 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (145 votes), past polls