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;
}

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.s qlserver.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!tk2msft ngp13.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;
| }
|
|
|
|
|

Hi,

actually it turned out to be a wrong dll on the system, SQLSrv32.dll

thanks.

"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.s qlserver.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!tk2msft ngp13.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;
> | }
> |
> |
> |
> |
> |
>