[unixODBC-support] [ISQL]ERROR: Could not SQLConnect

Nick Gorham nick at lurcher.org
Thu Jan 30 08:12:24 GMT 2014


On 30/01/14 07:52, Anglister, Shlomo wrote:
> As MS traces are extremely elaborated but provide no clues I can only offer hints:
> 1) Can it be a license issue? MS are usually requesting a signature on a license agreement before running, the license file should reside exactly where they define.
> 2) What kind of authentication are you using? SQL or Windows?
>      If it is windows, sometimes there is a domain used so your user name will be <domain name>\<user name>
>      There is also the "Trusted_Connection=True" which not to be specified as MS has different connection security protocols.
> 3) Do you have special characters in your password? Sometimes those are interpreted in Linux shell or wrongly interpreted  on the SQL server (especially '%' character)
>
>
> -----Original Message-----
> From: unixodbc-support-bounces at mailman.unixodbc.org [mailto:unixodbc-support-bounces at mailman.unixodbc.org] On Behalf Of ysri
> Sent: Wednesday, January 29, 2014 21:23
> To: unixodbc-support at mailman.unixodbc.org
> Subject: [unixODBC-support] [ISQL]ERROR: Could not SQLConnect

The ini file has a DSN of

my_mssqlserver

By the trace shows you connecting to

SQLSERVERA


Try

isql -v my_mssqlserver user pass

-- 
Nick



More information about the unixODBC-support mailing list