RE: NewBie, SQLAllocHandle only works on Win2003Server.

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@xxxxxxxxx>
| 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@xxxxxxxxxxxxxxxxxxxx>
| 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;
| }
|
|
|
|
|

.

Relevant Pages

  • Re: get the return code when piping something to a python script?
    ... I don't know how it is on WinXP, but in UNIX you IMHO cannot easily ... get the retcode of the peer _if_ the pipe was created by your common ... Only the parent knows retcodes of its children. ... You can communicate the status over the pipe. ...
    (comp.lang.python)
  • Re: Considering upgrade from WiXP to Pro
    ... WinXP Home ... WinXP Media Center Edition (which is a superset of WinXP Pro) ...
    (microsoft.public.windowsxp.newusers)
  • Can WinMC Join to a SBS2k Domain?
    ... We currently only use WinXP Pro clients in our Small Business Server ... The real issue here isn't the client, ... good price pre-installed with WinXP Media Center...I DO NOT want to find out ...
    (microsoft.public.windows.mediacenter)
  • Re: Whats the difference between WinXP and WinXP-Pro?
    ... WinXP Home ... WinXP Media Center Edition ... WinXP TabletPC Edition ... Which of the other four are you trying to compare with WinXP Pro? ...
    (microsoft.public.windowsxp.general)
Loading