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

Fahad Ali fahad01hbti at gmail.com
Wed Nov 20 10:58:45 GMT 2013


[MOMDB]
Driver=/sasinst/sqlodbc/lib/S0msss22.so
Description=DataDirect 5.2 SQL Server Wire Protocol
Address=10.32.161.205,1433
AnsiNPW=Yes
Database=MOMPRD
LogonID=userid
Password=
QEWSD=41511
QuotedId=yes




On Wed, Nov 20, 2013 at 4:18 PM, Aistis Jokubauskas <
aistis at neurotechnology.com> wrote:

>  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> 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
>> http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
>>
>>
>
>
>  --
>
> *Thanks & Regards, Fahad Ali*
> *Mob: +91 9535 086 088*
> E-mail: fahad01hbti at gmail.com
>
>
>
> _______________________________________________
> unixODBC-support mailing listunixODBC-support at mailman.unixodbc.orghttp://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
>
>
>
> --
> Have a nice day,
> Aistis Jokubauskas
>
>
> _______________________________________________
> unixODBC-support mailing list
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20131120/195dc876/attachment.html>


More information about the unixODBC-support mailing list