|
|
|
date: Thu, 28 Feb 2008 14:44:22 +0100,
group: microsoft.public.vstudio.development
back
Re: Database access from a VB project
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@TK2MSFTNGP03.phx.gbl...
> 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" wrote in message
> news:uretHAheIHA.4704@TK2MSFTNGP03.phx.gbl...
>> 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.
>>
>>
>
>
date: Fri, 29 Feb 2008 12:08:23 +0100
author: Alain
Re: Database access from a VB project
Hi, I just take a look again in more detail and I have noticed that in the
Add Connection dialog window, there is a choice for the "Data source" with a
button "Change..." at its right. This option might be hard to find because
its background is not white and is located just above the Database file name
or Server name.
If this Data source is set to "Microsoft SQL Server Database File
(SqlClient)" or to "Microsoft Access Database File (OLE DB)", then you
cannot select a server, only a file name. Change the Data source to
"Microsoft SQL Server" (without the "Database File (SqlClient) denomination"
at its end) and you should be OK.
Because you have the Express version of Visual Studio, it's also possible
that you don't have access to this option. I don't know because I don't
have the Express version installed on my own machine.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"Alain" wrote in message
news:%23ugBoNseIHA.1208@TK2MSFTNGP05.phx.gbl...
> 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@TK2MSFTNGP03.phx.gbl...
>> 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" wrote in message
>> news:uretHAheIHA.4704@TK2MSFTNGP03.phx.gbl...
>>> 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.
>>>
>>>
>>
>>
>
>
date: Fri, 29 Feb 2008 13:50:09 -0500
author: Sylvain Lafontaine sylvain aei ca (fill the blanks, no spam please)
VisualStudio Express restriction
I noticed the "Change..." button but this doesn't help me.
I cannot select a database server.
I think it is a Express version restriction.
Does somebody can confirm this on this forum ?
Thanks in advance,
Alain.
"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)> a
écrit dans le message de news: eSTN%23PweIHA.2000@TK2MSFTNGP05.phx.gbl...
> Hi, I just take a look again in more detail and I have noticed that in the
> Add Connection dialog window, there is a choice for the "Data source" with
> a button "Change..." at its right. This option might be hard to find
> because its background is not white and is located just above the Database
> file name or Server name.
>
> If this Data source is set to "Microsoft SQL Server Database File
> (SqlClient)" or to "Microsoft Access Database File (OLE DB)", then you
> cannot select a server, only a file name. Change the Data source to
> "Microsoft SQL Server" (without the "Database File (SqlClient)
> denomination" at its end) and you should be OK.
>
> Because you have the Express version of Visual Studio, it's also possible
> that you don't have access to this option. I don't know because I don't
> have the Express version installed on my own machine.
>
> --
> Sylvain Lafontaine, ing.
> MVP - Technologies Virtual-PC
> E-mail: sylvain aei ca (fill the blanks, no spam please)
>
>
> "Alain" wrote in message
> news:%23ugBoNseIHA.1208@TK2MSFTNGP05.phx.gbl...
>> 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@TK2MSFTNGP03.phx.gbl...
>>> 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" wrote in message
>>> news:uretHAheIHA.4704@TK2MSFTNGP03.phx.gbl...
>>>> 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.
>>>>
>>>>
>>>
>>>
>>
>>
>
>
date: Mon, 3 Mar 2008 10:33:15 +0100
author: Alain
Re: VisualStudio Express restriction
Even if you don't see any database server, maybe that you can still select
one by entering it's name directly. If you have removing some services such
as the SQL-Server discovery service or have a firewall that will block
everything then you won't see some or all of the available servers.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"Alain" wrote in message
news:%23BS1gGRfIHA.2000@TK2MSFTNGP03.phx.gbl...
>I noticed the "Change..." button but this doesn't help me.
> I cannot select a database server.
> I think it is a Express version restriction.
>
> Does somebody can confirm this on this forum ?
>
> Thanks in advance,
> Alain.
>
>
>
>
>
> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)> a
> écrit dans le message de news: eSTN%23PweIHA.2000@TK2MSFTNGP05.phx.gbl...
>> Hi, I just take a look again in more detail and I have noticed that in
>> the Add Connection dialog window, there is a choice for the "Data source"
>> with a button "Change..." at its right. This option might be hard to
>> find because its background is not white and is located just above the
>> Database file name or Server name.
>>
>> If this Data source is set to "Microsoft SQL Server Database File
>> (SqlClient)" or to "Microsoft Access Database File (OLE DB)", then you
>> cannot select a server, only a file name. Change the Data source to
>> "Microsoft SQL Server" (without the "Database File (SqlClient)
>> denomination" at its end) and you should be OK.
>>
>> Because you have the Express version of Visual Studio, it's also possible
>> that you don't have access to this option. I don't know because I don't
>> have the Express version installed on my own machine.
>>
>> --
>> Sylvain Lafontaine, ing.
>> MVP - Technologies Virtual-PC
>> E-mail: sylvain aei ca (fill the blanks, no spam please)
>>
>>
>> "Alain" wrote in message
>> news:%23ugBoNseIHA.1208@TK2MSFTNGP05.phx.gbl...
>>> 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@TK2MSFTNGP03.phx.gbl...
>>>> 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" wrote in message
>>>> news:uretHAheIHA.4704@TK2MSFTNGP03.phx.gbl...
>>>>> 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.
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
date: Mon, 3 Mar 2008 09:43:58 -0500
author: Sylvain Lafontaine sylvain aei ca (fill the blanks, no spam please)
Forcing the server name
Thanks for your advice but it doesn't work.
The "Data source" field can be selected in a list but cannot be edited, so I
cannot put my SQL Server name.
In this list, I have "Access Database file", "SQL Server Compact" and "SQL
Server Database file".
I'm not a specialist, so I have removed no service.
This is a Visual Basic 2008 Express Edition with no modification!
In Visual Wev Developer 2008 Express Edition, I have no problem.
I can see my SQL Server and I can create a DB connection!
Alain.
"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)> a
écrit dans le message de news: unDiG0TfIHA.6092@TK2MSFTNGP06.phx.gbl...
> Even if you don't see any database server, maybe that you can still select
> one by entering it's name directly. If you have removing some services
> such as the SQL-Server discovery service or have a firewall that will
> block everything then you won't see some or all of the available servers.
>
> --
> Sylvain Lafontaine, ing.
> MVP - Technologies Virtual-PC
> E-mail: sylvain aei ca (fill the blanks, no spam please)
>
>
> "Alain" wrote in message
> news:%23BS1gGRfIHA.2000@TK2MSFTNGP03.phx.gbl...
>>I noticed the "Change..." button but this doesn't help me.
>> I cannot select a database server.
>> I think it is a Express version restriction.
>>
>> Does somebody can confirm this on this forum ?
>>
>> Thanks in advance,
>> Alain.
>>
>>
>>
>>
>>
>> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)> a
>> écrit dans le message de news: eSTN%23PweIHA.2000@TK2MSFTNGP05.phx.gbl...
>>> Hi, I just take a look again in more detail and I have noticed that in
>>> the Add Connection dialog window, there is a choice for the "Data
>>> source" with a button "Change..." at its right. This option might be
>>> hard to find because its background is not white and is located just
>>> above the Database file name or Server name.
>>>
>>> If this Data source is set to "Microsoft SQL Server Database File
>>> (SqlClient)" or to "Microsoft Access Database File (OLE DB)", then you
>>> cannot select a server, only a file name. Change the Data source to
>>> "Microsoft SQL Server" (without the "Database File (SqlClient)
>>> denomination" at its end) and you should be OK.
>>>
>>> Because you have the Express version of Visual Studio, it's also
>>> possible that you don't have access to this option. I don't know
>>> because I don't have the Express version installed on my own machine.
>>>
>>> --
>>> Sylvain Lafontaine, ing.
>>> MVP - Technologies Virtual-PC
>>> E-mail: sylvain aei ca (fill the blanks, no spam please)
>>>
>>>
>>> "Alain" wrote in message
>>> news:%23ugBoNseIHA.1208@TK2MSFTNGP05.phx.gbl...
>>>> 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@TK2MSFTNGP03.phx.gbl...
>>>>> 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" wrote in message
>>>>> news:uretHAheIHA.4704@TK2MSFTNGP03.phx.gbl...
>>>>>> 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.
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
date: Tue, 4 Mar 2008 11:09:32 +0100
author: Alain
Solution
Hi.
I have a answer.
My problem is normal.
VStudio Express is a restricted version; it cannot access to a remote
database.
Alain.
"Alain" a écrit dans le message de news:
eu0Oa$dfIHA.968@TK2MSFTNGP03.phx.gbl...
> Thanks for your advice but it doesn't work.
>
> The "Data source" field can be selected in a list but cannot be edited, so
> I cannot put my SQL Server name.
> In this list, I have "Access Database file", "SQL Server Compact" and "SQL
> Server Database file".
> I'm not a specialist, so I have removed no service.
> This is a Visual Basic 2008 Express Edition with no modification!
>
> In Visual Wev Developer 2008 Express Edition, I have no problem.
> I can see my SQL Server and I can create a DB connection!
>
> Alain.
>
>
>
>
> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)> a
> écrit dans le message de news: unDiG0TfIHA.6092@TK2MSFTNGP06.phx.gbl...
>> Even if you don't see any database server, maybe that you can still
>> select one by entering it's name directly. If you have removing some
>> services such as the SQL-Server discovery service or have a firewall that
>> will block everything then you won't see some or all of the available
>> servers.
>>
>> --
>> Sylvain Lafontaine, ing.
>> MVP - Technologies Virtual-PC
>> E-mail: sylvain aei ca (fill the blanks, no spam please)
>>
>>
>> "Alain" wrote in message
>> news:%23BS1gGRfIHA.2000@TK2MSFTNGP03.phx.gbl...
>>>I noticed the "Change..." button but this doesn't help me.
>>> I cannot select a database server.
>>> I think it is a Express version restriction.
>>>
>>> Does somebody can confirm this on this forum ?
>>>
>>> Thanks in advance,
>>> Alain.
>>>
>>>
>>>
>>>
>>>
>>> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
>>> a écrit dans le message de news:
>>> eSTN%23PweIHA.2000@TK2MSFTNGP05.phx.gbl...
>>>> Hi, I just take a look again in more detail and I have noticed that in
>>>> the Add Connection dialog window, there is a choice for the "Data
>>>> source" with a button "Change..." at its right. This option might be
>>>> hard to find because its background is not white and is located just
>>>> above the Database file name or Server name.
>>>>
>>>> If this Data source is set to "Microsoft SQL Server Database File
>>>> (SqlClient)" or to "Microsoft Access Database File (OLE DB)", then you
>>>> cannot select a server, only a file name. Change the Data source to
>>>> "Microsoft SQL Server" (without the "Database File (SqlClient)
>>>> denomination" at its end) and you should be OK.
>>>>
>>>> Because you have the Express version of Visual Studio, it's also
>>>> possible that you don't have access to this option. I don't know
>>>> because I don't have the Express version installed on my own machine.
>>>>
>>>> --
>>>> Sylvain Lafontaine, ing.
>>>> MVP - Technologies Virtual-PC
>>>> E-mail: sylvain aei ca (fill the blanks, no spam please)
>>>>
>>>>
>>>> "Alain" wrote in message
>>>> news:%23ugBoNseIHA.1208@TK2MSFTNGP05.phx.gbl...
>>>>> 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@TK2MSFTNGP03.phx.gbl...
>>>>>> 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" wrote in message
>>>>>> news:uretHAheIHA.4704@TK2MSFTNGP03.phx.gbl...
>>>>>>> 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.
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
date: Fri, 7 Mar 2008 08:30:12 +0100
author: Alain
Re: Solution
I knew it was a restricted version but I didn't knew it was restricted so
much.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"Alain" wrote in message
news:%23HHJUUCgIHA.3940@TK2MSFTNGP05.phx.gbl...
> Hi.
>
> I have a answer.
> My problem is normal.
> VStudio Express is a restricted version; it cannot access to a remote
> database.
>
> Alain.
>
>
>
>
>
> "Alain" a écrit dans le message de news:
> eu0Oa$dfIHA.968@TK2MSFTNGP03.phx.gbl...
>> Thanks for your advice but it doesn't work.
>>
>> The "Data source" field can be selected in a list but cannot be edited,
>> so I cannot put my SQL Server name.
>> In this list, I have "Access Database file", "SQL Server Compact" and
>> "SQL Server Database file".
>> I'm not a specialist, so I have removed no service.
>> This is a Visual Basic 2008 Express Edition with no modification!
>>
>> In Visual Wev Developer 2008 Express Edition, I have no problem.
>> I can see my SQL Server and I can create a DB connection!
>>
>> Alain.
>>
>>
>>
>>
>> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)> a
>> écrit dans le message de news: unDiG0TfIHA.6092@TK2MSFTNGP06.phx.gbl...
>>> Even if you don't see any database server, maybe that you can still
>>> select one by entering it's name directly. If you have removing some
>>> services such as the SQL-Server discovery service or have a firewall
>>> that will block everything then you won't see some or all of the
>>> available servers.
>>>
>>> --
>>> Sylvain Lafontaine, ing.
>>> MVP - Technologies Virtual-PC
>>> E-mail: sylvain aei ca (fill the blanks, no spam please)
>>>
>>>
>>> "Alain" wrote in message
>>> news:%23BS1gGRfIHA.2000@TK2MSFTNGP03.phx.gbl...
>>>>I noticed the "Change..." button but this doesn't help me.
>>>> I cannot select a database server.
>>>> I think it is a Express version restriction.
>>>>
>>>> Does somebody can confirm this on this forum ?
>>>>
>>>> Thanks in advance,
>>>> Alain.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
>>>> a écrit dans le message de news:
>>>> eSTN%23PweIHA.2000@TK2MSFTNGP05.phx.gbl...
>>>>> Hi, I just take a look again in more detail and I have noticed that in
>>>>> the Add Connection dialog window, there is a choice for the "Data
>>>>> source" with a button "Change..." at its right. This option might be
>>>>> hard to find because its background is not white and is located just
>>>>> above the Database file name or Server name.
>>>>>
>>>>> If this Data source is set to "Microsoft SQL Server Database File
>>>>> (SqlClient)" or to "Microsoft Access Database File (OLE DB)", then you
>>>>> cannot select a server, only a file name. Change the Data source to
>>>>> "Microsoft SQL Server" (without the "Database File (SqlClient)
>>>>> denomination" at its end) and you should be OK.
>>>>>
>>>>> Because you have the Express version of Visual Studio, it's also
>>>>> possible that you don't have access to this option. I don't know
>>>>> because I don't have the Express version installed on my own machine.
>>>>>
>>>>> --
>>>>> Sylvain Lafontaine, ing.
>>>>> MVP - Technologies Virtual-PC
>>>>> E-mail: sylvain aei ca (fill the blanks, no spam please)
>>>>>
>>>>>
>>>>> "Alain" wrote in message
>>>>> news:%23ugBoNseIHA.1208@TK2MSFTNGP05.phx.gbl...
>>>>>> 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@TK2MSFTNGP03.phx.gbl...
>>>>>>> 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" wrote in message
>>>>>>> news:uretHAheIHA.4704@TK2MSFTNGP03.phx.gbl...
>>>>>>>> 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.
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
date: Fri, 7 Mar 2008 12:26:16 -0500
author: Sylvain Lafontaine sylvain aei ca (fill the blanks, no spam please)
|
|
