VB6 Error that connects to SyBase SQL DB.

Asked By 0 points N/A Posted on -

Hi there,

I encountered a problem with regards to Visual Basic. I was working on a macro where I am planning to open a page on a website and create a new workbook. When I tried to run the macro this error message appeared on my screen:

[Sybase][ODBC][SQL Anywhere]Column ‘Reference#’ not found

Every time this error show on my screen, I have to close and restart Excel before I run the macro again.  There are no other open workbooks when I tried to start the macro and I also tried QueryTable. Delete command but it didn't fix the problem. Does anyone have the same problem? I hope someone could help me.


Answered By 0 points N/A #84247

VB6 Error that connects to SyBase SQL DB.


Hi James,

This occurs when you try to connect to [SQL Anywhere] using an ASE connection. Actually Sybase does not allow connections from TDA 2.7 or lower versions. You can try to create an ODBC connections by using ODBC type in excel. But if you use TDA 3.0 you can connect to Sybase IQ and SQL

Anywhere because they have added these connection types recently. Visit link to download.

There is another problem with Sybase. You have to purchase the software in order to download drivers.

Thankfully SQL Anywhere team was kind enough to develop the client version and now it’s available to public and the URL is link SQL Anywhere Database Client Download.

Login/Register to Answer

Related Questions