Hi,

I am making an application that needs to connect to an sql database, using the database connection wizard, on a remote server. When i type in the path of the database it comes up with a message saying "Attempted to access a path that is not on the disk". How would i connect to this database

you need to give more details in what you would like to do :-) There are also many examples on these forums so try a search and I'm sure you will find the answer.

Please explain in depth what you want to do to better provide you with a solution

you can get and set data from records returned from a query, thats not a problem. It also depends the approach you are wanting to do. For example you can use a SqlDataReader (for SQL, or OleDbDataReader for OleDB connections such as to MS Access) to read data returned from the query that was executed, and then manually handle the data.

Or you can use a DataAdapter to fill the results returned from a query into a dataset and then bind them to say, a datagridview to show results to the user as well as the ability for them to add, delete and remove existing records and finally updating them to the database.

Check this link out on how to do the above, I hope it is of some use to you

http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=753872&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=728535&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=728103&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=634276&SiteID=1

Please feel free to post back if you have any queries at all! :-)