Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi all:
I'm trying to create a connection object based a connection string. I want to use something like the following connection string...
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=login_name;Initial Catalog=master;Data Source=ComputerName
where I use an appropriate User ID (there is no password for the ID I'm using) and I put my computer's name in for Computername. I have SQL Server 2000 install on my Win2k Machine. When I use sqlstringconnect() or modify connection (and modify and existing connection based on a dsn) and try to use this connection string, it brings up the "select data source" prompt. It works find if I use a dsn, but I'm told there is a performance advantage in using SQLOLEDB as opposed to ODBC based dsn. Does the connection string have to be based on an ODBC dsn in VFP? Thanks in advance.
-Josh
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