Re: Database access from a VB project

Tech-Archive recommends: Fix windows errors by optimizing your registry

I'm sorry to came back to this forum but I still have the same problem.
On the adviced videos, I note that the user indicated a SQL Server name and,
after, select a *database name* on this server.
This is exactly what I want.
In my VisualStudio 2008 Express Edition, I cannot select a database server
or a database name; I can only select a *database file*.

Do you have an solution ?

Thanks,
Alain.



"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)> a
écrit dans le message de news: %2343ZYfneIHA.4312@xxxxxxxxxxxxxxxxxxxxxxx
Here's a good set of videos from Beth Massi to get you started:
http://code.msdn.microsoft.com/vbvideosdata

Start with « Forms over Data Video Series » and download them on your PC
to have a better viewing experience.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"Alain" <aca1024@xxxxxxxxxxx> wrote in message
news:uretHAheIHA.4704@xxxxxxxxxxxxxxxxxxxxxxx
Hello everybody.

I'm learning to create projects in VB.NET with VisualStudio.NET 2008
Express Edition.
I would like to access to a database from my project.
I have a SQLServer 2005 Express Edition installed on my PC and I have
created a "test" database with some tables.

In VStudio.NET, I would like to create a database connection to my "test"
database with the Database Explorer but I can't find how!
The Database Explorer propose to me to open a *file* and not a
*database*.

When I created ASP.NET projects, some times ago, the Database Explorer
proposed to me the list of the *database* avalaible on my network, not
files!

Would you help me ?

Thanks ain advance,
Alain from Belgium.

PS. I work with Windows XP.






.

Relevant Pages

  • Re: Flummoxed by Connection Problem
    ... If I close the connection to the database in VB2005 Database Explorer and then restart the server my project works again. ... Boot up the pc and go into SQL Server Management Studio. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Flummoxed by Connection Problem
    ... If I close the connection to the database in VB2005 Database Explorer and then restart the server my project works again. ... Boot up the pc and go into SQL Server Management Studio. ...
    (microsoft.public.sqlserver.connect)
  • Re: Flummoxed by Connection Problem
    ... If I close the connection to the database in VB2005 Database Explorer and then restart the server my project works again. ... Boot up the pc and go into SQL Server Management Studio. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Flummoxed by Connection Problem
    ... If I close the connection to the database in VB2005 Database Explorer and then restart the server my project works again. ... Boot up the pc and go into SQL Server Management Studio. ...
    (microsoft.public.sqlserver.clients)
  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)