sql express

Hot Topic

SQL Server Express 2005 fails to install
Buffer overflow exception in SSIS
Will a SQL Server embedded be developed?
Replication Field Size Error
Users Cannot Connect to SQL Server 2000 SP4 After Applying Hotfix (build 8.00.2148)
Sql Reporting Services problem
Execution of Package failed
Installing SQL 2005 SP1 on an imaged server
SQL Server CTP 16 - Failure to set maintenance plan
Wildcard Search - Column Value containing % character

SQL Server

Download December CTP?
URGENT: Data "Disappeared" from my AS2005 Cube
Windows Authentication
How to Insert or Update Records from Source to Destination using Oracle 8i DB
SqlServer 2005: How to test Cube Actions
Save Report to a shared file location through ASP
Full Text Issues
Assigning XML data to variables
SQLEXPRESS CREATE DATABASE
OpenRowset Table Provider.

sql express

Hi

We have a VB6 & mdac 2.8 app accessing a SQL database. We are moving clients from MSDE to SQLExpress - we notice that some calls to open the database in SQL Express take a couple of seconds - this never happens in the MSDE scenarios - the connection string is always the same.

Any ideas - we tell out clients SQL2005 is a good thing but it is proving to be slower - this happens when even we only have one user - so it's not a multi user thing.

thanks
Bruce

Answer this question

sql express

  • GKRAO

    Hi

    I'm asking whether you have noticed marked performance improvements in performance when using the native client

    Thanks
    Bruce

  • Dylan Smith

    Thanks for the reply - can I ask what do you base this answer on


    Thanks

    Bruce

  • TJSR

    Hi Bruce.
    I don't think I understood your qustion. does my recommendation solve your problem

    for differences between Native client and MDAC click here
    from my point of view, if I upgraded the server I have to upgrade the clients too even if there was a backward compatability.
    HTH


  • PawelWasilewski

    Hi,
    try to access SQL express using the native client instead of SQLOLEDB


  • sql express
Answer this question