Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Problems using ADO OLE DB connection to Sybase DB

Posted on 2004-09-17
8
2,733 Views
Last Modified: 2012-08-13
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
Comment
Question by:Kenny2k4
  • 5
  • 3
8 Comments
 
LVL 29

Expert Comment

by:leonstryker
ID: 12085899
Could you please shouw how you are attempting to connect with VB.

Leon
0
 

Author Comment

by:Kenny2k4
ID: 12099757
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
 
LVL 29

Expert Comment

by:leonstryker
ID: 12102208
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: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

 

Author Comment

by:Kenny2k4
ID: 12102387
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
 
LVL 29

Expert Comment

by:leonstryker
ID: 12102460
Do you have your Sybase client CD?  I think you should try reinstalling it.  BTW, which version of ASE are you using?

Leon
0
 

Author Comment

by:Kenny2k4
ID: 12102521
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
 
LVL 29

Accepted Solution

by:
leonstryker earned 50 total points
ID: 12102655
>>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
 
LVL 29

Expert Comment

by:leonstryker
ID: 12308769
Kenny,

Do you still need help with this question?

Leon
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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

This article describes my battle tested process for setting up delegation. I use this process anywhere that I need to setup delegation. In the article I will show how it applies to Active Directory
Many businesses neglect disaster recovery and treat it as an after-thought. I can tell you first hand that data will be lost, hard drives die, servers will be hacked, and careless (or malicious) employees can ruin your data.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

829 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