Real support for Microsoft SQL Server

[matthiasr]

Hi,

are there any plans to support Microsoft SQL Servers?

I know, i can connect to MS SQL via ODBC, but a direct connections is always better and would avoid problems with ODBC configuration.

MS SQL servers are more and more common / wide-spread.

Matthias

[scott47303]

I would like to bring this request up to the top. A built in connection driver would be very useful, especially on web deployment of apps so i don't have to set up ODBC on every machine that uses the app.

[trevordevore]

Just a side note - to avoid configuring ODBC on each platform you can pass in an ODBC connection string to revDB. Here is some code stripped from a project that should give you an idea of how to build the string. You would then use the resulting string as the revOpenDatabase 'host' parameter.

Code: Select all

switch the platform
   case "macos"
	  ## URL is for OpenLink
	  put "DRIVER={" & sProjectA["database connection"]["odbc driver"][the platform] & "}" & \
			 ";URL={ServerType=1;ServerName=" & urlExtractHost(sProjectA["database connection"]["odbc_host"]) into theString
	  if urlExtractPort(sProjectA["database connection"]["odbc_host"]) is not empty then 
		 put ";PortNumber=" & urlExtractPort(sProjectA["database connection"]["odbc_host"]) after theString
	  end if
	  put ";DatabaseName=" & sProjectA["database connection"]["database name"] & \
			 ";XaEmulation=false;};READONLY=No" & \
			 ";SERVER=" & urlExtractHost(sProjectA["database connection"]["odbc_host"]) after theString
	  if urlExtractPort(sProjectA["database connection"]["odbc_host"]) is not empty then 
		 put "," & urlExtractPort(sProjectA["database connection"]["odbc_host"]) after theString
	  end if
	  put ";DATABASE=" & sProjectA["database connection"]["database name"] & \
			 ";UID=" & sProjectA["database connection"]["username"] & \
			 ";PWD=" & wgdb_decryptString(sProjectA["database connection"]["password"]) & \
			  "" after theString
	  break
	  
   case "win32"
	  put "DRIVER={" & sProjectA["database connection"]["odbc driver"][the platform] & "}" & \
			 ";SERVER=" & urlExtractHost(sProjectA["database connection"]["odbc_host"]) into theString
	  if urlExtractPort(sProjectA["database connection"]["odbc_host"]) is not empty then 
		 put "," & urlExtractPort(sProjectA["database connection"]["odbc_host"]) after theString
	  end if
	  put ";DATABASE=" & sProjectA["database connection"]["database name"] & \
			 ";UID=" & sProjectA["database connection"]["username"] & \
			 ";PWD=" & wgdb_decryptString(sProjectA["database connection"]["password"]) & \
			  ";Trusted_Connection=No" after theString
	  break
end switch

[bangkok]

I would like to bring this request up to the top. A built in connection driver would be very useful, especially on web deployment of apps so i don't have to set up ODBC on every machine that uses the app.

There is another solution : a socket server.

Client apps on the local network send SQL query to the socket server, on which you have configured the ODBC connection. The socket server launches the queries to the MS SQL server, and then sends back the result to clients.

[jesse]

I would also like to see REAL MS SQL server supported.