Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Problems Connecting Debian --> MSSQL through odbc
  • Date: Fri, 17 Jul 2009 11:55:24 +0200

Well...now you should issue sql server command, not MySQL ones...

Try "sp_tables" or "select * from sysobjects" or "select @@version"

freddy77


2009/7/17 Jaap van Arragon <j.vanarragon AT lukkien.com>:
> I am connected to ISQL now!
>
> Everything I do ends up in a error:
>
> SERVER:~# isql TEST admin pass
> +---------------------------------------+
> | Connected!                            |
> |                                       |
> | sql-statement                         |
> | help [tablename]                      |
> | quit                                  |
> |                                       |
> +---------------------------------------+
> SQL>
> SQL> SHOW
> [ISQL]ERROR: Could not SQLExecute
> SQL> SHOW TABLES;
> [ISQL]ERROR: Could not SQLExecute
> SQL> select * from table2222
> [ISQL]ERROR: Could not SQLPrepare
>
> How can I verify my connection by looking at the available tables?
>
>
>
> On 7/16/09 5:52 PM, "Frediano Ziglio" <freddy77 AT gmail.com> wrote:
>
>>
>> Much clearer !!!
>>
>> you should replace [10.10.10.51] with only 10.10.10.51 (without square
>> brackets)!
>>
>> freddy77
>>
>>
>> Il giorno gio, 16/07/2009 alle 17.33 +0200, Jaap van Arragon ha scritto:
>>> hereby:
>>>
>>> SERVER:~# TDSDUMP=stderr isql TEST admin pass
>>> log.c:190:Starting log file for FreeTDS 0.82
>>>     on 2009-07-16 17:33:20 with debug flags 0x4fff.
>>> iconv.c:197:names for ISO-8859-1: ISO-8859-1
>>> iconv.c:197:names for UTF-8: UTF-8
>>> iconv.c:197:names for UCS-2LE: UCS-2LE
>>> iconv.c:197:names for UCS-2BE: UCS-2BE
>>> iconv.c:363:iconv to convert client-side data to the "UTF-8" character set
>>> iconv.c:516:tds_iconv_info_init: converting "UTF-8"->"UCS-2LE"
>>> iconv.c:516:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
>>> login.c:405:IP address pointer is empty
>>> login.c:407:Server [10.10.10.51] not found!
>>> mem.c:563:tds_free_all_results()
>>> error.c:574:SQLError((nil), 0x80651e0, (nil), 0xbf8df50e, 0xbf8df514,
>>> 0xbf8df034, 513, 0xbf8df51e)
>>> error.c:510:_SQLGetDiagRec(2, 0x80651e0, 1, 0xbf8df50e, 0xbf8df514,
>>> 0xbf8df034, 513, 0xbf8df51e)
>>> error.c:574:SQLError((nil), 0x80651e0, (nil), 0xbf8df50e, 0xbf8df514,
>>> 0xbf8df034, 513, 0xbf8df51e)
>>> error.c:510:_SQLGetDiagRec(2, 0x80651e0, 1, 0xbf8df50e, 0xbf8df514,
>>> 0xbf8df034, 513, 0xbf8df51e)
>>> odbc.c:3734:SQLFreeConnect(0x80651e0)
>>> odbc.c:3706:_SQLFreeConnect(0x80651e0)
>>> odbc.c:3757:SQLFreeEnv(0x80645e8)
>>> odbc.c:3744:_SQLFreeEnv(0x80645e8)
>>> [ISQL]ERROR: Could not SQLConnect
>>>
>>>
>>>
>>> On 7/16/09 5:31 PM, "Frediano Ziglio" <freddy77 AT gmail.com> wrote:
>>>
>>>> Could you also try
>>>>
>>>> TDSDUMP=stderr isql TEST admin pass
>>>>
>>>> where TEST is your DSN, admin your account and pass your password ??
>>>>
>>>> freddy77
>>>>
>>>>
>>>> Il giorno gio, 16/07/2009 alle 17.17 +0200, Jaap van Arragon ha scritto:
>>>>> Thank you.
>>>>>
>>>>> SERVER:~# TDSDUMPCONFIG=stderr TDSDUMP=stderr \
>>>>>> sh -x ./osqlscript.sh -S TEST -U admin -P pass
>>>>> ++ basename ./osqlscript.sh
>>>>> + USAGE='Syntax: osqlscript.sh -S server -U user -P password'
>>>>> + getopts I:S:U:P: OPTION
>>>>> + case ${OPTION} in
>>>>> + DSN=TEST
>>>>> + getopts I:S:U:P: OPTION
>>>>> + case ${OPTION} in
>>>>> + USERNAME=admin
>>>>> + getopts I:S:U:P: OPTION
>>>>> + case ${OPTION} in
>>>>> + PASSWORD=pass
>>>>> + getopts I:S:U:P: OPTION
>>>>> + '[' -z TEST -o -z admin -o -z pass ']'
>>>>> ++ command -v isql
>>>>> + ISQL=/usr/bin/isql
>>>>> + '[' -z /usr/bin/isql ']'
>>>>> ++ strings /usr/bin/isql
>>>>> ++ grep '^/'
>>>>> ++ grep -v elf
>>>>> ++ grep -v '\.so\.'
>>>>> ++ head -1
>>>>> ++ sed 's/lib$/etc/'
>>>>> + ISQL_DIR=
>>>>> ++ basename ./osqlscript.sh
>>>>> + INI_DIRNAME=/tmp/osqlscript.sh.16985
>>>>> + exec
>>>>> + '[' -z '' ']'
>>>>> + echo 'checking shared odbc libraries linked to isql for default
>>>>> directories...'
>>>>> checking shared odbc libraries linked to isql for default directories...
>>>>> + echo
>>>>> + ldd /usr/bin/isql
>>>>> + awk '/[-]lodbc/ {print $3}'
>>>>> + read L
>>>>> + strings ''
>>>>> strings: '': No such file
>>>>> + grep '^/'
>>>>> + grep -v /lib
>>>>> + read D
>>>>> + read L
>>>>> ++ cat /tmp/osqlscript.sh.16985
>>>>> + ODBC_DIR=
>>>>> + rm /tmp/osqlscript.sh.16985
>>>>> + '[' -z '' -a -z '' ']'
>>>>> ++ basename ./osqlscript.sh
>>>>> ++ command -v isql
>>>>> + echo 'osqlscript.sh: problem: no potential directory strings in
>>>>> "/usr/bin/isql"'
>>>>> osqlscript.sh: problem: no potential directory strings in
>>>>> "/usr/bin/isql"
>>>>> ++ basename ./osqlscript.sh
>>>>> + echo 'osqlscript.sh: advice: use "osql -I DIR" where DIR
>>>>> unixODBC\'\''s
>>>>> install prefix e.g. /usr/local'
>>>>> osqlscript.sh: advice: use "osql -I DIR" where DIR unixODBC\'s install
>>>>> prefix e.g. /usr/local
>>>>> + echo 'isql strings are:'
>>>>> isql strings are:
>>>>> + strings /usr/bin/isql
>>>>> + grep '^/'
>>>>> + sed 's/^/+ /'
>>>>> + /lib/ld-linux.so.2
>>>>> + '[' '' ']'
>>>>> + echo 'checking odbc.ini files'
>>>>> checking odbc.ini files
>>>>> + for F in '"${HOME}/.odbc.ini"' '"${ODBC_DIR}/odbc.ini"'
>>>>> ++ dirname /root/.odbc.ini
>>>>> + '[' '!' -d /root ']'
>>>>> + '[' -r /root/.odbc.ini ']'
>>>>> + echo '    reading' '"/root/.odbc.ini"'
>>>>>     reading "/root/.odbc.ini"
>>>>> + grep '[TEST]' /root/.odbc.ini
>>>>> + '[' 0 -eq 0 ']'
>>>>> + echo '[TEST]' found in '"/root/.odbc.ini"'
>>>>> [TEST] found in "/root/.odbc.ini"
>>>>> + ODBC_INI=/root/.odbc.ini
>>>>> + break
>>>>> + '[' -z /root/.odbc.ini ']'
>>>>> + echo found this section:
>>>>> found this section:
>>>>> + SED_CMD='/^\[TEST\]/,/^[[:space:]]*$/ { s/^/    /; p; }'
>>>>> + sed -ne '/^\[TEST\]/,/^[[:space:]]*$/ { s/^/    /; p; }'
>>>>> /root/.odbc.ini
>>>>>     [TEST]
>>>>>     Driver          = FreeTDS
>>>>>     #Driver          = /usr/lib/odbc/libtdsodbc.so
>>>>>     Description             = A good description of your DB
>>>>>     Trace           = Yes
>>>>>     Server          = [10.10.10.51]
>>>>>     Port            = 1433
>>>>>     TDS_Version     = 7.0
>>>>>
>>>>> + for D in '"${DSN}"' ''\''default'\'''
>>>>> + echo 'looking for driver for DSN [TEST]'
>>>>> looking for driver for DSN [TEST]
>>>>> + grep TEST /root/.odbc.ini
>>>>> + '[' 0 -eq 0 ']'
>>>>> + CMD='/^\[TEST\]/,/^[[:space:]]*$/ { s/^/    /; p; }'
>>>>> ++ sed -ne '/^\[TEST\]/,/^[[:space:]]*$/ { s/^/    /; p; }'
>>>>> /root/.odbc.ini
>>>>> ++ grep -Ei '^[[:space:]]*driver[[:space:]]*='
>>>>> + DRIVER_LINE='    Driver          = FreeTDS'
>>>>> + '[' -z '    Driver          = FreeTDS' ']'
>>>>> ++ echo Driver = FreeTDS
>>>>> ++ awk -F = '{print $2}'
>>>>> ++ sed 's/[[:space:]][[:space:]]*//g'
>>>>> + DRIVER=FreeTDS
>>>>> + '[' FreeTDS ']'
>>>>> ++ basename /root/.odbc.ini
>>>>> + echo 'driver "FreeTDS" found for [TEST] in .odbc.ini'
>>>>> driver "FreeTDS" found for [TEST] in .odbc.ini
>>>>> + break
>>>>> + '[' -z FreeTDS ']'
>>>>> + echo found driver named '"FreeTDS"'
>>>>> found driver named "FreeTDS"
>>>>> + '[' '!' -r FreeTDS ']'
>>>>> + DRIVERNAME=FreeTDS
>>>>> + ODBC_INST=/odbcinst.ini
>>>>> + echo 'FreeTDS is not a readable file'
>>>>> FreeTDS is not a readable file
>>>>> + echo 'looking for entry named [FreeTDS] in /odbcinst.ini'
>>>>> looking for entry named [FreeTDS] in /odbcinst.ini
>>>>> + grep FreeTDS /odbcinst.ini
>>>>> grep: /odbcinst.ini: No such file or directory
>>>>> + '[' 2 -ne 0 ']'
>>>>> + '[' 0 -eq 1 ']'
>>>>> + exit 1
>>>>>
>>>>>
>>>>>
>>>>> On 7/16/09 5:10 PM, "Daniel Fazekas" <fdsubs AT t-online.hu> wrote:
>>>>>
>>>>>> On Jul 16, 2009, at 17:07, Jaap van Arragon wrote:
>>>>>>
>>>>>>>> Regarding (B), let's follow Frediano's suggestion:
>>>>>>>>
>>>>>>>> $ TDSDUMPCONFIG=stderr TDSDUMP=stderr \
>>>>>>>> isql -v svr usr pwd
>>>>>>> OPTION 1:
>>>>>>> SERVER:~# TDSDUMPCONFIG=stderr TDSDUMP=stderr
>>>>>>> SERVER:~# isql -v TEST admin pass
>>>>>>
>>>>>> You missed the slash \ at the end of the TDSDUMP line.
>>>>>> This way your enviromental variables are meaningless since they are
>>>>>> not exported.
>>>>>>
>>>>>> _______________________________________________
>>>>>> FreeTDS mailing list
>>>>>> FreeTDS AT lists.ibiblio.org
>>>>>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> FreeTDS mailing list
>>>>> FreeTDS AT lists.ibiblio.org
>>>>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>>>
>>>> _______________________________________________
>>>> FreeTDS mailing list
>>>> FreeTDS AT lists.ibiblio.org
>>>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>>
>>>
>>> _______________________________________________
>>> FreeTDS mailing list
>>> FreeTDS AT lists.ibiblio.org
>>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>
>> _______________________________________________
>> FreeTDS mailing list
>> FreeTDS AT lists.ibiblio.org
>> http://lists.ibiblio.org/mailman/listinfo/freetds
>
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>




Archive powered by MHonArc 2.6.24.

Top of Page