Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask

Re^6: DBI and FreeTDS Named Instances

by tux402 (Acolyte)
on Aug 11, 2009 at 17:28 UTC ( #787718=note: print w/replies, xml ) Need Help??

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

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 = Port = 4433 Database = databasename [Default] Driver = FreeTDS freetds.conf [VOIP] host = instance = CRSSQL port = 4433 client charset = UTF-8 tds version = 8.0 odbcinst.ini [FreeTDS] Description = FreeTDS Driver Driver = /usr/local/lib/ Setup = /usr/lib/odbc/

Does anything look off?

Replies are listed 'Best First'.
Re^7: DBI and FreeTDS Named Instances
by dreadpiratepeter (Priest) on Aug 11, 2009 at 20:42 UTC
    Mine (which is working) has ServerName not Server in the odbc.ini, Also it it .odbc.ini on mine

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

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://787718]
[LanX]: I think it's a flag problem ... I'll produce a reprodocable example for SOPW
[Corion]: "flag problem" to me sounds like "contains UTF-8 bytes but was never properly decoded to an UTF-8 string"
[LanX]: not my code ...
[choroba]: yeah, sounds like one of the strings is not flagged as UTF-8
[choroba]: which usually means its input wasn't handled correctly
[Corion]: choroba: Yeah, I think that would be the good solution
[LanX]: I suspect the first string which comes from the DB ...
[LanX]: ... but this part is already in production for a year now
[Corion]: LanX: The "good" approach here would be to use the appropriate DBI parameters to make the driver decode strings properly. But that will have a ripple-on effect of messing up all the places where manual decoding happens ;)
[LanX]: which means albeit being broken UTF8 it'll be handled correctly

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (11)
As of 2017-01-16 13:55 GMT
Find Nodes?
    Voting Booth?
    Do you watch meteor showers?

    Results (150 votes). Check out past polls.