Re: ODBC Connection Problem from Linux to SQL Server Daabase

Hi,

On Fri, Mar 11, 2016 at 4:58 AM, Nick Gorham <[email protected]> wrote:
> On 10/03/16 19:06, Funny,Solomon wrote:
>
> Our Unix Admin installed the SQL Server ODBC Drivers for Linux on our Linux
> server, but when I attempt to connect to a SQL Server, I receive the
> following error message:

Which driver do you use? Is it freeTDS or something else?
Try to install and test with the freeTDS driver.

Thank you.

>
>
>
> [IM004][unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV
> failed
>
> [ISQL]ERROR: Could not SQLConnect
>
>
>
> I did successfully test the SQL Server authenticated account and password, I
> am trying to connect to within SQL server
>
> When I googled the error, it indicated either the ODBC drivers are not
> mentioned properly, or environment variable are not set ODBCSYSINI ODBCINI.
>
>
>
> I performed the command env from the command line and the environment
> variables were set ODBCSYSINI ODBCINI:
>
>
>
> ODBCINI=/etc/odbc.ini
>
> ODBCSYSINI=/etc
>
>
>
> I checked the data source and driver configurations set by the Unix Admin,
> and they looked correct:
>
>
>
> /etc/odbc.ini
>
> [TITAN]
>
> Description=SQL Server ODBC Driver
>
> Driver=SQL Server Native Client 11.0
>
> Server=nts-entdbd1
>
> Port=1433
>
> Database=prod01
>
>
>
> /etc/odbcinst.ini
>
> [SQL Server Native Client 11.0]
>
> Description=Microsoft SQL Server ODBC Driver V1.0 for Linux
>
> Driver=/usr/lib64/libodbc.so.1.0.0
>
> Threading=1
>
> UsageCount=1
>
> Trace=Yes
>
>
> That driver looks like the driver manager, I would expect something like:
>
> Driver=/opt/microsoft/msodbcsql/lib64/libmsodbcsql-11.0.so.0.0
>
> BTW, you need to join the mailing list to post, its to prevent spam.
>
> --
> NIck
>
> _______________________________________________
> unixODBC-dev mailing list
> [email protected]
> http://mailman.unixodbc.org/mailman/listinfo/unixodbc-dev
>
_______________________________________________
unixODBC-dev mailing list
[email protected]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-dev