[unixODBC-support] isql: unable to create temp tables

Nick Gorham nick at lurcher.org
Wed Jan 11 16:45:08 GMT 2012


On 11/01/12 16:26, Gorman, Greg wrote:
> Hello all,
>
> I am using isql version 2.3.0, under Red Hat Enterprise Linux Server release 5.3 (Tikanga), to connect to a MS SQL Server db.
>
> I can successfully connect to the database using my username and password.
> I can successfully run select statements just fine.
> I *cannot create a temp table*, though, even though my user id has permission to do so.
>
> For comparison, I *can*, using the same credentials, create a temp table using each of the following:
>          the sqlcmd utility,
>          the tsql utility, and
>          the SQL Server Management Studio (from Windows).
>
> Any guidance or help would be appreciated. Thank you in advance.

Its probbaly because isql uses SQLPrepare and SQLExecute, there are 
effects of this with SQL Server. Try

isql -e dsn user pass

To use SQLExecDirect instead and see if that makes any difference,

-- 
Nick


More information about the unixODBC-support mailing list