Hi Al,
Thanks for your time , but even connect with ODBC wizard is also a problem returning -1 sql server error.
>>Hi Everybody,
>>
>>Could anyone can help me why i cannot connect to MS SQL Server 2005 from visual 2005?
>>Do I need some setup in my VFP 7.0?
>
>1. Make sure your SQL Server is configured to accept connections via TCP/IP (by default, 2005 is not)
http://support.microsoft.com/kb/914277>
>2. Make sure any firewall running on the SQL Server computer is also configured to allow incoming traffic to SQL Server (default is port 1433). Configuring Microsoft firewalls in the above link
>
>3. Check your connection strings at
http://www.connectionstrings.com
All men by nature desire knowledge.
Aristotle (384 BC - 322 BC), Metaphysics