Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
I want to learn SQL server to make projects through this. Sofar I am doing VB6+MS Access. Here after I want to do with VB6+SQL Server 2005.
I am 'L' Board for SQL Server.
1. I have installed MS SQL Server 2005. then I tried to create DSN for the same. But refuses to create showing error '10061'. What i did to create a DSN is as follows:
1. ODBC->System DSN->Add->SQL Server->
Description=DSN for SQL Server
Server = localhost
-> 'With SQL Server authentication using a longin ID and password entered
by the user.'
-> Client Configuration -> dynamically determine port -1269->ok
->checked - 'Connect to SQL Server to obtain default settings for the
additional Configuration option.'
--> login ID : masi
then on pressing 'Next' Button shows error like this.
SQL State : '01000'
SQL Server Error :10061
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Connection Open (Connect()).
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] SQL Server does not exist or access denied.
Pls help to clear this problem.
0 · ·