Knowledgebase: Tutorials
[QODBC-Desktop] Troubleshooting - Visual Studio Connection to QODBC
Posted by Jack - QODBC Support on 26 October 2015 07:18 AM

Troubleshooting - Visual Studio Connection to QODBC

Problem Description:

I am getting the following message from Visual Studio 2015 when trying to connect to QRemote using the ODBC data source:

"An error occurred while retrieving the information from the database: Column 'TABLE_CAT' does not belong to table Tables."

We unchecked the box on the server to run 2.1 ODBC compatibility.

The test connection works, and I can access the data using QRemote on my client machine, but I am not able to get this database to connect to Visual Studio.



Solutions:

Please query table directly instead of loading tables.

For Example:

select * from customer


(4 vote(s))
Helpful
Not helpful

Comments (2)
Randy
28 December 2016 12:30 AM
I get this message trying to configure a DataSource. I cannot access any info using VS 2015 and VB. Perhaps a more detailed 'Solution'?
Jack
28 December 2016 06:48 AM
Hi Randy,

You need to query wizard & write query manually instead of loading tables.

If you are still facing issue, I kindly request you to please raise a support ticket to the QODBC Technical Support department from below mentioned link & provide requested information:

http://support.flexquarters.com/esupport/index.php?/Tickets/Submit

We may need the following information, I kindly request you to attach below listed files when replying to the ticket.
1) Screenshot of QODBC Setup Screen -- > About
2) Screenshot of the issue you’re facing.
Share Entire Log Files as an attachment in text format from
3) QODBC Setup Screen -- > Messages -- > Review QODBC Messages
4) QODBC Setup Screen -- > Messages -- > Review SDK Messages

Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).