is anyone able to use fileDSN for ODBC connections in LC?

[Matthias Rebbe]

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