"Warren Read" <wread@online.microsoft.com> wrote in message
news:7xqDrCn3FHA.3220@TK2MSFTNGXA01.phx.gbl...
> This is pretty weird. The retcode should be '0' regardless of the OS.
>
> Also, I don't see you returning a value at all. Your function just
> executes
> a 'return;' . Are you sure it's the ODBC call that's affecting your return
> value?
>
>
> --------------------
> | From: "Rob Dob" <robdob20012002@yahoo.com>
> | Subject: NewBie, SQLAllocHandle only works on Win2003Server.
> | Date: Sun, 30 Oct 2005 17:35:40 -0500
> | Lines: 27
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
> | X-RFC2646: Format=Flowed; Original
> | Message-ID: <Oni6DJa3FHA.2196@tk2msftngp13.phx.gbl>
> | Newsgroups:
> microsoft.public.sqlserver.msde,microsoft.public.sqlserver.odbc,microsoft.pu
> blic.vc.mfc
> | NNTP-Posting-Host: hse-ottawa-ppp238729.sympatico.ca 64.230.82.20
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.odbc:2966
> microsoft.public.vc.mfc:44999 microsoft.public.sqlserver.msde:8861
> | X-Tomcat-NG: microsoft.public.sqlserver.odbc
> |
> | Hi,
> |
> | I just did a test, this code returns 1 on a windows2003 Server system,
> and
> | my import works fine, however if I run this same code on a WinXP, Pro
> or
> XP
> | Media it then returns 1 and the import does NOT work...
> |
> | Please any suggestions would be creatly appreciated..
> |
> | where should I start looking.?
> |
> | retcode = 1 when running on Server 2003
> | retcode = 0 when running on WinXP Pro or WinXP Media
> |
> |
> | SQLHENV henv = SQL_NULL_HENV;
> | HDBC hdbc1 = SQL_NULL_HDBC;
> | RETCODE retcode;
> | SDWORD cRows;
> | // Allocate the ODBC environment and save handle.
> | retcode = SQLAllocHandle (SQL_HANDLE_ENV, SQL_NULL_HANDLE, &henv);
> | if ( (retcode != SUCCEED) )
> | return;
> | }
> |
> |
> |
> |
> |
>