473,325 Members | 2,342 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

How to connect vb2005 express and SqlServer Express through a network

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

Nov 29 '05 #1
2 1492
> 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
Nov 29 '05 #2
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
Nov 29 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Jerry Spence1 | last post by:
1. Is there a more suitable, dedicated newsfeed for VB2005 yet? 2. I'm confused as to which version to get. I work for a small company and we will just need VB2005 on my PC. Therefore that tends...
2
by: saroxonline76 | last post by:
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...
0
by: Larry Rebich | last post by:
I am trying to use the sample web template that is distributed with Visual Studio 2005 called 'Personal Web Site Starter Kit'. After running for awhile it fails with the following message: ...
7
by: Rich | last post by:
Hello, I have an SP that inserts data into a sqlserver table. If a condition is not met within the SP after the data has been inserted into the table, the SP will rollback the insert. If I...
13
by: josh | last post by:
I'm pretty new to both sql 2005 and VB but please bear with me. I have installed SQL 2005 express on a Windows 2003 Standard server. I have also installed VB 2005 Express edition on the server. SQL...
8
by: vbDavidC | last post by:
I am wondering if I should use MS Access or SQL server as my database. I have a little experience programming an Access DB with VB6 (DAO/ADO). I am now starting over with VB2005 and will be doing...
15
by: Aalaan | last post by:
I am presently a user of classic vb6 and hang out on those newsgroups. Some of you may be aware that there is a very anti MS and vb2005 feeling there. I have tried to get them to tell me which...
9
by: Peter Lux | last post by:
I'm fairly new to c#, but not new to programming. I'm tasked with rewriting our Gupta/Sqlwindows apps (5 years worth of development) in dot Net. The main reason is that virtually no one knows the...
7
by: Academia | last post by:
I was told that SqlServer express should get installed when VS2008Pro is installed (that is it is on the same DVD). I had a couple of errors during vs2008's installation and I don't see any...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.