Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

Re^5: DBI and FreeTDS Named Instances

by dreadpiratepeter (Priest)
on Aug 11, 2009 at 16:12 UTC ( #787682=note: print w/ replies, xml ) Need Help??


in reply to Re^4: DBI and FreeTDS Named Instances
in thread DBI and FreeTDS Named Instances

I believe you need to setup the config files regardless of what you pass into the DSN

You need an entry in the freetds.conf for each server and an entry in the .odbc.conf for each database



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


Comment on Re^5: DBI and FreeTDS Named Instances
Re^6: DBI and FreeTDS Named Instances
by tux402 (Acolyte) on Aug 11, 2009 at 17:28 UTC
    Here is a copy of my config files.
    odbc.ini [ODBC Data Sources] VOIP [VOIP] Driver = FreeTDS Description = Connection to the new voip DB Trace = No Server = 127.0.0.1 Port = 4433 Database = databasename [Default] Driver = FreeTDS freetds.conf [VOIP] host = 127.0.0.1 instance = CRSSQL port = 4433 client charset = UTF-8 tds version = 8.0 odbcinst.ini [FreeTDS] Description = FreeTDS Driver Driver = /usr/local/lib/libtdsodbc.so Setup = /usr/lib/odbc/libtdsS.so

    Does anything look off?
      Mine (which is working) has ServerName not Server in the odbc.ini, Also it it .odbc.ini on mine


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

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others wandering the Monastery: (10)
As of 2014-10-02 07:24 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    What is your favourite meta-syntactic variable name?














    Results (49 votes), past polls