revOpenDatabase server syntax

[G.W.Gaich]

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
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode