Page 1 of 1
Real support for Microsoft SQL Server
Posted: Fri Dec 28, 2007 2:45 pm
by 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
Re: Real support for Microsoft SQL Server
Posted: Tue Jan 18, 2011 7:36 pm
by 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.
Re: Real support for Microsoft SQL Server
Posted: Tue Jan 18, 2011 9:37 pm
by 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
Re: Real support for Microsoft SQL Server
Posted: Wed Jan 19, 2011 7:40 am
by bangkok
scott47303 wrote: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.
Re: Real support for Microsoft SQL Server
Posted: Sun Jun 19, 2011 4:56 pm
by jesse
I would also like to see REAL MS SQL server supported.