On Thu, 6 Dec 2007 08:44:00 -0800, Mel <Me*@discussions.microsoft.com>
wrote:
>I wrote a stored procedure to insert data on Sybase. I need to find code on
how to execute the stored procedure from C#.
Do you have any examples?
Hi, Using SQLAnywhere?
Provider=ASAProv;Data Source=MyDSN;Persist Security
Info=True;Password=password;User ID=user;Initial Catalog=myDatabase
If using SqlAnywhere 9.0 be careful,
found a interesting bug that may be in the drivers somewhere.
I got unusual data corruptions using the
System.Data.OleDb.OleDbFactory with parameters to write to a
SQLAnywhere 9.0 database.
Cast the parameter directly to an oleDBParameter before setting its
value and problem disappeared.
I reported to Microsoft but it was further downstream than they wanted
to paddle so they washed their hands of it.
I also ended up with intermittant exceptions that occured every 3- 4
days on clients site.
After weeks of refactoring and optimising I finally followed my guts
and ported the DAL and database to SQLServer.
No more problems.
Don't get me wrong, we use SQLAnywhere as a backend for a number of
our commercial apps.
But SQLAnywhere 9.00 and C# framework 2.00 well ...
Bob