Solved

Problems using ADO OLE DB connection to Sybase DB

Posted on 2004-09-17
8
2,745 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
[X]
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
  • 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: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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

Suggested Solutions

Title # Comments Views Activity
Cannot create ODBC connection over the network 3 1,243
Installing Sybase IQ 16.x x64 on Windows 8.1 update1 5 1,605
sybase optimizer statistics 2 61
Temporary tables in Oracle 9 144
Always backup Domain, SYSVOL etc.using processes according to Microsoft Best Practices. This is meant as a disaster recovery process for small environments that did not implement backup processes and did not run a secondary domain controller that ne…
Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

733 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