[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2802
  • Last Modified:

Problems using ADO OLE DB connection to Sybase DB

Hi,
I could not install the pcclient. Java Installer problems. However, I got the OLE DB provider from sybase (sydaase.dll), which I could successfully register in Win XP (regsvr32).
I also can make a successfull connect to the Sybase DB with the sydaadm tool (sydaadm.exe). When I try now to make a connection to the database in VB6, I got the error message "Unable to load communication module. NetLib driver has not been correctly installed"

Is it also necessary to install this NetLib driver ? Is it not sufficient to have the sydaase.dll registered ? How to install the NetLib driver ?

Thanks for any comments
/Kenny
0
Kenny2k4
Asked:
Kenny2k4
  • 5
  • 3
1 Solution
 
leonstrykerCommented:
Could you please shouw how you are attempting to connect with VB.

Leon
0
 
Kenny2k4Author Commented:
I tired to make a new connection in the Data View window (DataEnvironment). There, I can choose the Sybase ASE OLE DB driver but the Test Connect gives the "ADO error: Unable to load communication module. NetLib driver has not been correctly installed"

I also tried it programatically:

Function connectSyb() As String
  Dim errMsg As String
  Set conSyb_ = New ADODB.Connection
  conSyb_.Provider = "Sybase.ASEOLEDBProvider.1;Initial Catalog=rsddb_Olten_oltranos;Password=password;User ID=guest;Data Source=SybaseRanos;Persist Security Info=True;Server Name=oltranos.omi.swissptt.ch;Server Port Address=5025"
   
  On Error Resume Next
  conSyb_.Open
  errMsg = Err.Description
  On Error GoTo 0
 
  connectSyb = errMsg
End Function

This gives the same error as in the DataView window.

br
Kenny
0
 
leonstrykerCommented:
Try this please:

Function connectSyb() As String
  Dim errMsg As String
  Set conSyb_ = New ADODB.Connection
  conSyb_ .Open "Provider=Sybase.ASEOLEDBProvider;" & _
           "Srvr=oltranos.omi.swissptt.ch,5025;" & _
           "Catalog=rsddb_Olten_oltranos;" & _
           "User Id=guest;" & _
           "Password=password"

  On Error Resume Next
  conSyb_.Open
  errMsg = Err.Description
  Err.Clear
  connectSyb = errMsg
End Function

Leon
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Kenny2k4Author Commented:
Hi Leon,

Tried it. It gives the same error (NetLib driver has not been correctly installed) when processing the line:

conSyb_ .Open "Provider=Sybase.ASEOLEDBProvider;" & _
           "Srvr=oltranos.omi.swissptt.ch,5025;" & _
           "Catalog=rsddb_Olten_oltranos;" & _
           "User Id=guest;" & _
           "Password=password"

I don't know what this NetLib driver is used for and how to install it ???

Thanks and br
Kenny
0
 
leonstrykerCommented:
Do you have your Sybase client CD?  I think you should try reinstalling it.  BTW, which version of ASE are you using?

Leon
0
 
Kenny2k4Author Commented:
Hi,

I have the Sybase Client CD (12.5.2), but I cannot install the pcclient. The Java Installer does not work correctly. It ended up showing the "Accept License Agreement" screen. But I could not see any license agreement and I could not set the check box to accept the license agreement and therefore not continue with the installation. I tried with several PC's (Win NT and Win XP).

I just copied the OLEDB drivers and registered it (with regsvr32), which was successfull.

br
Kenny
0
 
leonstrykerCommented:
>>I just copied the OLEDB drivers and registered it

Obviously this is not enough.  I think you will need to get in touch with Sybase and get a new client CD.

Leon
0
 
leonstrykerCommented:
Kenny,

Do you still need help with this question?

Leon
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

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