SQL Error

[madmax]

I am trying to set up mcsTemperature with SQL. When I try, I get the following message:

8/13/2005 9:19:40 PM - mcsTemperature - CreateEnvironment on line 270 Line 1: Incorrect syntax near '.'.


Any Tips?

[Michael McSharry]

The reference line is below. It looks as if the database name entered for the Forecast may still be in the path format used for Access rather than the single name used for SQL.

270 objConn.Execute "CREATE DATABASE " & gForecastDatabase