The OS should have NO affect on the SQL you are sending to the Oracle server. Make sure the ODBC driver versions are the same on all the machines. Just go to the ODBC Administrator Control Panel and click the Drivers tab. Scroll down to the driver you are using and note the version. You should also check the ODBC properties using SQLGETPROP() function to make sure they are what you expect especially the one for setting transactions to manual or whatever you need.
>Hi
> Im connecting my oracle database server thro'
> lnorahndle = SQLCONNECT("DSN", "SCHEMA", "PASSWORD")
>
> my client OS are different WIN98, WIN2000 and WIN- XP
> i got problem while saving records
> IN WIN95, WIN2000
> =SQLEXEC(lnorahndle, "SAVEPOINT slSavePnt")
> =SQLEXEC(lnorahndle, "ROLLBACK To slSavePnt")
> =SQLEXEC(lnorahndle, "COMMIT")
> All these commands Works Fine
>
> But these commands does not works in XP
> instead
> =SQLEXEC(lnorahndle, "BEGIN SAVEPOINT slSavePnt; END;")
> =SQLEXEC(lnorahndle, "BEGIN ROLLACK TO slSavePnt; END;")
> =SQLEXEC(lnorahndle, "BEGIN COMMIT; END;")
> Works fine
>
> but these commands doesnt work in WIN98 and WIN2000
>
> Please Help me
>
>TIA
>
>Amit
Mark McCasland
Midlothian, TX USA