CR2008 SP3 - Date fields are mapped as a string length 10

[Former Member]

Sorry for the really poor English.

I created a new connection to a database in SQL Express 2008 with:

OLE DB (ADO)

Microsoft OLEDB Provider for SQL Server.

And here I see the problem.

The fields in the database are of type Date (not DateTime), Crystal map them to me as a String of 10.

Why?????

How do I make that Date fields are mapped as Date (only date)?

If, while creating the connection, rather than choose "Microsoft OLEDB Provider for SQL Server" choose "SQL Server Native Client 10.0", Crystal map fields as datas and if I go to format the field treats him as a date.

I've always used "Microsoft OLEDB Provider for SQL Server." It is fair to use this, or is more correct to use "SQL Server Native Client 10.0"?

Thanks in advance to all those who will help me.

Oscar

[former_member11696 · Accepted solution]

Hi Oscar,

For MS SQL Server 2008 CR works best with the Native 10 driver so use it. Microsoft doesn't support MDAC with SQL 2008.

Thank you

Don

[Former Member · Accepted solution]

Hi Don,

I will follow your advice and use Native 10.

The Native 10 drivers are installed with SQL SERVER 2008, or with the CR?

Many thanks to you.

Oscar

[former_member11696 · Accepted solution]

Hi Oscar,

CR doesn't install any clients. With MS SQL Server 2008 it no longer uses the default MDAC install that every update to Windows puts on your PC. MS SQL Server 2008 now comes with a Work Station Client Tools installer. You can look on MS's web site, they have a stand alone MSI client tool install for you to distribute or ask your users to install from.

Thank you

Don

[Former Member · Accepted solution]

OK Don,

thank you very much.

Bye Oscar