Error when using Database Expert to log on to SQL Server database?

[Former Member]

Hi,

I am using "SQL Server Native Client 10.0" in Database Expert (of Crystal Reports 11) to log on to SQL Server 2005 database.

When I make a new connection via OLE DB(ADO), after providing connection information and going to the next step, there is error like:

Logon failed

ADO Error Code: 0x80040e73

Source: Microsoft OLE DB Service Components

Description: Format of the initialization string does not conform to the OLE DB specification.

How to deal with this?

Thanks in advance.

[Former Member]

Thank you.

[former_member11696]

Hello,

Crystal Reports XI does not support MS SQL Server 2008. Reason being MS changed the name of the client dll to SQLNCLI10.dll. CR XI only supported the SQLNCLI.dll which is include with MDAC. SQL Server 2008 as you know requires the Client tools to be installed, MS doesn't support any other connection included with MDAC and WDAC.

CR XI only supported the SQL Server for ODBC and MS SQL Server OLE DB Provider for a OLE DB connection.

Only option is to stay on SQL 2005 or less or upgrade to CR XI R2 SP 4 and SP6 and Fix Pack 6.4. You can do so for free, use your XI Keycode to install.

You'll find the downloads on our download page above or .

Don