[freetds] Problems Connecting Debian --> MSSQL through odbc

Jaap van Arragon j.vanarragon at lukkien.com
Tue Jul 14 15:50:48 EDT 2009


I've runned the script and here is the output:

SERVER:~# ./osqlscript.sh -S TEST -U admin -P pass
checking shared odbc libraries linked to isql for default directories...
strings: '': No such file
osqlscript.sh: problem: no potential directory strings in "/usr/bin/isql"
osqlscript.sh: advice: use "osql -I DIR" where DIR unixODBC\'s install
prefix e.g. /usr/local
isql strings are:
+ /lib/ld-linux.so.2
checking odbc.ini files
    reading "/root/.odbc.ini"
[TEST] found in "/root/.odbc.ini"
found this section:
    [TEST]
    Driver          = FreeTDS
    Description             = A good description of your DB
    Trace           = Yes
    Server          = [10.10.10.51]
    Port            = 1433
    TDS_Version     = 7.0
    
looking for driver for DSN [TEST]
driver line incomplete for [TEST] in .odbc.ini
looking for driver for DSN [default]
osqlscript.sh: error: no driver found for [TEST] in .odbc.ini

It looks like it check /root/.odbc.ini and I thought is was checking
/etc/odbc.ini

What can you read from above output?


On 7/14/09 6:26 PM, "jklowden at schemamania.org" <jklowden at schemamania.org>
wrote:

> On Tue, Jul 14, 2009 at 06:09:34PM +0200, Jaap van Arragon wrote:
>> Osql reports:
>> 
>> SERVER:# osql -S TEST -U admin -P pass
>> osql: error: no potential directory strings in "/usr/bin/isql"
>> isql strings are:
>> + /lib/ld-linux.so.2
> 
> Download the latest version from
> 
> http://freetds.cvs.sourceforge.net/viewvc/*checkout*/freetds/freetds/src/apps/
> osql?revision=1.8
> 
> It's just a shell script.  Put it wherever you want.  It won't interfere with
> the rest of you installation.  (See also the comment on line 49 if you're
> curious.) 
> 
> I wrote osql to help people diagnose local setup errors.  If it doesn't work
> for you, let's change it so that it does.
> 
>> TDSDUMP: nothing but succesfull results when I connect through isql nothing
>> is being written in the log file.
> 
> When you have no output from TDSDUMP, that means no connection was attempted.
> The driver was not asked to make a connection.  Usually that's because of a
> local setup mistake.
> 
>> Odbc.ini:
>> 
>> [TEST]
>> Driver          = FreeTDS
>> Description             = A good description of your DB
>> Trace           = Yes
>> Server          = [IP ADDRESS]
>> Port            = 1433
> ...
>> TDS_Version=7.0
> ...
>> 4. how can I check this point? Driver = FreeTDS
> 
> In (I think) /etc/odbcinst.ini there should be a FreeTDS section referencing
> the libtdsodbc.so driver.  osql checks for this.
> 
> I assume the above refers to /etc/odbc.ini?  I'm guessing that's the right
> directory based on what you show.  (osql checks that, too!)  ;-)
> 
> HTH.
> 
> --jkl
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds




More information about the FreeTDS mailing list