Has anyone used revOpenDatabase to connect to an MS SQL database?
I have been trying to open an ODBC connection using this:
put revOpenDatabase("ODBC","DRIVER=SQL Server;SERVER=" & tServerAndPort &
";DATABASE=" & tDBname & ";UID=" & tUser & ";PWD=" & tPsw &
";Trusted_Connection=No",,,) into dbIDThe server connects on port 55999 so
tServerAndport contains "theServerIPaddress:55999".
I get this error msg in return:
[Microsoft][ODBC Driver Manager] Invalid string or buffer length
If only the server IP is provided in the second argument, the resulting message
is:
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
The docs says that port is only used only for MySQL an Postgree.
Does that mean I cannot use revOpenDatabase to connect to an MS SQL database on
a specific port?
I am using LC 5.5 on Windows.
/Mats
_______________________________________________
use-livecode mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
