I tried this with my MS-SQL Server and it works after changing the port
to 55999
put "192.168.178.67,55999" into aPrefs["DBServer"]
put "myDB" into aPrefs["DBDatabase"]
put "sa" into aPrefs["DBUser"]
put "myPassword" into aPrefs["DBPassword"]
put revOpenDatabase("ODBC","DRIVER=SQL Server;SERVER=" &
aPrefs["DBServer"] \
& ";DATABASE=" & aPrefs["DBDatabase"] & ";UID=" & aPrefs["DBUser"] \
& ";PWD=" & aPrefs["DBPassword"] \
& ";Trusted_Connection=No",,,) into tDB
If you provide a connection string like that, you don't have to create a
DNS.
Wolfgang
Am 16.04.2013 13:23, schrieb Mats Åström:
Hi Wolfgang,
thank you very much for taking time.
I tried the syntax you provided, but it seems I got it wrong, please bare with
me.
Lets assume this:
server IP address is 123.45.67.89
port is 55999
I got it to:
put revOpenDatabase("ODBC","DRIVER=SQL Server:SERVER=123.45.67.89,55999, ...
but that does not work - still the same error msg.
/Mats
Hallo Mats,
the correct syntax for the SERVER part is
Server= [protocol:]Server[,port]
hope this helps
Wolfgang
_______________________________________________
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
_______________________________________________
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
