Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ODBC always worked and ConnString doesn't
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
Database:
Firebird
Application:
Desktop
Miscellaneous
Thread ID:
01413151
Message ID:
01413339
Views:
43
>What is the error that AERROR() returns? Did you compare the connection string to the ODBC configuration?

laErr[1] = 1526
laErr[2] = Connectivity error: I/O error for file "C17_33761"
Error while trying to open file
The system cannot find the file specified.
laErr[3] = as above
laErr[4] = 08004
laErr[5] = 0
laErr[6] = 1
laErr[7] = null

C17_33761 is the alias as setup in the aliases.conf for FireBird on the server machine.

Further research reveals that FireBird can refuse a connection if it has the belief that it will corrupt the database. The long Windows filepathnames may have played a part in this for me. Still researching but I think what was happening was that ODBC was somehow hiding the long pathnames complexity from FireBird, connection strings was not and thus the lock down.
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
___________________________________________
venussoftop@gmail.com
___________________________________________
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform