[unixODBC-support] [S1000][DataDirect][ODBC SQL Server Driver]

Aistis Jokubauskas aistis at neurotechnology.com
Wed Nov 20 10:48:54 GMT 2013


can you show your odbc dsn settings?

On 20/11/13 11:59, Fahad Ali wrote:
> What shall I do then ? Please help.
>
>
> On Wed, Nov 20, 2013 at 3:12 PM, Nick Gorham <nick at lurcher.org 
> <mailto:nick at lurcher.org>> wrote:
>
>     On 20/11/13 09:17, Fahad Ali wrote:
>>     Hi,
>>
>>     I have a Microsoft sql server installed on windows 2008 R2
>>     server. I am trying to connect to sql server from linux machine.
>>     I have installed the unixODBC manager and driver.
>>
>>     I am able to connect and see the below output
>>     [root at MUMLPBMAMTDV001 config]# isql -v MOMDB MOMDBUSER Pbcms at 1234
>>     +---------------------------------------+
>>     | Connected!                        |
>>     |                         |
>>     | sql-statement                         |
>>     | help [tablename]                      |
>>     | quit                        |
>>     |                         |
>>     +---------------------------------------+
>>
>>     After that, it is showing me error whenever I am trying to run
>>     any query,
>>
>>     [S1000][DataDirect][ODBC SQL Server Driver]@Ô¿
>>     [S1000][DataDirect][ODBC SQL Server Driver]
>>     [ISQL]ERROR: Could not SQLPrepare
>
>     Hi,
>
>     You may have installed unixODBC but that error indicates that you
>     are ending up with the Data Direct driver. I have no idea how well
>     that works with a open driver manager.
>
>     -- 
>     Nick
>
>     _______________________________________________
>     unixODBC-support mailing list
>     unixODBC-support at mailman.unixodbc.org
>     <mailto:unixODBC-support at mailman.unixodbc.org>
>     http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
>
>
>
>
> -- 
> *Thanks & Regards,
> Fahad Ali*
> *Mob: +91 9535 086 088*
> E-mail: fahad01hbti at gmail.com <mailto:fahad01hbti at gmail.com>
>
>
>
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support at mailman.unixodbc.org
> http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support


-- 
Have a nice day,
Aistis Jokubauskas

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20131120/933a9b04/attachment-0001.html>


More information about the unixODBC-support mailing list