Information générale
Titre:
Different ways to connect to SQL server
I am trying to get some benchmarking information for an upcomming project concering a VFP application that uses SQL server as a back end. What we have now is an ODBC connection that is called using the SQLCONNECT() and SQLEXEC() functions. What I need to deterine is, is this the fastest and most efficient manner to retrieve a set of information?
Things that I have to consider:
1. ODBC vs. OLE?
2. If I use OLE, how can I mimic the functions that I am currently using?
3. Is there a better way of accessing a portion of data froma SQL table other than what has been used now, i.e. ado object or cursor adapter?
4. If I use these other avenues how would I call a stored procedure and return the results?
What I need is just a good starting point so I can run some tests and make an informed decision.
Thanks in advance
Kelly
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement