Direct access to MSDE tables without providers

Hi,

How can get direct access to MSDE tables without providers?

Thank's
Alexei

You need a data access provider for accessing the database.

HTH, Jens Suessmeyer.

|||

Hi,

I am coding in c# with oledb to access to MSDE. I have also tryed to use SQLClient. But it still littly slow. Where can I get another one?

Thank's
Alexei

|||

The SQLClient is the prefered and the fastest one. Perhaps there is a problem within your configuration in your msde.

HTH, Jens Suessmeyer.

|||

Hi,

Can you tell me what is preferred configuration for using queries on 1 million of records?

Thank's
Alexei

|||There is no switch for bringing sql server to lightning speed (although SQL Server is very fast coming out-of-the-box), its more a less a combination of designing the database you code the infrastructure and the indexes.

Look at http://www.sql-server-performance.com/ for more information, this is a good starting point.

HTH, jens Suessmeyer.