Add Connection to ADO Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Im trying to create a connection to A database in Visual Studio.Net. I
select Tools->Connect to Database. Nothing happens. Im trying to connect a
data source to my datagrid, but not even able to connect to the database I
want to.

Any suggestions will be appreciated.

Thanks.
 
View the Toolbox, click on the Data tab, and drag a Connection object onto
your form. Use the wizard to walk you through making the connection.
 
1. You will need to have a Database installed on your PC or server first. It
can be MS/SQL, MSDE, Access and or Oracle.
2. Use other tools such as MS/SQL Analyzer (if you use MS/SQL Server) to
make sure it is working.
3. Then finally, you can use VS.Net /Data tab to discover your DB
connection.

An MS/ SQL server connection is quite. By dropping a SQL Connection on your
webform/winform, it will not say anything unless you invoke the connection
wizard. May be you missed this step ?

John
 
Earl, I try doing this way via the toolbox, but Im not able to see any
DataConnections when configuring the Data Adapter and also does not allow me
to create any new data connections. When I select New Connections in Data
Adapter Configuration Wizard, nothing happens. Any suggestions will be
appreciated.

Thanks.
 
WJ, actually Im trying to connect to Microsoft Access database. Im not able
to create any new connections. When I select "Add New Connection" in the
Server Controls, nothing happens. Any suggestions will be gladly appreciated.
 
Hei Haddalla - I think I have a problem like yours -did you ever solve it??
thanks ,Viking
 
Viking, I could not use Tools->Connect to Database to create the database
connection. I had to write some code within the application to do the
connection on loading the form.
 
Hei - I have found the solution , thanks to help support within Microsoft.
The help was actualy fantastic. The problem is due to miss-match of MDAC
components. In my case I had to adjust the registery, remove some ADO
components, and then reload MDAC 2.8. (in safe mode).
Viking
 
Hey Viking,

Please let me know what you changed in the registry or if you can point me
to the web site where I can get this info. Thanks for your help.

habdalla
 
Back
Top