Home > Archive > Visual Basic > November 2005 > How to connect vb2005 express and SqlServer Express through a network
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How to connect vb2005 express and SqlServer Express through a network
|
|
| saroxonline76@vodafone.it 2005-11-29, 3:55 am |
| Dear all,
I installed Visual Basic 2005 Express and SqlServer Express.
I tried some features of both of them but I'm not able to connect a
databse through a network.
To explain, I have two computer in the same work group. In one of them
I have installed SqlServer Express and the other one works as client, i
mean, i want to develop a software able to connect to the first one and
make operation with the database.
Using the "DataSource Configuration Wizard" I have to indicate the
"database file name" which is not visible through the network.
With the VB6 and MSDE2000, using a connection string, it was easy to
connect to a server through a network.
How can I solve this problem using VB2005 Express and SqlServer
Express?
Can I use similar connection string?
Any comment is useful
Thanks in advance
| |
| Mauro Gamberini 2005-11-29, 3:55 am |
| > Dear all,
> I installed Visual Basic 2005 Express and SqlServer Express.
>
[cut]
Sorry, but this is an italian ng.
.it = italia
and for VisualBasic 6.0, not VisualBasic.Net.
Please:
microsoft.public.dotnet.languages.vb
microsoft.public.dotnet.languages.vb.data
--
----------------------------
Mauro Gamberini
| |
| Cor Ligthert [MVP] 2005-11-29, 3:55 am |
| Saroxonline,
You can connect to a database and use with that ADONET. You can do it as
well with the wizard as you have that (altough I don't know what wizards are
included in the different versions and which not).
If it is the same wizard as I know, than you have to select the new
connection in the first dialog at the left. That will lead you to the
servers you can use and than as well to your SQL server express, after
selecting that and in that your tables, it will create for you than your
strongly typed dataset.
However at least should that database be connectable by you as user and
would you need the proper right to see the tables in that.
By the way, next time for this question, there is an ADONET newsgroup. The
name is
microsoft.public.dotnet.framework.Adonet
I hope this helps as a start.
Cor
|
|
|
|
|