Unable to conect to SQL Server 2008 from a client application

_{Saturday, November 22, 2008 1:15 AM}

Hello:

I am running SQL Server 2008 on a 64-bit Windows 2008 Server.

When I try connecting to the database from a client software (ERWin), I get the following error message:

DAX000: Unable to locate client connectivity software sqlncli.dll(Native ODBC Connectivity).  Check with your SQL Server 2005 database administrator to install the appropriate client software.

Do I need to do something special to connect to the database?

venki

_{Thursday, January 8, 2009 12:52 AM ✅Answered}

It looks like this warning/error is coming because of some ERWin behavior, and your problem is no longer with SQL Server Data Access but rather with the ERWin app.  Probably you will have more luck asking about this on ERWin forums or through ERWin's support.This post is provided 'as is' and confers no express or implied warranties or rights.

_{Thursday, December 4, 2008 7:58 PM}

Did you ever get past this problem?  looks like it remains unresolved - I am having the same problem.

v-jebri

_{Friday, December 5, 2008 5:22 PM}

In the SQL 2008 Readme file, it has this information about the Native Client.  Either the second or third bullet looks like it would clear up your issue.

SQL Server 2008 uses a different version of the SQL Native Client from the one included in SQL Server 2005. (SQL Native Client is called SQL Server Native Client in SQL Server 2008.) Therefore, Integration Services packages that use SQL Server Native Client and were created in SQL Server 2005 cannot run automatically in SQL Server 2008. To run these packages, follow one of these steps:

• Run the SSIS Package Upgrade Wizard to upgrade packages and update the connection strings.
• On the computer that is running SQL Server 2008, install SQL Native Client (sqlncli.dll) from SQL Server 2005.
  Expand table

  Note:
  You can install SQL Native Client side by side with SQL Server Native Client.

• Revise the connection strings in the package to specify SQL Server Native Client. To revise the connection strings, replace SQLNCLI with SQLNCLI10.

_{Monday, December 22, 2008 6:21 AM}

1. Is your application 32 or 64 bit?
2. Check if you installed the sql native client? (windows\system32\sqlncli.dll or under syswow64)

I guess the issue maybe your app is 64 bit and you only install the 32bit sql native client.

_{Tuesday, January 6, 2009 7:45 PM}

Rhonda:

How do I install the 2005-version of SQLncli.dll? Where do I get it?

Venki

_{Tuesday, January 6, 2009 7:46 PM}

Ying:

ERWin is a 32-bit application. As I said, when I create the ODBC link, the link test successfully. But I encounter the problem only when I try to use this ODBC link from within ERWin.

Venki

_{Tuesday, January 6, 2009 11:45 PM}

Rhonda:

I was able to locate and download the SQL Server 2005 version of SQLNCLI.DLL.

Now, I am able to connect to the Server in ERWin.

I am able to do forward engineering (ie. create tables in SQL Server from within ERWin).

But when I do a reverse engineering, it connects but it does not create the data model. Instead, I get the following message:

Advisory File Created 06 Jan 06:41:48 PM

<Level=0><Information> Reverse Engineer

<Level=1><Successful Transaction> Set Property: SQLServer Assembly Ref

Object type identifier = 1075838983

Object id = 188

Property type identifier = 1075850656

<Level=2><Information> ESX-1015: SQLServer Assembly Ref has been removed due to an incompatibility with the value of property SQLServer Assembly Ref.
  [Domain:hierarchyid] [Property:SQLServer Assembly Ref]

Object type identifier = 1075838983

Object id = 187

Property type identifier = 1075850656

<Level=1><Successful Transaction> Set Property: SQLServer Assembly Ref

Object type identifier = 1075838983

Object id = 189

Property type identifier = 1075850656

<Level=2><Information> ESX-1015: SQLServer Assembly Ref has been removed due to an incompatibility with the value of property SQLServer Assembly Ref.
  [Domain:geometry] [Property:SQLServer Assembly Ref]

Object type identifier = 1075838983

Object id = 188

Property type identifier = 1075850656

<Level=1><Warning> REDB-1022: Database error: [Microsoft][SQL Native Client][SQL Server]Database '' does not exist. Make sure that the name is entered correctly.

<Level=1><Warning> REDB-1022: Database error: [Microsoft][SQL Native Client][SQL Server]An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.

<Level=1><Warning> REDB-1009: Error 105 for UseDatabase on 'SQLServer Database' at Location .\DAXConnection_SQLServer2005_ODBC.cpp

I am using the same ODBC DSN to create the tables.

Venki

_{Saturday, June 25, 2016 12:17 AM | 2 votes}

Holas: 

El problema es al hacer conexion del modelo en ERWIN con la Base de datos en SQL 2012/2014. El tema es que ERWIN solo da compatibilidad con SQL 2005/2008, para ello debes instalar sqlncli.dll del 2007, descargar desde: https://www.microsoft.com/en-us/download/details.aspx?id=24793, seleccionar sqlncli.msi y lo instalas, luego salir del ERWIN totalmente y volver a iniciar, luego ir al modelo fisico y ya queda solucionado. La conexion se hace sin problemas y queda solucionado. Espero que les sirva. tks.

_{Sunday, May 28, 2017 5:26 AM}

It Works!

Thanks dude.