[unixODBC-support] isql: unable to create temp tables
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,
More information about the unixODBC-support