Re: Function sequence error

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

It's an ODBC error. Are you sure these two PCs using the same version of the
ODBC driver? Are you validating your connection handle before you call
sqlexec?

<bpiroue@xxxxxxxxxxx> wrote in message
news:1145546511.800447.22000@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi all,

our customers has 30 PCs running the same version of our Software
against a sql server 2000 database.

28 PCs are running fine, 2 of them shows an error "Function sequence
error". The line in my VFP code is:

IF sqlexec(nConnecthandle, lcSql) < 0
*errorhandling
ENDIF

lcsql is an sql statement, a little bit complicated, but not too much.
The function sequence error is thrown by the driver manager, not by the
sql server.

All the 28 other PCs are able to send the same sql statement to the
server, no problem...

I already checked the version of the sql server driver (winxp), but
they do have all the same version, all of the 30...

What can I do here?

Thank you!

/Bastien



.

Relevant Pages

  • RE: [dbi] Re: MsSQL DBD::ODBC IsNull and undef
    ... I'd guess this is because the SQL Server ODBC driver is looking at your ... Martin J. Evans ... can you run your test script again but creating an OOB log file ...
    (perl.dbi.users)
  • Re: Padding using Type 4 Drivers
    ... |> value than what you have set in SQL Server 2000. ... |> settings that you require. ... |> Are you using the Microsoft JDBC driver or a third-party driver?. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: MsSQL DBD::ODBC IsNull and undef
    ... Martin J. Evans ... On 26-Jul-2005 Brian Becker wrote: ... > ensure you tell your driver the type of the column in bind_col. ... > I'd guess this is because the SQL Server ODBC driver is looking at your ...
    (perl.dbi.users)
  • Re: XA and 2000 backwards compatibility
    ... We haven't deployed the SQL2K XA driver either, so this should work for us. ... I am going through the documentation for the SQL Server driver. ... and enable XA transactions in MSDTC on the SQL Server ... Goto MSDTC tab on properties, click "Security Configuration" button, ...
    (microsoft.public.sqlserver.jdbcdriver)
  • RE: [dbi] Re: MsSQL DBD::ODBC IsNull and undef
    ... ensure you tell your driver the type of the column in bind_col. ... To: Brian Becker ... I'd guess this is because the SQL Server ODBC driver is looking at your ... Martin J. Evans ...
    (perl.dbi.users)