ODBC & SQLExecDirect  
Author Message
AndreasDettmer





PostPosted: Thu May 13 00:04:10 CDT 2004 Top

SQL Server Developer >> ODBC & SQLExecDirect

We have some legacy code that nolonger works after we
upgraded to SQL 2000. The Transact SQL is a stored
procedure, and we bind a return parameter to the
connection and call SQLExecDirect it now fails. The
following is an example.

sSQL = "?=sp_GetNext 'value1', 'value2', 'value3'"
iRC = SQLExecDirect(mlHstmt, sSQL, Len(sSQL))

The results is an invalid syntax error. If you use the
exact same code against an older version of SQL Server,
then there is no problem.

Any Ideas?

SQL Server68  
 
 
v-ashrup





PostPosted: Thu May 13 00:04:10 CDT 2004 Top

SQL Server Developer >> ODBC & SQLExecDirect Hi Brandon,

There is a KB article that says that there is a bug in MDAC 2.6 and you
need to apply its latest service pack.
The KB Article is
http://support.microsoft.com/default.aspx?scid=kb;en-us;286359&Product=sql2k

The Service Pack for MDAC 2.6 can be obtained from
http://msdn.microsoft.com/data/default.aspx
On the right hand side, you will see and option of MDAC Downloads, select
MDAC 2.5 Service Pack 2.

Please apply latest service pack for SQL Server 2000, SP3, if you have not
done that so far.
SP3 for SQL Server 2000 for English Language can be obtained from
http://www.microsoft.com/downloads/details.aspx?FamilyId=90DCD52C-0488-4E46-
AFBF-ACACE5369FA3&displaylang=en

If you apply SQL Server 2000 SP3, you need not apply MDAC 2.6 SP 2, it will
be taken care of in SQL SP3.

HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.

 
 
Brandon





PostPosted: Thu May 13 09:27:07 CDT 2004 Top

SQL Server Developer >> ODBC & SQLExecDirect We have MDAC 2.8 installed with service pack 3a. Any other
ideas?

>-----Original Message-----
>Hi Brandon,
>
>There is a KB article that says that there is a bug in
MDAC 2.6 and you
>need to apply its latest service pack.
>The KB Article is
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;286359&Product=sql2k
>
>The Service Pack for MDAC 2.6 can be obtained from
>http://msdn.microsoft.com/data/default.aspx
>On the right hand side, you will see and option of MDAC
Downloads, select
>MDAC 2.5 Service Pack 2.
>
>Please apply latest service pack for SQL Server 2000,
SP3, if you have not
>done that so far.
>SP3 for SQL Server 2000 for English Language can be
obtained from
>http://www.microsoft.com/downloads/details.aspx?
FamilyId=90DCD52C-0488-4E46-
>AFBF-ACACE5369FA3&displaylang=en
>
>If you apply SQL Server 2000 SP3, you need not apply MDAC
2.6 SP 2, it will
>be taken care of in SQL SP3.
>
>HTH
>Ashish
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>
>.
>
 
 
v-ashrup





PostPosted: Thu May 13 17:19:23 CDT 2004 Top

SQL Server Developer >> ODBC & SQLExecDirect Hi Brandon,

I am not able to relate it to any other issues at this moment.

I will get back if i find any furhter information.

Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.