Connection toa remote SQL server
Posted on 2000-01-04
I got a problem on connecting SQL server from Visual C++ 6.0. I first open the project as a database project
Then I used 'add data connection' by right clicking on the project name...
then selected open source dialog box comes out, I selected file data source tab afterwards.I chose new and sql server afterwards. 'Create new data source' dialog box came out, I entered a new name for the source afterwards.
'Create a new data source to SQL server'
dialog box came out afterwards, In the 'Which SQL server do you want to connect to?' question, I entered the host number afterwards... I used next button without changes to 'How should SQL server verify the authenticity of login ID' and client configuration button.I pushed next button afterwards..
But the machine returned an error quoted
'Client unable to establish connection'
and 'unable to load communication module and driver has not correctly installed' resulted with ODBC SQL server dirver in brackets... Could anyone show me how to connect to the SQL server correctly... or show me some links about it??