• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4586
  • Last Modified:

Error Connecting to Sybase database in Visual Web Developer 2005

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

0
kenadelglass
Asked:
kenadelglass
  • 3
  • 2
1 Solution
 
TornadoVCommented:
Try copying sybdrvado115.dll into system32 folder, worked for me.
0
 
kenadelglassAuthor 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.
0
 
TornadoVCommented:
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
0
 
kenadelglassAuthor 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
0
 
TornadoVCommented:
Anytime, I'm glad it works!
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now