Re: Struggling to connect to Sybase

Jean Jordaan <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
Hi there

I can now successfully connect using:
$ isql -v FinanceDB user pass

I've fixed up the Driver configuration as freddy77 pointed out.
I've also turned on debugging by adding a section to odbcinst.ini:

"""
[ODBC]
TraceFile=/.../sql.log
Trace=Yes
"""

However if I don't specify the credentials on the commandline, it fails.

The log shows:

"""
                Entry:
                        Connection = 0x8070130
                        Server Name = [FinanceDB][length = 9
(SQL_NTS)]
                        User Name = [NULL]
                        Authentication = [NULL]
"""

The credentials are in the config file:

> pims@dweb66:~$ cat odbc.ini
> [FinanceDB]
[...]
> User=user
> Password=pass

Am I using the right keys?

-- 
jean                                              . .. .... //\\\oo///\\
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.