Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
OS problem in ORACLE - COMMIT, ROLLBACK
Message
 
 
To
28/03/2003 01:45:54
Amit Abhangrao
Charmi Software Exports
Mumbai, India
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00771191
Message ID:
00771353
Views:
11
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
Previous
Reply
Map
View

Click here to load this message in the networking platform