November 8th, 2004, 11:35 PM
|
#2 (permalink)
|
| Member
Join Date: Oct 2003
Posts: 255
|
First off Microsoft doesnt allow you to connect with anything but the enterprise edition I think. I have the normal vb.net and it doesnt let me because its not a microsoft product basically. But here is how to do it. Open a new exe or form. Create the odbc connection using adminstrator tools under control panels or the start menu. Next on the form you just created create a oledb connection. Under connection string of the oledb connection create a new string. use the ole db provider for odbc drivers. hit next and fill in the data source. Next on the form create a oledbdataadapter. ON the bottom of the screen below the form right click on the data apater and click configure. Follow the following steps to get the database. The last step is to create the dataset members. So creat that. And you should be set. Im sure u will have questions. |
| |