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

Gorman, Greg Greg.Gorman at mercer.com
Wed Jan 11 17:52:16 GMT 2012


Nick,

Thanks again for the reply.

I'll see about getting 2.3.2pre installed, but as it's a corporate server, and I'm a contract developer with few privileges here, I'm not optimistic.

If I'm able to get 2.3.2pre installed and tested, I'll be sure to let you (and this list) know the results.

Greg

-----Original Message-----
From: unixodbc-support-bounces at mailman.unixodbc.org [mailto:unixodbc-support-bounces at mailman.unixodbc.org] On Behalf Of Nick Gorham
Sent: Wednesday, January 11, 2012 12:43 PM
To: Support for the unixODBC project
Subject: Re: [unixODBC-support] isql: unable to create temp tables

On 11/01/12 17:38, Gorman, Greg wrote:
> One further note: it does not return the same error as if it were a privilege error. For example, if I try to create a non-temporary table, I get a "permission denied" error, as follows:
>
> SQL>  create table test (a integer)
> [42000][Microsoft][SQL Server Native Client 11.0][SQL Server]CREATE TABLE permission denied in database 'dev_db'.
> [ISQL]ERROR: Could not SQLExecute
>
> -----Original Message-----
> From: unixodbc-support-bounces at mailman.unixodbc.org
> [mailto:unixodbc-support-bounces at mailman.unixodbc.org] On Behalf Of
> Gorman, Greg
> Sent: Wednesday, January 11, 2012 11:52 AM
> To: Support for the unixODBC project
> Subject: Re: [unixODBC-support] isql: unable to create temp tables
>
> Hi Nick,
>
> Thanks for the reply. I tried that, but isql just dumps me out, when I try to use the -e switch, as below:

Somehow the -e option went walkabout. Its back in the code for 2.3.2pre now if you want to try that, but beyond that, its a driver issue, not sure what else to suggest.

--
Nick
_______________________________________________
unixODBC-support mailing list
unixODBC-support at mailman.unixodbc.org
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support

This e-mail and any attachments may be confidential, proprietary or legally privileged. Any review, use, disclosure, distribution or copying of this e-mail is prohibited except by or on behalf of the intended recipient. If you received this message in error or are not the intended recipient, please delete or destroy the e-mail message and any attachments or copies and notify the sender of the erroneous delivery by return e-mail. To the extent that this message or its attachments were sent without encryption, we can not guarantee that the contents have not been changed or tampered with. Any advice expressed in this message is being delivered to you solely for your use in connection with the matters addressed herein and may not be used for any other purpose without our prior written consent.

The information contained in this document (including any attachments) is not intended by Mercer to be used, and it cannot be used, for the purpose of avoiding penalties under the Internal Revenue Code that may be imposed on the taxpayer.


More information about the unixODBC-support mailing list