Member Login

Username
Password
Forget Password
New Sign Up
Search Forum

Buy Support
Incidents

If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:

Click Here
If you can't login and post questions or you are having trouble viewing forum posts:
Click Here
Callback
Support

If you live in USA, UK, Canada, Australia or New Zealand, you can leave us details on your question and request us to call you back and discuss them with you personally  (charges apply).

Click Here
 
Buy Support
Incidents
If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:
Click Here

Forum : DOES NOT WORK IN VISUAL STUDIO - IMPORTANT - NEEDS TO BE FIXEDSearch Forum

Forum Home > FlexODBC - ODBC Driver for DataFlex Embedded DBMS > FlexODBC Forum

 New Topic 
 
 Post Reply 
[1]  
 DOES NOT WORK IN VISUAL STUDIO - IMPORTANT - NEEDS TO BE FIXED 
 Author   Message 
  Chris Marcan 
  
 Group: Members 
 Posts: 4 
 Joined: 2006-10-01 
 Profile
 Posted : 2006-10-01 06:18:30

Everytime visual studio 2005 tries to get table information from the driver the following error occurs:

"Column 'TABLE_CAT' does not belong to table Tables"

This is appearently because the driver is out of date or does not properly support this function.  The column name changed from TABLE_QUALIFIER to TABLE_CAT in ODBC v3.

This is what microsoft says about this error:

https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=123248

We desperately need this to be fixed.  Please provide a fix as soon as possible.

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-10-02 11:52:46
I'm not too sure whether you're referring to QODBC or FlexODBC here?  So I'll cover both products:

When Using QODBC
Check that you are not running QODBC still in 2.1 ODBC Compatibility Mode. This must be unchecked in the QODBC Advanced Setup screen.

When Using FlexODBC
The TABLE_QUALIFIER (ODBC API 2.0 or earlier) to TABLE_CAT (ODBC API 3.0) issue has been fixed in QODBC but not in FlexODBC (yet). You will need to download FlexODBC v4.00.25 or later when it's available. Microsoft documentation (pre .NET 2005) had orignally indicated that nobody uses columns names as they used ordinal positions.

 

  Top 
  Chris Marcan 
  
 Group: Members 
 Posts: 4 
 Joined: 2006-10-01 
 Profile
 Posted : 2006-10-04 02:40:02

Thank you for you quick response.  We are using the FlexODBC product.  Any idea when that might be available.  Having to do everything in code instead of using the studio is a major pain.  If its going to be very long I'll have to do it in code.  If its not going to be long then I'll probably wait until the new version comes out before I start development.

Another question?  Does the driver support transaction processing and setting of RepeatableRead isolation level?  There are certain circumstances in our systems where the locking of records or tables may be neccessary.

Thanks.

 

 

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-10-04 08:42:45

Sorry, no timetable is currently available on when the next revision of FlexODBC will occur, so it may take a while. I will also request that we add a Simulate Transaction Support setup parameter that will turn on transaction support. FlexODBC will still not actually support transactions, but will simulate the turning on and off of transactions so your Visual Studio.NET application will be happy.

The actual locking of the DataFlex Embedded DBMS tables during writes is handled automatically within the Data Access API called by FlexODBC.

 

  Top 
  Chris Marcan 
  
 Group: Members 
 Posts: 4 
 Joined: 2006-10-01 
 Profile
 Posted : 2006-10-05 01:45:59

I haven't built the application yet, so if I can't do a RepeatableRead transaction to lock the record then theres no point in using transactions to update records at all.  My concern is being able to lock while grabbing and then updating things like "quantity on hands" while processing orders when more than one person maybe working with that record.  In dataflex I would do a REREAD and then calculate "shipped" and "shorted" quantities on the order and then save the updated "quantity on hand" and UNLOCK.  I will have to try to figure out how to deal with this problem in a different way.

In regards with the "TABLE_CAT" column name change, I'm no expert, but it seems to me that must be a very quick fix (not to mention that you've already implemented it in you other product).  Any chance of getting a quick solution to that one.  It means a very substantial time savings to us.

 

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-10-05 08:31:38

With FlexODBC, when you run an UPDATE command, a SELECT is run to find qualified records, when one is found, REREAD is run, then the record is re-qualified, the specified edit fields are changed, the UNLOCK command is run, then we move to the next record. On a INSERT a LOCK is run, a new record is saved, and then UNLOCK is run.

I have emailed you a TABLE_CAT fix directly to your email address. Please report back here how it goes!

 

  Top 
  Chris Marcan 
  
 Group: Members 
 Posts: 4 
 Joined: 2006-10-01 
 Profile
 Posted : 2006-10-06 06:10:30

Its closer!

When I try to add a dataflex database as a datasource in the datasource box, I get the message "An error occured while retrieving the information from the database: An item with the same key has already been added."

However if I go the dataset designer and add a tableadapter it will create the table and add it to the datasources.  Only problem with doing it this way is that the UPDATE, INSERT, and DELETE methods aren't created.  Appearently this is a bug in visual studio 2005.

 

 

 

  Top 
  Cheryl 
  
 Group: Members 
 Posts: 2 
 Joined: 2008-02-21 
 Profile
 Posted : 2008-02-21 07:36:14
I see that a year and a half has passed since this conversation took place - I am having the same issue, we upgraded to Version 4.0.24, and are now having the same issue in VB2005.Net. Hate to go back to an older version of .Net for a new app. Is there any chance of getting a fix? I read under another topic here that there was actually a beta version available about a year ago - can anyone tell me where to get this, and whether it solves the problem? thanks in advance - in a hurry to get the app finished....  

  Top 
  a22 
  
 Group: Members 
 Posts: 1 
 Joined: 2008-09-08 
 Profile
 Posted : 2008-09-08 15:09:50

Is that possible I can have that fix as well? Just start a project which has same issue under VS 2005.

Many thanks.

 

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2008-09-09 00:28:22
You need to contact the sales office in your region directly to request the update. 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to