Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM ODBC Driver » View Thread |
Messages 1 to 8 of 8 total |
Master-Detail Problem |
Wed, Jan 18 2006 4:23 AM | Permanent Link |
"Ian Branch" | Hi Guys,
Using the latest ODBC files with ODBCExpress. D7Pro +SP1. Linking and using a single table, no problem. I can move back & forth in the table/grid at will. Setting a master detail with a second table & grid, when ever I move the master table I get a "S1106: [Microsoft][ODBC SQL Server Driver]Fetch type out of range" error. This is apparently a known ODBC issue. My question is..There must be a work around to allow Master-Detail activities without error. What is it?? Any assistance appreciated. Regards & TIA, Ian -- |
Wed, Jan 18 2006 4:42 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Ian,
<< master table I get a "S1106: [Microsoft][ODBC SQL Server Driver]Fetch type out of range" error. This is apparently a known ODBC issue. My question is..There must be a work around to allow Master-Detail activities without error. What is it?? >> Is this a general ODBC question ? The reason that I ask is the above error says "ODBC SQL Server Driver". -- Tim Young Elevate Software www.elevatesoft.com |
Thu, Jan 19 2006 12:54 AM | Permanent Link |
"Ian Branch" | Tim Young [Elevate Software] wrote:
Hi Tim, > > Is this a general ODBC question ? The reason that I ask is the above > error says "ODBC SQL Server Driver". I guess it is, as it seems to be an acknowledged issue by Microsoft. I did in fact paste the wrong error message, the correct one is "[Microsoft][ODBC Driver Manager]Fetch type out of range". I figured that someone, anyone, using ODBC with DBISAM has probably come across this and there is a solution. Regards, Ian -- |
Thu, Jan 19 2006 3:58 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Ian,
<< I guess it is, as it seems to be an acknowledged issue by Microsoft. I did in fact paste the wrong error message, the correct one is "[Microsoft][ODBC Driver Manager]Fetch type out of range". I figured that someone, anyone, using ODBC with DBISAM has probably come across this and there is a solution. >> Ahh, okay. In the case of the ODBC Driver Manager errors, there's not much anyone can do besides MS. Did you ask the ODBCExpress guys/gals whether this was something they might be triggering ? -- Tim Young Elevate Software www.elevatesoft.com |
Fri, Jan 27 2006 6:26 AM | Permanent Link |
"Ian Branch" | Hi Tim,
All sorted. It seems that some databases via ODBC don't like cursors moving in one direction or another in 'real time'. solution is to turn caching on so there are records available. All fixed. Regards, Ian |
Fri, Jan 27 2006 9:36 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Ian,
<< All sorted. It seems that some databases via ODBC don't like cursors moving in one direction or another in 'real time'. solution is to turn caching on so there are records available. All fixed. >> Ahh, so you were using a dynamic cursor result set and not a static one ? -- Tim Young Elevate Software www.elevatesoft.com |
Fri, Jan 27 2006 11:28 PM | Permanent Link |
"Ian Branch" | Hi Tim,
> > Ahh, so you were using a dynamic cursor result set and not a static > one ? Damned if I know. Still learning about that stuff I just hooked it together..Database->Tables->DBISAMODBC->ODBCExpress->Datasource->Grids. Regards, Ian |
Mon, Jan 30 2006 7:55 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Ian,
<< Damned if I know. Still learning about that stuff I just hooked it together..Database->Tables->DBISAMODBC-ODBCExpress->Datasource->Grids. >> In ODBCExpress, it's the hStmt.CursorType property: Forward-Only = Live result set in DBISAM ODBC (if it can get one) Static = Canned result set in DBISAM ODBC Keyset Driven = Canned result set in DBISAM ODBC Dynamic = Live result set in DBISAM ODBC -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Sunday, May 5, 2024 at 07:30 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |