Hello All,
I need to connect to a Sybase ASE 12.5.3 ESD2 Database in order to read data from a couple of tables. No one here is accessing these databases from .Net so I need some help. I tried the code below, but I got the error "The 'Sybase ASE OLE DB Provider' provider is not registered on the local machine".
I had the 15.0.3 drivers installed on my computer but I am going to revert them back to 12.5.3.
Can anyone give me some sample code for accessing a Sybase ASE 12.5.3 database from C# 2.0? I think my main problem is with my connection string, but I might need to register some of the DLL's in the install package. Also, do I need to create a DSN for this server?
Thanks in advance,
Kevin
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Yeah, I had already looked at the ConnectionStrings website and read what you posted. The problem is that what you specify in the connection string has to match exactly with the particular version of Sybase you are using. The text you excerpted relates to SQL Anywhere, which is a totally different product from ASE. I really need someone to reply to this who actually works with Sybase ASE.
You definitely need to have the proper OleDb provider registered on your machine or else the the connection string will never work. Also, needing a DSN is up to you. There are several ways to connect as you'll see below.
Found this at: http://www.carlprothman.ne
OLE DB Provider for Sybase Adaptive Server Enterprise (ASE)
oConn.Open "Provider=Sybase ASE OLE DB Provider;" & _
"Data source=myASEServer"
' Or
oConn.Open "Provider=Sybase.ASEOLEDBP
"Srvr=myASEServer,5000;" & _
"Catalog=myDBName;" & _
"User Id=myUserName;" & _
"Password=myUserPassword"
Where:
- *** The Sybase ASE OLE DB provider from the Sybase 12.5 client CD ***
- 5000 is the port number for Sybase.
Note: The Open Client 12 Sybase OLE DB Provider fails to work without creating a Data Source .IDS file using the Sybase Data Administrator. These .IDS files resemble ODBC DSNs.
Note: With Open Client 12.5, the server port number feature finally works, allowing fully qualified network connection strings to be used without defining any .IDS Data Source files.
You definitely need to have the proper OleDb provider registered on your machine or else the the connection string will never work. Also, needing a DSN is up to you. There are several ways to connect as you'll see below.
Found this:
OLE DB Provider for Sybase Adaptive Server Enterprise (ASE)
oConn.Open "Provider=Sybase ASE OLE DB Provider;" & _
"Data source=myASEServer"
' Or
oConn.Open "Provider=Sybase.ASEOLEDBP
"Srvr=myASEServer,5000;" & _
"Catalog=myDBName;" & _
"User Id=myUserName;" & _
"Password=myUserPassword"
Where:
- The Sybase ASE OLE DB provider from the Sybase 12.5 client CD
- 5000 is the port number for Sybase.
Note: The Open Client 12 Sybase OLE DB Provider fails to work without creating a Data Source .IDS file using the Sybase Data Administrator. These .IDS files resemble ODBC DSNs.
Note: With Open Client 12.5, the server port number feature finally works, allowing fully qualified network connection strings to be used without defining any .IDS Data Source files.
It turns out that ASEOLEDBProvider is an old third-party driver (sydaase.dll) which is not supported for .Net. The proper one is ASEOLEDB from Sybase which uses sybdrvoledb.dll. After I futzed with connection string syntax it finally connected and is working now. No wonder that Sybase only has 3% of the database market. There apparently isn't a working Ado.Net 2.0 provider from Sybase.
Agreed. i worked with Sybase v. 5 & 6 in the late 90s and found it to be a very decent db. Moving to Sql Server afterwards was no problem because both flavors came from the same db development effort. But, Sybase does a HORRIBLE job of slicing and dicing the product into a confusing array of options, their documentation stinks and they try and push their development IDEs via their database implementations... It's all a mess. They are a very distant third in market share but should be neck and neck with Microsoft at least... eh. Sorry i couldn't be of more help...
Business Accounts
Answer for Membership
by: psasikPosted on 2009-08-14 at 09:19:08ID: 25099774
Try: Provider=ASEOLEDB
How did you get this string: "Sybase ASE OLE DB Provider;" ? It has to be EXACT otherwise your provider will not be found.
More info from: http://www.connectionstrin
.NET Framework Data Provider for OLE DB
Type: .NET Framework Wrapper Class Library
Usage: System.Data.OleDb.OleDbCon
Bridging to Adaptive Server Anywhere OLE DB Provider
This is just one connection string sample for the wrapping OleDbConnection class that calls the underlying OLEDB provider. See respective OLE DB provider for more connection strings to use with this class.
Provider=ASAProv;Data source=myASA;