>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")

*I dont see the RecordString
oREC=CREATEOBJECT('ADODB.RecordSet')
lcRecordSource=[SQLEXEC(NHANDLE,"SELECT * FROM TEST2","CURRS")]
oREC.SOURCE=lcRecordSource
oREC.OPEN

>*****
Check out the ADO Query Ananlyzer in downloads.
>
>
>========== 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 ?