ok, it's working now, i beleive connection has been created bcos now the handle is returning a positive number and there are no sql connection boxes.

can u advs me some test commands to try n get data as i'm very new to sql server.

i have created a dummy database called vinod and there is a table in that called zsample, how i can see all records in that table, pls advs...



>Can you create a DSN?
>
>
>>I Even tried that but result is same, not sure what i'm doing wrong which is creating this problem.
>>
>>
>>>Vinod,
>>>Easiest way id to create a DSN (Administration Tools->ODBC) file, then create a connection, visual not through CREATE CONNECTION. choose this DSN ans SELECT Connection string. The the right connection strig will appear.
>>>
>>>
>>>>I Have installed following on win xp Home edition :-
>>>>
>>>>1. SQL 2000 (Client and Connectivity option was allowed), installed this from Win 2003 SBS Server Premium technologies CD.
>>>>
>>>>2. MSDE 2000 provided on VFP 9 CD. Installed with a SAPWD parameter and give password.
>>>>
>>>>Finally using windows authentication i was able to detect the dummy server, SQL server Service is started and using Enterprise Manager i was able to create a dummy database also.
>>>>
>>>>But my all attempts of connecting through VFP were failed, not sure where the things are wrong.
>>>>
>>>>i'm using following lines to do this connection, username and password used are same of the admin user in which i'm logged in my computer and even i created a new user with same name and password and gave access of all the files :-
>>>>
>>>>ConnStr = [Driver={SQL Server};Server=(vinodhome);Database=(vinod);UID=vinod;PWD=mypass;]
>>>>Handle = SQLStringConnect( ConnStr )
>>>>
>>>>but it is again n again showing me following :-
>>>>
>>>>Sql server doesnot exist or access is denied.
>>>>
>>>>Pls help.