Insert Proc to Sybase

[Mel]

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?

 

[Nicholas Paldino [.NET/C# MVP]]

Mel,

I don't know if Sybase has a managed provider which you can use. Do you
have ODBC or OLEDB drivers for the data source? If so, you would use the
classes in the System.Data.Odbc and System.Data.OleDb namespaces
respectively.

 

[news.microsoft.com]

hi,

here the link to an exemple on how to do so (see section 'odbc')
http://msdn2.microsoft.com/en-us/library/yy6y35y8(VS.71).aspx

Hope it helps,
Martin

Mel,

I don't know if Sybase has a managed provider which you can use. Do
you have ODBC or OLEDB drivers for the data source? If so, you would use
the classes in the System.Data.Odbc and System.Data.OleDb namespaces
respectively.


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

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?

 

[Mel]

What is the connection string for Sybase?

hi,

here the link to an exemple on how to do so (see section 'odbc')
http://msdn2.microsoft.com/en-us/library/yy6y35y8(VS.71).aspx

Hope it helps,
Martin

Mel,

I don't know if Sybase has a managed provider which you can use. Do
you have ODBC or OLEDB drivers for the data source? If so, you would use
the classes in the System.Data.Odbc and System.Data.OleDb namespaces
respectively.


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

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?

 

[Nicholas Paldino [.NET/C# MVP]]

Mel,

This should help:

http://www.connectionstrings.com/?carrier=sybase


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

What is the connection string for Sybase?

hi,

here the link to an exemple on how to do so (see section 'odbc')
http://msdn2.microsoft.com/en-us/library/yy6y35y8(VS.71).aspx

Hope it helps,
Martin

"Nicholas Paldino [.NET/C# MVP]" <[email protected]> a
écrit
dans le message de news: (e-mail address removed)...

Mel,

I don't know if Sybase has a managed provider which you can use. Do
you have ODBC or OLEDB drivers for the data source? If so, you would
use
the classes in the System.Data.Odbc and System.Data.OleDb namespaces
respectively.


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

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?

 

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

Google it !

--
Ignacio Machin
http://www.laceupsolutions.com
Mobile & warehouse Solutions.

What is the connection string for Sybase?

hi,

here the link to an exemple on how to do so (see section 'odbc')
http://msdn2.microsoft.com/en-us/library/yy6y35y8(VS.71).aspx

Hope it helps,
Martin

"Nicholas Paldino [.NET/C# MVP]" <[email protected]> a
écrit
dans le message de news: (e-mail address removed)...

Mel,

I don't know if Sybase has a managed provider which you can use. Do
you have ODBC or OLEDB drivers for the data source? If so, you would
use
the classes in the System.Data.Odbc and System.Data.OleDb namespaces
respectively.


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

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?

 

[bob clegg]

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