Announcement

Collapse
No announcement yet.

SQL server

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    SQL server

    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

    #2
    Sql

    Does anyone run mcsTemperature on MS SQL ?

    / Jonas, Sweden

    Comment


      #3
      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

      Comment

      Working...
      X