Select to view content in your preferred language

Create Direct Database Connection: SQL Server 2008

2226
2
05-16-2013 03:58 AM
PeterWilson
Frequent Contributor
I've never had to connect to an enterprise database (SQL Server 2008) before and please note the database that I'm trying to connect to is not a spatial database. I want to connect to the following database to retrieve records that I can generate spatial data from. The records are of Police incidents that contain coordinates of the location of each incident and the particulars of the incident. I want to use the following information to start analyzing  crime.

I've been provided with the IP Address of the SQL Server (2008)  as well as a User Name and Password .

When I try to create a database connection from within ArcCatalog I receive the following error message:

I've attached a print screen of the database connection parameters that I'm entering as well as the error message.

I have asked the Database Administrator to change the compatibility of the particular database that I'm trying to connect to (IMSWarehouse) to level 90 (SQL Server 2005), but I still receive the same error.

Any advice in how I can create a direct connection to the following database will be appreciated.

Regards

NB: I'm currently running ArcGIS 10.1 with SP1
0 Kudos
2 Replies
VinceAngelo
Esri Esteemed Contributor
You're probably looking for an ODBC or other pure database connection.  Direct Connect
will only work against databases with an ArcSDE geodatabase install.

- V
0 Kudos
by Anonymous User
Not applicable
Original User: asrujit

Peter,

Please download and install a current SQL Server Native Client and then the connection should work fine.

Microsoft® SQL Server® 2008 R2 Feature Pack
http://www.microsoft.com/en-in/download/details.aspx?id=16978

Look for "Microsoft® SQL Server® 2008 R2 Native Client" under Install Instructions. Download and install that.

Hope this helps!

Regards,
0 Kudos