Solved

Problems using ADO OLE DB connection to Sybase DB

Posted on 2004-09-17
8
2,686 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
 

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
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Suggested Solutions

Short answer to this question: there is no effective WiFi manager in iOS devices as seen in Windows WiFi or Macbook OSx WiFi management, but this article will try and provide some amicable solutions to better suite your needs.
In this article, I will show you HOW TO: Perform a Physical to Virtual (P2V) Conversion the easy way from a computer backup (image).
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This video discusses moving either the default database or any database to a new volume.

743 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now