We help IT Professionals succeed at work.

Error Connecting to Sybase database in Visual Web Developer 2005

kenadelglass
kenadelglass asked
on
Medium Priority
4,857 Views
Last Modified: 2012-06-27
Hi...

I am trying to connect to Sybase in my Web application in Visual Web Developer 2005.  I was given two .dlls which are

Sybase.Data.AseClient.dll
sybdrvado115.dll

I was able to add a reference to the Sybase.Data.AseClient.dll but not the sybdrvado115.dll.

Using the following code. I can import the Sybase.Data.AseClient but when I put a break on the line with the new connection I get an error....

Imports System
Imports System.Data
Imports System.Configuration
Imports System.Web
Imports System.Web.Security
Imports System.Web.UI
Imports System.Web.UI.WebControls
Imports System.Web.UI.WebControls.WebParts
Imports System.Web.UI.HtmlControls
Imports Sybase.Data.AseClient


Partial Public Class Start_aspx
    Inherits System.Web.UI.Page

    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim oCon As AseConnection = New AseConnection()
        oCon.ConnectionString = "Data Source='mysource';Port=5000;Database='tblStart';UID='myname';PWD='myPass';"
        oCon.Open()
    End Sub
End Class 'Start_aspx

The error I get is...

"The type initializer for 'Sybase.Data.AseClient.AseConnection' threw an exception."
{"Unable to load DLL 'sybdrvado115.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)"}
I tried to put a reference to 'sybdrvado115.dll' and I am told it is not an assembly and could not be loaded.  I then put it in the bin folder of my web application but still get the same error.  I also messed around in the .net configuration utility and have had no luck.  Any help on this would be greatly appreciated.

thx,
kenadelglass

Comment
Watch Question

Commented:
Try copying sybdrvado115.dll into system32 folder, worked for me.

Author

Commented:
TornadoV...

I had tried that earlier and tried putting both dlls in the c:\winnt\system32 folder.  I loaded Sybase.Data.AseClient.dll into the Assembly Cache but still get the same error.  Any other ideas?  How exactly are you set up?  I am on Win2k professional if that helps at all.
Commented:
I also copied msvcr71.dl to system32 folder along with sybdrvado115.dll.  I have a Win 2003 Server hosting the web app connecting to Windows 2K hosting the sybase db.

I found my solution here:

http://groups-beta.google.com/group/sybase.public.connectivity.adonet/browse_thread/thread/84c732a6358a87d2/b8369863e2538b0f?&hl=en#b8369863e2538b0f

hope this helps

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
TornadoV...

You rock!  It is my utmost pleasure to grant you the 500 point bounty!  Moving the msvcr71.dll to the system32 folder did the trick!!  Incidently, we use dbArtisan and I found a version of the msvcr71.dll it its app folder.  I have always been able to connect to Sybase through dbArtisan.  It all makes sense now!

Thanks so much!

Sincerely,
kenadelglass

Commented:
Anytime, I'm glad it works!
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.