<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 [EMAIL PROTECTED] > -----Original Message----- > From: The DOTNET list will be retired 7/1/02 > [mailto:[EMAIL PROTECTED]] On Behalf Of Thakur, Ajay > Sent: Monday, July 01, 2002 10:42 AM > To: [EMAIL PROTECTED] > 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.
