MS SERVER 2003
MS SQL 2000
WINDOW XP
VFP 8.0
Hi everyone
[ODBC] I can connect my MS-SQL and read file as below coding:-
*****
LOCAL NHANDLE AS NUMBER, CSTRING AS CHARACTER
CSTRING="DRIVER=SQL SERVER;SERVER=FILE1;UID=Administrator;PWD=888;DATABASE=TEST1"
NHANDLE=SQLSTRINGCONNECT(CSTRING)
=SQLEXEC(NHANDLE,"SELECT * FROM TEST2","CURRS")
*****
========== QUESTION 1
[ADO] BUT IT CAN NOT CONNECT WHEN CODING AS BELOW :-
*****
LOCAL OCONN AS ADODB.CONNECTION
OCONN=CREATEOBJECT("ADODB.CONNECTION")
OCONN.OPEN("PROVIDER=SQLOLEDB.1;DATA SOURCE=FILE1;INITIAL CATALOG=TEST1;UID=Administrator;PWD=888;TRUSTED_CONNECTION=NO")
ORECORDSET.MOVEFIRST()
RELEASE ORECORDSET
*****
>>>> Error message :
OLE IDispatch exception code 0 from MS OLE DB Provider for SQL Server: Login failed for use "Administrator": Reason: Not associated with a trusted SQL Server connection...
=========== QUESTION 2
I through VPN to login Server and sun my system ( use SQLSTRINGCONNECT() to open SQL-file)
i need to wait for over 40 sec. to open the first file, is't something wrong on my coding ?
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