[unixODBC-support] basic config questions

Nick Gorham nick at lurcher.org
Sat Mar 28 01:04:17 GMT 2009


Rick Schumeyer wrote:
> I think I've made some progress, but I'm still not there.  The big
> change was removing the spaces or tabs at the beginning of each line.
>   

That makes me think its not using unixODBC to read the file, but its own 
version.
> My current config values are below.
>
> Question 1: does the "Server" value in odbc.ini  refer to the machine
> on which the database resides, or does it refer to an entry in
> freetds.conf?  Because I've tried both ways, and neither works,
> although I get slightly different error messages.
>
> Question 2: should I specify the username/password in odbc.ini?  I'm
> not positive I had the correct syntax for that.  (I tried including
> that, but that didn't seem to help.)
>
> My error message is now ("Server" refers to entry in freetds.conf):
> [rick at buster etc]$ isql -v sqlserver my_user my_password
> [S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
> [ISQL]ERROR: Could not SQLConnect
>
> if I change "Server" to be the network name of the SQL Server machine:
> [rick at buster etc]$ isql -v sqlserver
> [S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
> [08S01][unixODBC][FreeTDS][SQL Server]Unable to connect: Adaptive
> Server is unavailable or does not exist
> [ISQL]ERROR: Could not SQLConnect
>
>   
Its best now to post this on the freebsd lists, you have got past 
unixODBC to the driver. Unless there are any reading this that know 
freetds better?

-- 
Nick


More information about the unixODBC-support mailing list