Originally posted by: SystemAdmin

[MJEber said:]

The documentation for ILog says that Sql Server can be connected to.  However they do not provide any examples.
I created a DBConnection("MS SQL", "userID, password, database, server") which appears to be what the doc says to do.
However I get Invalid RDM error when I build it.

What is the proper syntax for connecting to a Sql Server 2005 database?
#DecisionOptimization
#MathematicalProgramming-General

Originally posted by: SystemAdmin

[vblanchard said:]

In the documentation, it says "OLE DB is used to connect to SQL Server 2005 database." ("Working Environment > Working environment > Supported databases"), so your DBConnection statement would be like:
DBConnection db("oledb", "user/password/database/server").

You may have a look at the documentation "Language Reference Manual > OPL, the modeling language > Data sources > Database initialization > Supported databases" that lists the various connection string for each database.
#DecisionOptimization
#MathematicalProgramming-General

Originally posted by: SystemAdmin

[MJEber said:]

Hi and thanks for the response.  I saw the documentation and read it over several times.  Unfortunately the examples were only for the simplest (excel, access) and the documentation was not straight forward with oledb usage.  That statement was listed under the Win64 table and in the table for Win32 it stated MS SQL ... format

Thanks for your help.  I'll get it in tonight!
#DecisionOptimization
#MathematicalProgramming-General

Originally posted by: SystemAdmin

[LeanderQuiring said:]

DBConnection db("oledb", "user/password/database/server") is just passing parameters that get inserted into a template connection string.  Is it possible to put the raw string in there somehow?  (i.e. I want to use a trusted server connection for SQLServer, instead of the standard authentication)
#DecisionOptimization
#MathematicalProgramming-General