<Cross Posting this reply since the dotnet list is supposed to be
retired today> 

You can only use the OleDb Managed Provider if you have an OLEDB
Provider for Sybase.  If you are using ODBC, you must use the ODBC
Managed Provider.  Here's a site with connection strings for all sorts
of environments...

Here's the typical ODBC Managed Provider Usage:

http://www.able-consulting.com/ado_conn.htm#ODBCManagedProvider

And the Sybase specific Connection String:

http://www.able-consulting.com/ado_conn.htm#ODBCDriverForSybase

Maybe marrying these together will help....

Thanks,

Shawn Wildermuth
swildermuth@[...].com

>  -----Original Message-----
>  From: The DOTNET list will be retired 7/1/02
>  [mailto:DOTNET@[...].COM] On Behalf Of Thakur, Ajay
>  Sent: Monday, July 01, 2002 10:42 AM
>  To: DOTNET@[...].COM
>  Subject: [DOTNET] Connecting to Sybase using ODBC
> 
> 
>  Hi All,
> 
>  I am trying to connect to Sybase..using OLEDB provider
>  provided by Sybase12.. but it is not working out.
> 
>  This I did after trying out with .NET ODBC provider.
> 
>  Any pointers on the above...
> 
> 
>  Thanks & Regards,
> 
>  Ajay Thakur
>  *HCL Perot Systems Ltd.,
>  'Shivalaya',Plot No. 123 EP-IP,
>  IInd Phase, Whitefield Industrial Area
>  Bangalore 560066.
>  * +91-80 - 8413000 to 8413009.  Xtn. - 2139
>  Fax: +91- 80- 841 2855
>  ********************************
>  "Creativity is allowing oneself to make mistakes.
>  Art is knowing which ones to keep."
>  *******************************
>  WARNING: The information in this message is confidential and
>  may be legally privileged. It is intended solely for the
>  addressee.  Access to this message by anyone else is
>  unauthorised.  If you are not the intended recipient, any
>  disclosure, copying, or distribution of the message, or any
>  action or omission taken by you in reliance on it, is
>  prohibited and may be unlawful. Please immediately contact
>  the sender if you have received this message in error. Thank you.
> 
>  You can read messages from the DOTNET archive, unsubscribe
>  from DOTNET, or subscribe to other DevelopMentor lists at
>  http://discuss.develop.com.
> 

You can read messages from the DOTNET archive, unsubscribe from DOTNET, or
subscribe to other DevelopMentor lists at http://discuss.develop.com.