Re: FreeTDS Digest, Vol 119, Issue 6

Hi,

please can any one help me to get out of this problem


On Thu, Dec 13, 2012 at 10:30 PM, <[email protected]> wrote:

> Send FreeTDS mailing list submissions to
>         [email protected]
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         http://lists.ibiblio.org/mailman/listinfo/freetds
> or, via email, send a message with subject or body 'help' to
>         [email protected]
>
> You can reach the person managing the list at
>         [email protected]
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of FreeTDS digest..."
>
>
> Today's Topics:
>
>    1. [unixODBC][FreeTDS][SQL Server]Unable to connect to data
>       source (SQL-08001) (Sankar G)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Thu, 13 Dec 2012 18:34:49 +0530
> From: Sankar G <[email protected]>
> Subject: [freetds] [unixODBC][FreeTDS][SQL Server]Unable to connect to
>         data    source (SQL-08001)
> To: [email protected]
> Message-ID:
>         <CAJkiSB4+QTikp=
> [email protected]>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hi
>
> I am getting some errors when i am trying to connect MS SqlServer using
> FreeTDS,
> unixODBC and DBD::ODBC.
>
> My odbcinst.ini file
>
> [FreeTDS]
> Description = TDS driver (Sysbase/MS SQL)
> Driver = /usr/local/freetds/lib/libtdsodbc.so
> Setup = /usr/local/freetds/lib/libtdsodbc.so UsageCount = 1
>
> My odbc.ini file
>
> [SERVER]
> Driver = FreeTDS
> Description = ODBC connection via FreeTDS
> ServerName = SERVER
>
> My freetds.conf file
>
> # A typical Microsoft server
> [SERVER]
> host = xxx.xxx.xxx.xxx
> port = 1433
> tds version = 7.2
>
> my perl file
>
> $ perl DB_Test.pl
>
>
> $dsn = "dbi:ODBC:DRIVER={FreeTDS};Server=$server;database=$database;";
> $dbh = DBI->connect("$dsn","$user","$password") or die "\n$DBI::errstr\n";
>
>
> Error
>
>
> DBI
>
> connect('DRIVER={FreeTDS};Server=xxx.xxx.xxx.xxx;database=xxxxx;','xxxxxx',...)
> failed: [unixODBC][FreeTDS][SQL Server]Unable to connect to data source
> (SQL-08001) at DB_Test.pl line 14
>
> [unixODBC][FreeTDS][SQL Server]Unable to connect to data source (SQL-08001)
>
>
>
> when i try to connect using osql i am getting this error
>
> $ sudo TDSVER=7.2 osql -S SERVER -U username -P password
> checking shared odbc libraries linked to isql for default directories...
>     trying /usr ... no
>     trying /loc ... no
>     trying /tmp/sql.log ... no
>     trying /home ... no
>     trying /.odbc.ini ... no
>     trying /usr/local/etc ... OK
> checking odbc.ini files
>     reading /home/perlzuser/.odbc.ini
> [SERVER] not found in /home/perlzuser/.odbc.ini
>     reading /usr/local/etc/odbc.ini
> [SERVER] found in /usr/local/etc/odbc.ini
> found this section:
>     [SERVER]
>     Driver = FreeTDS
>     Description = ODBC connection via FreeTDS
>     ServerName = SERVER
>
> looking for driver for DSN [SERVER] in /usr/local/etc/odbc.ini
>   found driver line: "    Driver = FreeTDS"
>   driver "FreeTDS" found for [SERVER] in odbc.ini
> found driver named "FreeTDS"
> "FreeTDS" is not an executable file
> looking for entry named [FreeTDS] in /usr/local/etc/odbcinst.ini
>   found driver line: "    Driver = /usr/local/freetds/lib/libtdsodbc.so"
>   found driver /usr/local/freetds/lib/libtdsodbc.so for [FreeTDS] in
> odbcinst.ini
> /usr/local/freetds/lib/libtdsodbc.so is an executable file
> Using ODBC-Combined strategy
> DSN [SERVER] has servername "" (from /usr/local/etc/odbc.ini)
>
> Please I need help to connect MSSQL Server from my perl program using
> FreeTDS
> and DBD::ODBC
>
>
> Thanks
>
>
> ------------------------------
>
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
>
> End of FreeTDS Digest, Vol 119, Issue 6
> ***************************************
>