Announcement

Collapse
No announcement yet.

SQL server

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

  • Michael McSharry
    replied
    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

    Leave a comment:


  • jonas.hellgren
    replied
    Sql

    Does anyone run mcsTemperature on MS SQL ?

    / Jonas, Sweden

    Leave a comment:


  • jonas.hellgren
    started a topic SQL server

    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
Working...
X