Hi Friends,
I have the SQL server 2005 express installed on the server.
From the client machines, I am able to connect the sqlexpress instance running on the server and access the database (using the Sql server management studio express).
From client machine using VB 2005 express , is it possible to connect to the sqlserver 2005 express running on the server
In VB 2005 express designer, add datasource, there is no option to select database residing on the server
Thanks.
VB 2005 Express and SQL Server 2005 Express
BonnieFe
The express products (Using the Wizards) can only connect to the local database (Generally .\SQLEXPRESS). To connect to remote databases you will need to code the database layer manually.
Vai0l0
One of the limitations of the Express IDES is that they can only connect to the local database files... Now this is only the case with using the wizards, if you do wish to connect to a remote site you need to create the data layer another way. You can create the data layer and bind the controls manualy in code or you could create the data layer so that the objects are exposed, then using the object data sources you should be able to bind to those objects using the wizards.
Sirisha
I know for a fact that it can be very difficult to connect, because of this problem, and am a bit dissapointed with the lack of information regarding this issue.
it is affecting a large number of people, and i've not yet found a succesful troubleshooting guide for this.
if i'm wrong, then please correct me, as i only wish for information on this subject.
Florent Montsegur
Te only express product that can connect to remote databases is the Visual Web developer.
Visual Studio 2005 Product Line Overview
To allow Remote connections to connet to the SQL Server Express edition database system you will need to do some small tasks. This include making sure that the database files are attached to the SQL Server Engine and not using a User Instance. Then you will also have to make sure that the database engine is configured to allow remote connections. By default the SQl Server Express system has the network/ remote connections system turned off.
SQL Server 2005 Express Edition User Instances
Dhiraj Gupta27
Glenn, I hate to be a dork but ...
We KNOW that the SERVER has the transports disabled, and we have enabled them.
The problem is the the WORKSTATION IDE is not able to see sql server SERVERS in the 'choose datasource' dialog.
The IDE can only see file-based connections, not servers.
I did create an ODBC connection through the control panel using the Sql Server driver, no problem. But the IDE does not list it as an option when you try to build the connection.
Why is a *()&(&^%*& TCP-to-TCP connection such an issue in M$ software as late as 2006
Gimme a break already.
And Yes, this is an issue for MANY people trying in earnest to evaluate the product.
stsong
I am with the other poster on this issue. It is quite frustrating, especially, given the fact that I am in the target audience ("novice", "learner", etc.)
When I see stuff like "you need to create the data layer another way. You can create the data layer and bind the controls manualy in code or you could create the data layer so that the objects are exposed, then using the object data sources you should be able to bind to those objects using the wizards..." I am at a complete loss as to what they are saying. I looked through all the help stuff and, for the lofe of me, could find nothing that told me how to "create the data layer and bind the controls manualy in code" or "create the data layer so that the objects are exposed, then using the object data sources, ... bind to those objects using the wizards."
Am I in the worng forum The SQL Sedrver guys say the answers are over here, but I am damned if I can discern an "answer".