SQL Connection

[djjohnny]

Hi

I am new to sql server and VB for that matter. I have SQL server running on a NT box. I need to connect to the database on the server with a dataEnvironment Connaction (I think I said that right) I can do this with the database on my System but not the one on the nt box. I can work with the tabels on the server thru the Enterprise manager . Any one know what I am doing wrong.

Thanks
John

[jbart]

Make sure you have set up a Data Source to SQL by using the Data Sources Control Panel.

Then in your DataEnvironment, right-click on Connection1 and choose properties to set up your Data Link Properties. Choose your DB Provider and under Use Data Source Name your data source connection should appear. After choosing your data source, click on test connection to make sure it is working.

Now, right-click on Connection1 in the DataEnvironment and choose Add Command. Right-click on Command1 and choose properties. From here you will be able to choose which table you want to use, and set up SQL if you need to.

That should do it. You might want to rename the objects in the DataEnvironment to shorter names. DE1 instead of DataEnvironment1, etc.

[djjohnny]

The problem is that when i go to the set up the connection the server name is not there . the only server that shows is my desk top ( were I have sql server installed also) any clue ?

thanks
John

[jbart]

Things you might check:

Make sure you can see an entry for the connection in your ODBC Control Panel. If not, try adding a connection. Look under the System DSN tab for the connection.

If you cannot see the server when trying to add the connection, your SQL Administrator may need to check to make sure your rights are correct.

Other than that, I cannot think of anything else to look at.

Good luck !