Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Firedac: max string length for dBase file name


This question is not answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 4 - Last Post: Oct 22, 2015 12:44 AM Last Post By: Joyce Nibourg
Joyce Nibourg

Posts: 3
Registered: 4/2/01
Firedac: max string length for dBase file name  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Oct 20, 2015 7:07 AM
I migrated BDE to FireDAC. I use the ODBC driver for accessing dBASE files. When I try to open a query on a dBase file with a long name (> 16 characters) I got the following error message:

[FireDAC][Phys][ODBC][Microsoft][ODBC dBase Driver]Invalid string or buffer length

How can I increase the maximum name length?
quinn wildman

Posts: 856
Registered: 12/2/99
Re: Firedac: max string length for dBase file name  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Oct 20, 2015 9:16 AM   in response to: Joyce Nibourg in response to: Joyce Nibourg
This error looks to be returned by the Microsoft ODBC driver. Contacting
Microsoft is your best bet. Googling for this error I see many
applications get it, but my search did not find a solution.

Joyce Nibourg wrote:
I migrated BDE to FireDAC. I use the ODBC driver for accessing dBASE files. When I try to open a query on a dBase file with a long name (> 16 characters) I got the following error message:

[FireDAC][Phys][ODBC][Microsoft][ODBC dBase Driver]Invalid string or buffer length

How can I increase the maximum name length?
Joyce Nibourg

Posts: 3
Registered: 4/2/01
Re: Firedac: max string length for dBase file name  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Oct 21, 2015 2:29 AM   in response to: quinn wildman in response to: quinn wildman
Thanks for your reply Quinn.
I also couldn't find anything on the internet.

But maybe it is a 32/64-bits issue? I have a 64-bits machine. In my Delphi application I indicated in the Firedac compoment ADPhysODBCDriverLink that the VendorLib = c:\Wndows\SysWOW64\odbc32.dll but that didn't solve the problem.

Any other suggestions?

quinn wildman wrote:
This error looks to be returned by the Microsoft ODBC driver. Contacting
Microsoft is your best bet. Googling for this error I see many
applications get it, but my search did not find a solution.

Joyce Nibourg wrote:
I migrated BDE to FireDAC. I use the ODBC driver for accessing dBASE files. When I try to open a query on a dBase file with a long name (> 16 characters) I got the following error message:

[FireDAC][Phys][ODBC][Microsoft][ODBC dBase Driver]Invalid string or buffer length

How can I increase the maximum name length?
Dmitry Arefiev

Posts: 1,406
Registered: 12/7/03
Re: Firedac: max string length for dBase file name  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Oct 21, 2015 8:29 AM   in response to: Joyce Nibourg in response to: Joyce Nibourg
Any other suggestions?

http://docwiki.embarcadero.com/RADStudio/Seattle/en/Connect_to_Advantage_Database_Server_%28FireDAC%29

--
With best regards,
Dmitry Arefiev / FireDAC Architect
Joyce Nibourg

Posts: 3
Registered: 4/2/01
Re: Firedac: max string length for dBase file name  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Oct 22, 2015 12:44 AM   in response to: Dmitry Arefiev in response to: Dmitry Arefiev
Thanks Dimitry for your suggestion.

I already tried the ADS. It solved the problem with the file names but with ADS I got a number of other problems (memo fields, corrupt dBase files....)

Do you have suggestions for another alternative?
Regards, Joyce

Dmitry Arefiev wrote:
Any other suggestions?

http://docwiki.embarcadero.com/RADStudio/Seattle/en/Connect_to_Advantage_Database_Server_%28FireDAC%29

--
With best regards,
Dmitry Arefiev / FireDAC Architect
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02