Can connect to SQL Server through tsql but not from the bsqldb

5 votes

1 answer

9897 views

freetds

                          After installing FreeTDS I was able to connect to our SQL Server using tsql but not yet through bsqldb. 
With bsqldb it's trying to connect to the master even though the db was specified to  testDB.

serverName is setup in /etc/freetds.conf

    [serverName]
            host = database.windows.net
            port = 1433
            tds version = 8.0

Using tsql:

    [gpadmin@mdw ~]$ /usr/bin/tsql -S serverName -U user -D testDB -P password

works fine

With bsqldb it's trying to connect to the master even though the db was specified to  testDB.

    [gpadmin@mdw ~]$ /usr/bin/bsqldb -U user -P password -S serverName \
                                     -D testDB -i tag.sql -o tag.csv
    
    Msg 4060, Level 11, State 1
    Server 'fj5j2jtt5k', Line 1
            Cannot open database "master" requested by the login. The login failed.
    bsqldb: error: severity 11 > 10, exiting

Asked by dhew (51 rep)

Feb 28, 2013, 04:25 AM
Last activity: Nov 3, 2014, 01:51 AM

Can connect to SQL Server through tsql but not from the bsqldb

Related Questions