[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Problems using ADO OLE DB connection to Sybase DB

Posted on 2004-09-17
8
Medium Priority
?
2,813 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 100 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: 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.

Question has a verified solution.

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

Here is a method which can be used to help resolve a "Content Index Failed" error on a Microsoft Exchange Server.
Data security in the cloud is very much like a security in an on-premises data center - only without costs for maintaining facilities and computer hardware.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Kernel Data Recovery is a renowned Data Recovery solution provider which offers wide range of softwares for both enterprise and home users with its cost-effective solutions. Let's have a quick overview of the journey and data recovery tools range he…
Suggested Courses

640 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