Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical

Re: issue with DBI and MS SQL SERVER

by GotToBTru (Prior)
on Sep 15, 2014 at 14:55 UTC ( #1100611=note: print w/replies, xml ) Need Help??

in reply to issue with DBI and MS SQL SERVER

Perhaps Re: connect string for sybase might be of help here? Super Search is an excellent resource.

1 Peter 4:10

Replies are listed 'Best First'.
Re^2: issue with DBI and MS SQL SERVER
by DanBev (Scribe) on Sep 15, 2014 at 15:01 UTC
    Thank you for the reply. I've resolved my issue simply because I was working on wrong freetds.conf file
      Could you add another comment that explains the whole issue a bit more clearly, now that you completely understand it and have solved it? Writing for the next poor schleb who is banging their head against this ... and so that the rest of us know more about this slightly-arcane setup?
        yes, of course. The configuration file is in /usr/local/etc/freetds.conf (depends by version anyway). It's recommended to add an entry for your database connection, such this
        [MY_DB_NAME] host = port = 1433 tds version = 7.0 database = my_database user = my_user password = my_password
        You can configure all of this options or less. In MY_DB_NAME you create an alias for the configuration; in "host" you enter the db's ip and in "port" the used port (usually 1433 for MS SQL). In "database", if you need, you enter the start database, and you can also add values for "user" and "password". I've seen in various forums that the best working tds's version for MS SQL is 7.0, so it's recommended add the "tds version" value with "7.0" such in the example. After, you can recall this connection configuration simply by the alias, like this /usr/local/freetds/bin/tsql -S MY_DB_NAME. If you're missing the "user" and "password" values nevermind, you can always launch tsql in this way /usr/local/freetds/bin/tsql -S MY_DB_NAME -U my_user, and so on. I hope it's helpful.

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (3)
As of 2021-03-07 03:33 GMT
Find Nodes?
    Voting Booth?
    My favorite kind of desktop background is:

    Results (119 votes). Check out past polls.