2GB file size limitation
- 
				Cliff_Wiernik
 - Posts: 142
 - Joined: Tue Oct 10, 2017 12:44 pm
 
2GB file size limitation
What is planned for addressing the file size limitation of R&R related to dbf files size limitation.  Advantage database server, in the dbf format, has handled 4GB files for some time and version 8 expands that to 8 GB.  ____Currently only 2GB files are supported.  It would be nice to handle the larger file size limit as the 2GB limit is archaeic.____Cliff
			
									
									
						- 
				Jeff_Lassell_(Guest)
 - Posts: 23
 - Joined: Tue Oct 10, 2017 12:44 pm
 
=> RE: 2GB file size limitation
Along that same line, the ADS ODBC connector won^t work with R&R SQL.  Not sure why, but I understand that this has been an outstanding issue for some years now.
			
									
									
						=> RE: 2GB file size limitation
Having used R&R with xBase tables for 17 years or so, and with Advantage in the xBase edition for about 10 years, I am disappointed to find that on trying to use R&R SQL with the Advantage ODBC driver R&R crashes. Then I learn through this forum that this has been an issue "for some years". In version 8 Advantage implements views and stored procedures through SQL scripts. I could hardly wait to create some nice views in Advantage and then read them with R&R so saving lots of table joining within R&R, but R&R crashes just after selecting the Advantage-driven ODBC data source. ____Are there plans to make R&R and Advantage ODBC work together? I hope so because I don^t want to have to change to Crystal.____Best wishes to all,____Noel
			
									
									
						- 
				Cliff_Wiernik
 - Posts: 142
 - Joined: Tue Oct 10, 2017 12:44 pm
 
==> RE: 2GB file size limitation
Has there been any update on this issue?  Is it fixed with version 11?
			
									
									
						===> RE: 2GB file size limitation
Or version 12?
			
									
									
						- 
				Darylkance
 - Posts: 0
 - Joined: Mon Apr 23, 2018 10:24 pm
 
==> R&R SQL and Advantage 8 ODBC
It is still an issue in V12.____Kathleen__R&R Support
			
									
									
						- 
				Clancy_(Guest)
 - Posts: 9
 - Joined: Tue Oct 10, 2017 12:44 pm
 
===> RE: R&R SQL and Advantage 8 ODBC
We have an internal release that support >2GB if you would like to take it for a test drive. Send an email to me at livesupport@livewarepub.com and I will send it out to you.______Kathleen__R&R Support
			
									
									
						- 
				Clancy_(Guest)
 - Posts: 9
 - Joined: Tue Oct 10, 2017 12:44 pm
 
====> RE: R&R SQL and Advantage 8 ODBC
>We have an internal release that support >2GB if you would __>like to take it for a test drive. Send an email to me at __>livesupport@livewarepub.com and I will send it out to you. __>__>__>Kathleen __>R&R Support ____I sent an email last week, did you receive it yet.____Cliff.
			
									
									
						=====> RE: R&R SQL and Advantage 8 ODBC
Yes but you are correct that I still have not replied to it.____will do do once I finish answering messages here.____Kathleen__R&R Support
			
									
									
						- 
				Clancy_(Guest)
 - Posts: 9
 - Joined: Tue Oct 10, 2017 12:44 pm
 
==> RE: 2GB file size limitation
Thanks Kathleen.____Do we know what the specific issue is with the Advantage ODBC driver?