VB6 Error that connects to SyBase SQL DB.

Asked By James. 0 points N/A Posted on - 07/18/2011

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.

Thanks!

• Status: Open
• Question Views: 1849
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Sybase Database

Answered By Reed95 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.

About Reed95

Questions
0

Answers
6

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 07/19/2011
• Question Category: Sybase Database