Solved

Error Connecting to Sybase database in Visual Web Developer 2005

Posted on 2006-10-26
5
4,449 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

0
Comment
Question by:kenadelglass
  • 3
  • 2
5 Comments
 
LVL 11

Expert Comment

by:TornadoV
ID: 17812337
Try copying sybdrvado115.dll into system32 folder, worked for me.
0
 
LVL 1

Author Comment

by:kenadelglass
ID: 17812676
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
 
LVL 11

Accepted Solution

by:
TornadoV earned 500 total points
ID: 17812763
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
 
LVL 1

Author Comment

by:kenadelglass
ID: 17813023
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
 
LVL 11

Expert Comment

by:TornadoV
ID: 17813486
Anytime, I'm glad it works!
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this Article, I will provide a few tips in problem and solution manner. Opening an ASPX page in Visual studio 2003 is very slow. To make it fast, please do follow below steps:   Open the Solution/Project. Right click the ASPX file to b…
Today is the age of broadband.  More and more people are going this route determined to experience the web and it’s multitude of services as quickly and painlessly as possible. Coupled with the move to broadband, people are experiencing the web via …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question