Hi,
i am not able to use fileDSN for ODBC connections to a SQL server in LC
Windows. Under Mac i did not test it already.
With fileDSN you define all the odbc settings/parameters in a file with the
suffix .dsn.
When connecting using ODBC you can then use that dsn file. No need to setup an
ODBC configuration.
Is anyone using it with success?
I´ve setup the fileDSN correctly in ODBC Manager in Windows to use the folder
"c:\users\matthias\documents" as fileDSN folder
The folder contains a file test.dsn
In LC Windows i tried to connect with a connection string, but getting
different errors.
with
get revOpenDatabase("ODBC","FILEDSN=c:\users\matthias\documents\test.dsn",,,)
i am getting this error:
[Microsoft][ODBC Driver Manager] Ungültige Zeichenfolgen- oder Pufferlänge
In English something like this: Invalid string or buffer length
with
get revOpenDatabase("ODBC","FILEDSN=test.dsn",,,)
i am getting this error:
[Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und
es wurde kein Standardtreiber angegeben
In english something like this:
The data source could not be found and there was not default driver defined
and using the normal way using a DSN, where the dsn is the name of the fileDSN
get revopendatabase("ODBC","test",,"matthias","mypassword")
Error:
[Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und
es wurde kein Standardtreiber angegeben
In english something like this:
The data source could not be found and there was not default driver defined
Before i file a bug report about it i want to make sure, that no one is
successfully using fileDSN.
Regards
Matthias Rebbe
free tools for Livecoders:
https://instamaker.dermattes.de
https://winsignhelper.dermattes.de
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
