Insert Proc to Sybase

  • Thread starter Thread starter Mel
  • Start date Start date
M

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?
 
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.
 
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 said:
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)

Mel said:
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?
Click to expand...
Click to expand...
 
What is the connection string for Sybase?

news.microsoft.com said:
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 said:
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)

Mel said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Mel,

This should help:

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


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

Mel said:
What is the connection string for Sybase?

news.microsoft.com said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Hi,

Google it !

--
Ignacio Machin
http://www.laceupsolutions.com
Mobile & warehouse Solutions.
Mel said:
What is the connection string for Sybase?

news.microsoft.com said:
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?
Click to expand...
Click to expand...
Click to expand...
 
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?
Click to expand...
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
 
Back
Top