Help with connecting to the object explorer ON Microsoft SQL Server Management Studio Expr

Hi All,

I have just installed Microsoft SQL Server Management Studio Express.. Once I did this first it was working fine, but now their is this error each time I try to connect the object explorer.. the error is as follows :-

Could not load file or assembly 'System.Data, Version=2.0.0.0, Culture=neutral publickeyToken=b77a5c561934e089' or one of its dependencies. Signature specified is zero-sized. (Exception from HRESULT: 0x80131237).

Could anybody help me with getting rid of this error. I have no clue what to do?Try closing everything, uninstall SMSS, reboot, reinstall. Make sure only necessary programs and network connections are on when you try to open SMSS again.sql

Help with connecting to SQL database and binding

I am new to .net and I am using Visual Web Developer 2005 Express with SQL Server 2005 Express. What I would like to do is connect to my SQL database (which resides in the app_data folder) and open a table and pull out a field and place it in either a textbox or label on the page. No editing or deleting. Just simple one field binding. By the way, I can do this with all the cool built-in tools of VWD, but I want to know how to do it all by hand. I would really appreciate it if someone could help me out.

nate200@.hotmail.com:

I am new to .net and I am using Visual Web Developer 2005 Express with SQL Server 2005 Express. What I would like to do is connect to my SQL database (which resides in the app_data folder) and open a table and pull out a field and place it in either a textbox or label on the page. No editing or deleting. Just simple one field binding. By the way, I can do this with all the cool built-in tools of VWD, but I want to know how to do it all by hand. I would really appreciate it if someone could help me out.

This should give you an idea, it's a very manual example, no flashy tools:

http://aspnet.4guysfromrolla.com/articles/110905-1.aspx

Roger|||

Hey thanks that helped a lot! I got the code in place but when I view the page I don't get anything in my label. Here's my code.

<

formid="form1"runat="server"><asp:SqlDataSourceID="SqlDataSource1"runat="server"ConnectionString="<%$ ConnectionStrings:PollConn %>"SelectCommand="SELECT TOP 1 MemberNum FROM Members"></asp:SqlDataSource><asp:LabelID="Label1"runat="server"Text='<%# Bind("MemberNum") %>'></asp:Label></form>

What am I missing??

|||

nate200@.hotmail.com:

Hey thanks that helped a lot! I got the code in place but when I view the page I don't get anything in my label. Here's my code.

<formid="form1"runat="server">

<asp:SqlDataSourceID="SqlDataSource1"runat="server"ConnectionString="<%$ ConnectionStrings:PollConn %>"

SelectCommand="SELECT TOP 1 MemberNum FROM Members"></asp:SqlDataSource>

<asp:LabelID="Label1"runat="server"Text='<%# Bind("MemberNum") %>'></asp:Label>

</form>

What am I missing??

When using a data source you need to wrap a formview tag around the label, and bind the formview to the datasource.

Here's some samples of the formview tag:

http://www.asp.net/QuickStart/aspnet/doc/ctrlref/data/formview.aspx

Roger

help with accessing reportserver with web browser

I am using sql express w/ advanced services on xp pro with IIS 5.1 installed. On the local machine named 'Tester' i am able to access reportserver using a web browser and the url: http://localhost/reportserver. But when i go to another machine on the same network and domain and try to access the reportserver with url: http://Tester.domain/reportserver or http://<ip address of Tester>/reportserver ie tells me page cannot be found and does not give me any errors. How do I set up network access to reportserver on the machine Tester? Help would be greaty appreciated.

Try and turn off Windows Firewall to see if that helps.

To troubleshoot, you should be able to telnet to port 80 from the other machine.

cheers,

Andrew

Help with a connection string

I have a two computers, in one of them I install the SQL Server 2005 express with server name USER\SQLEXPRESS and ip 192.168.3.15.The data base name is Prueba.mdf

In the other computer I have VB 2005 express , and I want to connect with Prueba.mdf in the the other pc. Can you help me?

Hi

Try the below connection string settings

User ID=sa; ( if you configured your own, then replace user name and password acc)

password=sa;

Data Source=USER\SQLEXPRESS;

database=Prueba;

Connect Timeout=1800;

Regards,

Dhinesh Kumar

|||If you want to connect to a user instance, you should use one of the strings at www.connectionstrings.com , look for SQL Server 2005 and user instances, there are some strings which will help you.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

HELP using SQL Server 2005

I am using SQLServer2005 Express Edition in Visual Studio 2005. I uploaded the database to the server with the rest of the web files. When I try to insert data into a table, I receive the "error: 26 - Error Locating Server/Instance Specified" error message.

It is my belief that it is the connection string that is causing the problem. Currently the connection string looks like this:

Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\MYDATABASE.mdf;Integrated Security=True;User Instance=True

Is there a way using VS2005 to create a username and pass for the database? Then how do I set up a typical connection string that will work on a web server?

Desired connection string format would be something like:

Data Source=??serverIP??;UID=MYusername;PASSWORD=MYpassword;SERVER=?serverIP/NAME?

The question marks are in there because I am not 100% sure what would go in those properties. Any help is appreciated.

Thanks,
KJAK

Are you sure that the sqlserver is installed in the server ? When you use .mdf files is necessary that the server have the sql server installed.

A connection string that will work on a web server is something like this:

connectionString="Data Source=SERVERIP;Initial Catalog=DATABASENAE;Persist Security Info=True;User ID=USER;Password=PASSWORD"providerName="System.Data.SqlClient"

|||

SQLServer is installed on the server. The current connection string is provided from my development machine in the web.config file. I will try to adjust it to be similar to what you have posted.

I don't have full access to the server so I can't make any direct adjustments to SQLServer if that is needed. How can I create a username and password for the database using Visual Studio 2005?

|||

SQLServer is installed on the server

which version of sql server is installed? express? or sql 2005?

But whatever,based on my understanding, in neither case you can create sql user name and passwork through visual studio. The sql database is managed by database management tool thus you can only create/modify user name and psw through management studio.

I don't have full access to the server so I can't make any direct adjustments to SQLServer if that is needed.

and based on my understanding, i think you must have admin previlage if you want to create new sql user accounts.

Hope my suggestion helps

HELP US MICROSOFT: SYNCH BETWEEN SQL EXPRESS AND SQL MOBILE

Hi Everyone

As most of you do, I am eagerly awaiting the ability to synchronize my sql mobile database on the hand held to a local sql express database on my local machine

I know users in Microsoft have pointed out to us that we are getting things for free.

At the same time, Microsoft is getting our patience for free and at a cost to us developers.

Its nearly April and as one article says Microsoft will release a fix for this inadequacy

Microsoft...we are happy to pay for this. Palm offers it so what is the big deal. Its not the

reinvention of the wheel. We would have liked that instead of the server synchronization

that bypasses the local sql express database

I as many others are happy to pay

Please let us know when you will be addressing this problem.

I would appreciate the feedback and frustration of other developers. Maybe this will show them we are really running out of time with our clients

Regards

Touraj

Can you point to do the article that says Microsoft will release a fix for this as I am curious?|||

Still, even if someone from Microsoft hasnt said this rather than a prominent person in the MVP area, it doesnt defeat the purpose of the Topic.

We need this as our clients are screaming for this functionality.

Please just answer this simple question. WHEN?

Touraj

|||I agree that this needs to be addressed and a schedule would be helpful. I don't see why the merge/snapshot publication capability exists in MSDE 2000 but not in SQL 2005. The "free" argument breaks down when you realize that the earlier version of the database runtime could do this.|||

Hi Skip

thanks for replying

for a second i thought i was the only person interested in this feature and thought maybe i had missed something...that was until my client who is a multinational screamed at me again on the phone

Anyone....can anyone from Microsoft please tell us SOMETHING

and not ignore us. We are the customers. Please tell us anything so that we know you guys actually do read our opinions

Darren Shaffer...i really respect you....can you say anything...

Touraj

|||

Appreciate your feedback. The requirement for syncing SQL Mobile with SQL Express has been raised earlier. The issue is not that both the products are free but given the time and resources that the SQL Mobile team has can all the requirements be handled effectively. There are quite a few requirements on the plate of the team and the requirements need to be prioritized so that the maximum value is generated given the constraints. The following helps in moving things up in the priority of the Product Team:

1) The criticality of the requirement - How big is the deployment? What will happen if the feature is not made available? What is the future growth rate of the application

2) No of Applications that are affected by not having the feature - How many of the SQL Mobile Application Developer community is affected by not having this feature

3) Customer scenarios - What are the customer business scenarios that are not being solved by not having this feature

Regards

Ambrish

|||This isn't the whole picture by the way.
MSDE indeed supports merge replication, it can be configured as distributor and can make publications. I've spent quite some time making scripts to configure newly installed MSDE instance for my needs and I was quite happy with the results - MSDE made me a snapshot on given schedule.
Then it came to synchronizing with ppc... First issue is that you can't install sqlce server tools with no SQL Server installed - it just doesn't seem to be able to locate the presence of MSDE. For testing purposes I've installed SQL Server and sqlce server tools, configured IIS with it (though you can make a virtual folder with sqlce server agent and set all access rights manually). I was able to browse the site with sqlce server agent from ppc and run the agent, but when it came to synchronizing, same error appeared over and over "29045: Initializing SQL Server Reconciler has failed" on MSDE. Switching to SQL Server solves the problem - merge replication works fine, but I need same functionality with MSDE. Official documentation states that it can be done, but it doesn't points to HOW it can be done.
|||

I appreciate your feedback

I also appreciate your priortities may be different than the simple user out there.

But as a company director of a growing mobile application business I can safely say that our business is being impacted by this gap in functionality

1) The functionality of Local Sync between a hand held and SQL Express is CRITICAL

This is irrespective of the size of the project/deployment. Customers and their internal IT department are staggered and laughing at us and Microsoft when they find out its not available.

Remember this is something that is made freely available in palm desktop and should be offered.

The growth rate of our applications will soon cease to exist under the SQL mobile platform if this isnt resolved. Customers do not want devices synching with their servers via IIS.

Eg When you are dealing with Mining companies do you think there is a server out in the mine or the office. NO

There is a rugged laptop running a .NET application for which the user needs to synch information to and from his hand held. This lack of functionality has now cost us one major tender and a whole industry. So what do we do.

I wouldnt even touch Appforge. They at least offer local synch for Palm DB and Access but their scalability is poor

So where does that leave us. Very frustrated because the business is being hurt by our loyalty. So we as well as many other vendors who we have met at exhibitions are deciding to leave if this isnt addressed quick

2) Again 100% of the application developer community. I can safely say this as I have a hand on the pulse of this matter. I think without going into technical aspects, simply from a user/customer point of view this is the sole reason that we dump your technology and decide to use another one.

This is mission critical. One reason I am passionate is that you have 99% of what we need

This 1% is what is causing the 99% to be useless. I cant say it more clearer than that

3) Once again..,.I can give you 100 scenarios.

You are asking us to accept

"a user having to synch a hand held with a server. the process would leave the SQL Express out of synch as it does not partake in that process unless you trigger another synch between SQL Express and SQL Server"

Besides it being a completely poor design we cant accomplish this in scenarios like mobile sales forces, mining, telecommunications and so on when the Server isnt there to act as the middle man. I just cant understand why i even have to explain this to you guys seeing it is so obvious.

This is where you will beat IBM who is currently buying up and looking at industry specific solutions.

With Microsoft our business will soon fail to operate using your technology. Forget about being industry specific and creating solutions. They convenience of mobility is made useless if you are restricted in such a way

You can call me and I can discuss it with more factual details which I will not post here

Suffice to say that losing our company will not be a once off loss in loyatly. We are an example of the widespread dismay and frustration with SQL Mobile

Touraj

|||I'm with Touraj on this matter. For SQL Mobile direct merging with a lightweight desktop DB such as SQL Express (or MSDE) is needed very much to develop an easy-to-deploy lightweight applications|||

Thanks Zheka

I am surprised no one else is adding their thoughts to this topic

Can someone from Microsoft tell us...do we need to organise a petition

or what are the formal process to get this escalated

|||

Touraj,

By way of encouragement, I can assure you that Microsoft has heard your feedback - there have been several internal discussions I have participated in on the topic of providing merge replication with a lightweight database on the server/PC. We're talked about SQL Mobile server tools for MSDE, peer to peer SQL Mobile to SQL Mobile replication, and some other options as well.

To give you some perspective on this issue, what SQL Express is lacking is more than just a set of server tools for SQL Mobile replication. There are some major, integral components missing from SQL Express which would be needed to support merge replication, including a SQL Agent, a Distribution Database and capability, Replication Monitor, and the ability to define publications and serve as a publisher to name a few. So given that, in my opinion, Microsoft is not likely to come out with a way to bolt all of that on to SQL Express as it exists today - it would effectively be the same as bringing SQL Express up to SQL Server 2005 Standard Edition.

So the real problem is there is no MSDE-equivalent that supports merge replication available with the 2005 set of dev tools. In my opinion (and this is only my opinion), Microsoft lost money on MSDE because an awful lot of people used it in pseudo production environments with 5 or fewer concurrent connections. So retiring it does encourage adoption of SQL Server 2005 standard or better edition, which is an improvement in revenue for the company.

I guess what I am saying is that I don't believe relief is coming in the next few days or weeks based on how large the effort would be to solve this problem (not just technically, but from a marketing, documentation, and distribution standpoint). So you are going to need to consider an alternate option while this issue is being addressed. Here are some options that other people are evaluating or have working now:

1. use web services and roll your own data sychronization between SQL Mobile and SQL Express (this would be my choice in your situation unless you have multiple mobile users changing the same data between synchronization events)

2. use SQL Server 2005 Standard Edition on the server if budget permits

3. use a third party synch tool - I just saw a note from someone at IntelliSync claiming that their Data Synch product has the ability to synchronize SQL Mobile to SQL Express. I have not personally tested that nor do I know what it costs, I'm just passing along that they have made the claim.

4. if your application has a "batch-mindset", meaning you populate a SQL Mobile Database, put it on device, work with it all day, and then copy it back to a server and extract the data, you can use a programmatic approach to synchronizing the data. Tools from www.primeworks.pt are excellent for this.

I will continue to emphasize to Microsoft in my internal discussions with them how important the issue is and if a solution becomes finalized, I'll communicate that here and in the public newsgroup.

-Darren

|||

Dear Darren

My sincere thanks for your detailed response. I think you should be running the development division at Microsoft because it is real shame and eye opener when an external consultant is answering these type of questions and we are being treated like fools by Microsoft employees who run you through the same time wasting exercise and questions

I thankyou for your answers and advice. But the question remains why arent we as customers getting these answers from a Microsoft person. Absolutely ridiculous

Regards

Touraj

|||

to be honest I think you are pretty much telling to good guys at Microsoft to do all the work for you - this is really not the way to go, nor will it ever happen. Microsoft has done HELL OF ALOT for developers and customers and yet they still get negitivity - outragous in my honest opinion.

putting the differences aside....

you should really handle this in "your" own way - in other words, your own mechinism. This is EASILY achieved. Use WebServices, this is what I had done on several projects of my own.

It doesnt take much time and you will be benefiting from improving your skills, using the technology more and can customize it the way you wish to - that's what it's all about.

my 10 cents ;-)

HELP sql server 2005 express connection hangs up

Hi

I got an access 2002 application front end with a sql server 2005 express back end. Some of my clients are having some difficulties. After using the application for a while, some of the users are finding that the system just hangs up. It usually happens after the front end application has been running for about an hour (sometimes sooner and sometimes later). There are perhaps 1 to 5 concurrent users and I have checked to see if there are any firewalls stalling it (I think I check all of them)- Is there any way that SQL Server 2005 express could be caused to just stall- This even occurs with the odd laptop. All the appropriate protocols are enabled as well. These databses are not very large.

ANY HELP WOULD BE GREATLY APPRETIATED!!!

Thanks

Frank Srebot

Moved thread to the SQL Server Express forum.|||

hi Frank,

what do you mean by "just hangs up"? does it completely stalls requiring a reboot, or it's "sleeeping" for just a while and then restarts working "as expected" or the like?

to start, few things to consider..

SQLExpress sets the "autoclose" property of it's created databases to true, and this causes the dbs to be shut down when not in use, meaning that tyey will be closed if no active connection references them.. this involves a little overhead at next re-use as the dbs must be re-open, but I do not think this is your problem... anyway, the eventual related "problem" can be workaround modifying the relative database property via sp_dboption database's system stored procedure call...

"autoshrink" database property is even set to true, and this causes, at engine scheduled time frames, the eventual shrinking of the involved databases, so that when lots of insert/delete operations are performed (actually lots of deletes), the engine wakes up a thread to shrink (when necessary) the databases, requiring some time to execute..

if the autogrowth property of the database's datafiles and logfiles is set to true and the engine states new file space is required, the engine enlarges the files (when needed) and this will obviously involve some time as well...

other non SQL Server related issues includes OS's scheduled tasks requiring lots of CPU and/or I/O..

but it's hard to solve this way

regards

|||

Thanks for the great and quick response.

To clarify, sql server just hangs up meaning that the application displays an hourglass and eventually the sql connection is lost and an error message is given. I was doing some research and I was wondering if the problem could be in the connection pooling configuration- currently the setting are that pool connections are enabled by default in the ODBC config settings- the databases which I am dealing are quite small- would any one have any ideas perhaps along these lines?

Thanks

Frank srebot

|||

Hi

This is an update to my connection Problem with Access 2002 to SQL SERVER EXPRESS 2005.

We are having random disconnects on the client side with Access putting up a "Connection Failure" dialog box even when the user is actively entering records into the system. Have any of you ever encountered this situation? We have disabled all TCP offloading engine technology on the machine thinking this was causing a problem with SQL Server as well as changing network cards to a whole different brand. We've pretty much ruled out the physical network at this point because we have changed cables and moved to another port on a different switch to no avail.

Is there some timeout setting or connection pooling setting that I am unaware of at the SQL Server level that has a problem interacting with Windows Server 2003 or Windows XP? I have checked and double checked all of the server settings between the old machine and the new and they are identical.

I did read that the connection pooling may be stressed and the pool of connections are 'Leaking'. This might be due to a bad cable or connection, but thats all I have found out.

Any info would be greatly appreciated.

Thanks

Frank

help sql 2005 express

I have a computer_1 with sql 2005 express with app working fine, from another computer I want to connect to sql 2005 express in computer_1 using tcp/ip or named pipes, in computer_1 is enabled tcp/ip and named pipes, but when I connect using microsoft sql server management studio express I get this error:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

another thing is when I put... osql -L in computer_1 .... (local)\sqlexpress not is listen

You need to enable SQL Browser and open the Firewall on your computer so that remote connections can talk to SQL Express.

Check out http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx for information on doing this.

Mike