Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

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.

SQL Server 2005

masipromasipro Posts: 2Member
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->
Name =myDSN
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
-->Password: masi123

then on pressing 'Next' Button shows error like this.

Connection failed:
SQL State : '01000'
SQL Server Error :10061
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Connection Open (Connect()).
Connection failed:
SQLState: '08001'
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.
Thanks

masipro


Sign In or Register to comment.