Is Ms.Jet.OLEDB.4.0 faster than ODBC DSN ???

[Wen Lie]

Dear All,

I want to ask you guys about something. I've heard that Microsoft Jet OLEDB 4.0 is faster than using ODBC DSN. Do you guys think so ???

I've tried before to compare those two kinda connection, but, I've failed. My connection using OLEDB 4.0 is not work out.

Could you guys help me by telling me how to use Microsoft Jet OLEDB 4.0 ??? What reference should I use ??? Should I use Microsoft ActiveX 2.1 as my reference on VB or what ???

Thx, I accept any advice.
BRgds,
Wen Lie

[Serge]

If you're talking about Access database, then Jet4.0 is the fastest way, but if you're talking about ODBC databases such as SQL Server, Oracle, Sybase etc, then it is one of the slowest.

[Wen Lie]

Thx Serge,

Well, I thought Jet 4.0 is the fastest way for all, for Access, for ODBC Database (such as SQL Server, Oracle, etc).

If it's only the fastest way for Access, then, I would like to ask you question, If I may...

At office, I'm currently using SQL Server 7.0 as my database. And I connect to it by using ODBC DSN. Sometimes, my VB application run very fast. But, then sometimes, it runs very slow. Could you explain me why ???

Could you tell me, what aspects can affect my database application ???

Sometimes, I also use .DBF database file. And I also connect to it by using ODBC DSN. And the problem is still the same.

Do you think that ODBC has much problem in ADO connection ??? Can you suggest me other ADO connection that I can use, so my database application will run faster than now.

Thx, Needed help SOON

BRGds,
Wen Lie

[Clunietp]

Hi Wen

I never have performance issues when I connect to SQL server using the SQLOLEDB provider with ADO....

use the Jet 4.0 provider for MS Access, DBASE, Excel, Text and other desktop databases. don't use Jet with SQL server or Oracle (why would you??)

[Wen Lie]

Hi hi too Clunietp,

Well, just for your information, since the first time I used SQL Server, I always connect to it using ODBC DSN, and I think, it's not my best way, because, everytime I install my program on my client side, I always have to set the ODBC DSN first at client PC (I'm using ODBC Administrator from Control Panel to set my ODBC DSN).

Now, I want to use DSN-less connection. Could you or anybody tell me how to do it (how to connect by using DSN-less connection) ??? So, I don't have to set any ODBC DSN anymore. But, I also want faster connection than now.

I'll appreciate any kinds of help. Really appreciate.

Thx,
BRgds,
Wen Lie