Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADO vs. SPT, a benchmark test...
Message
From
22/06/2001 18:06:34
 
 
To
22/06/2001 17:13:07
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00522283
Message ID:
00522685
Views:
10
>
>That's because OLEDB doesn't load the ODBC manager .. even when going through and ODBC driver. The ODBC manager is the slowest part of ODBC.

So, is the ODBC driver still involved to some degree, even when using OLEDB? I've had a few error messages with 'ODBC' in them, and was concerned that I was not actually using OLEDB like I am intending to. IOW, I need to *know* that I am actually using OLEDB. Here is how I am connecting...
oConnection = CREATEOBJECT("ADODB.Connection")
lcConnString = "DRIVER={SQL Server};" + ;
	"SERVER=orange;" + ;
    "DATABASE=testdb;UID=sa;PWD="
oConnection.open(lcConnString)
rutoh! Now you know the password!! :)
Steve Gibson
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform