SQL server

[jonas.hellgren]

I would like to use MS SQL insted of access with mcs Temperature.
What is the syntax to write on the line "Use SQL with server"
Do i need to change any thing in the ini file.

/ Jonas, Sweden

[jonas.hellgren]

Sql

Does anyone run mcsTemperature on MS SQL ?

/ Jonas, Sweden

[Michael McSharry]

I have run it with Microsoft SQL Server. There is a dramatic improvement in chart draw times when the database becomes larger.

There is a setting to use SQL and if you have a specific server name that you would like to use rather than the default for your system then you can enter that into the source text box in the setup.

The actual provider syntax that I use to get access to is

"Provider = sqloledb; Integrated Security=SSPI; Data Source =" & SQLSource & "; Initial Catalog="

and when the connection is open I use this syntax

objConn.Open DBProvider & gForecastDatabase

In the above example SQLSource is the name of the server that can be entered on the setup. gForecastDatabase is the name of the database that is entered by the user. Note that the forecast and temperature databases will have .mdb names entred by the user for Access and the names will not have a type suffix if SQL Server is used