MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Excel tool with VBA code

  Asked By: Adelisa    Date: Nov 13    Category: MS Office    Views: 2661

I have got a Excel tool with VBA code and i have to make some changes
in the tool, in which I have to connect the external Sybase database.
I have installed the sybase ODBC driver in my system and the code is
using ADODB connection to connect the database. But when I try to
connect the database I get the message that "Provider can not be
found. It may not be properly installed". I am new to the database
stuff and VB. Please help me knowing what to do, do I need to Install
or enable any other component in excel to connect it with the ODBC



1 Answer Found

Answer #1    Answered By: Jamie Roberts     Answered On: Nov 13

Sybase normally provide an OLEDB provider  which is a more efficient
mechanism. Do you not have that on your system?

Didn't find what you were looking for? Find more on Excel tool with VBA code Or get search suggestion and latest updates.