Path: csiph.com!news.mixmin.net!eternal-september.org!reader01.eternal-september.org!.POSTED!not-for-mail
From: Erland Sommarskog <esquel@sommarskog.se>
Newsgroups: comp.databases.ms-sqlserver
Subject: Re: Creating a table in spite of browse mode
Date: Tue, 18 Oct 2022 20:59:46 +0200
Organization: Erland Sommarskog
Lines: 20
Message-ID: <XnsAF34D5961846BYazorman@127.0.0.1>
References: <20221018150920.2c192912e8cb7da6002b965f@g{oogle}mail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: 8bit
Injection-Info: reader01.eternal-september.org; posting-host="f209361df855ff6156704681a0623c04"; logging-data="3998820"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX19ivBaiZj+7u/CwTkT+cGLn"
User-Agent: Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32)
Cancel-Lock: sha1:RsqSJ2ujnJ7lLsI9g6ExqDVp0Go=
Xref: csiph.com comp.databases.ms-sqlserver:2162

Anton Shepelev (anton.txt@g{oogle}mail.com) writes:
> The application I am working with quietly imposes some
> limitation on its connection to MSSQL that will not let me
> create a temporary table. Below are some of my attempts with
> the corresponding results:
> 
>   SQL: CREATE TABLE #TEST(a INT)
>   ERR: CREATE TABLE is unsupported

Is that the exact error message?
 
>   SQL: BEGIN CREATE TABLE #TEST(a INT) END
>   RES: No error, but no table is created.
> 
>   SQL: SELECT 1 a INTO #TEST
>   ERR: Browse mode cannot be used with INSERT,
>        SELECT INTO, or UPDATE statements.
> 

So what old and ugly client API is this?