Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Connection

Status
Not open for further replies.

skaskas

Programmer
Mar 13, 2002
14
US
Hi There,

What is the best way and fastest to connect to a SQL server.

Thru Remote Views
or
=SQLEXEC(......) and other SQL...() commands

Please advice

Sal
 
Here's my two cents...

There are certain factors in determining the "best" way. Do you need up to the minute info? If so, then ODBC would probably be good, although it can be slower because every time you open the app you create a new connection. If not, then the program will run faster most likely if you just use a connection string.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top