Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLStringConnect 'String is too long to fit'
Message
From
08/10/2005 04:49:54
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
01057057
Message ID:
01057412
Views:
155
>I'm trying to connect to an ODBC datasource using the SqlStringConnect function, but i'm getting a 1903 error, 'String is too long to fit'.
>
>The connection string is greater than 255 characters, and i have no way of reducing its length. It contains a series of file names including paths and an unlock key which is 128 characters long.
>
>Any ideas how i can still use this function, so i can save myself from having to use oledb, which doesn't appear to have the 255 character restriction on a connection string.

I post this BUG to VFPT on Thread #1057411.

VFP checks the length of the string, and if it overcomes the 254 characters it refuses the command.
There is no solution now.

Don't have the opportunity of sending the paths and an unlock key with a SQLEXEC ?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform