First, though, be sure your SQL Server instance can accept connections from remote computers.
Odbc driver for sql server 2008 express install#
To connect from an ArcGIS Pro project to SQL Server, install the Microsoft ODBC driver for SQL Server on the ArcGIS Pro machine and create a database connection. To publish ArcGIS Server web services that reference the data in your SQL Server database, register the database connection file with your ArcGIS Server sites. Once the SQL Server ODBC driver is configured on all your ArcGIS client machines, create a database connection file.
Odbc driver for sql server 2008 express windows#
Oracle 10g (10.2.0.5) Windows Server 2012 or 2008 Oracle ODBC Driver 11.2.0.To connect to Microsoft SQL Server from an ArcGIS client, install a supported Microsoft SQL Server ODBC driver on the ArcGIS client machine and connect to the database from the ArcGIS client.
SQL Server 2005 Windows Server 2008 SP2 ODBC Driver. SQL Server 2005 Windows Server 2008 R2 SP1 ODBC Driver. SQL Server 2005 Native Client 9.0 (SNAC 9) SQL Server 2005 Windows Server 2012 ODBC Driver. SQL Server 2008 (SP3, or R2 SP2) Windows Server 2008 SP2 ODBC Driver. SQL Server 2008 (SP3, or R2 SP2) Windows Server 2008 R2 SP1 ODBC Driver. SQL Server 2008 Native Client 10.0 (SNAC 10) SQL Server 2008 (SP3, or R2 SP2) Windows Server 2012 ODBC Driver. SQL Server 2012 Windows Server 2008 SP2 ODBC Driver. SQL Server 2012 Windows Server 2008 R2 SP1 ODBC Driver. SQL Server 2012 Native Client 11.0 (SNAC 11) SQL Server 2012 Windows Server 2012 ODBC Driver. Microsoft SQL Server 2008 R2 SP2, Express Edition (delivered with ProjectWise Server Setups) Microsoft SQL Server 2012, Express Edition ProjectWise Orchestration Framework Service supports the following database engines: Oracle Database 10g (10.2.0.5), Standard / Enterprise Edition Oracle Database 11g (11.2.0.3), Standard / Enterprise Edition Microsoft SQL Server 2005 SP4, Standard / Enterprise Edition Microsoft SQL Server 2008 SP3, Standard / Enterprise Edition Microsoft SQL Server 2008 R2 SP2, Standard / Enterprise Edition Microsoft SQL Server 2012, Standard / Enterprise Edition ProjectWise Integration Server supports the following database engines: Also we have noticed that for best ProjectWise performance be sure to set the max degrees of parallelism to 1 when it comes to SQL but this is good for any traditional configuration not just what you are attempting to do. I would recommend testing it first before putting it into production. Yvonne, we do not certify using compatibility mode however I do believe it could work. In other words: is the setup SQLEngine 2014 (or 2016) and the projectwise databases in compatmode 110 (SQL-2012) allowed ? This allows us to choose a recent SQL Engine version and run the database in the supported version needed by the application (and vendor support). SQLserver has a feature called compatibility mode, what basically means that within the SQLDatabaseEngine a database can run (act) as a specific version. Is compatibility mode which the SQLDatabaseEngine allowed ? What SQL versions are supported with ProjectWise SS4RU (8.11.11.590)? One of those applications using our current SQLserver 2008R2 database platform is: ProjectWise. Well…, the answer lies within the supported database version of our application… The current possible SQLDatabases platforms are: SQLserver 2012, SQLserver 2014 and SQLserver2016 Together with the technical server platform setup the following question arises: What will our next SQL Platform Engine be? Recently we (DBA) started a new project called “Upgrade and Migrate SQL platform”.
0 kommentar(er)
