Is it mandatory to install "SQL server client" to connect to server that has "

Hello,

My database is on the server. I have a vb.net application installed on a client's machine. The problem is I am not able to connect to server from my application.

I have figured out that "SQL server client" is not installed on client's machine.

So is there any settings/utility available using which without installing SQL client I can connect to Server.

Any views/help would be apprecciated.

You do not need to install anything on the client to connect to RS. What error are you recieving?|||

The server machine contains the database and the vb.net application is installed on the client's machine. So my question is in order to connect to the database that resiedes on the server, should client's machine also need "sql server client" or is there any way in which the application can connect to database without "sql client" on client machine.

This has nothing to do with reporting services.

Thanks

|||

I would suggest posting your question here http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=158&SiteID=1

This is a report server forum, so I assumed the question was about RS. Assuming you are using .Net, the answer would still be no, client tools are not required on the client for an application.

Is it a bug in SQL CE?

Hi!

I use SQL CE with VS.NET. I find the following bug 2th.

The table has an "ID int IDENTITY(0,1) PRIMARY KEY,". That is my row identity.

I add rows to the table, then I realized that the ID order not in the general order (from 0 to ........)

For example: 6,7,8,0,1,2,3,4,5.

Of course row 6,7 and 8 was added the very last.

The content of each row is not mixed, only the ID order.

Is it a very confused, because we develop mobile invoice programs for PDAs.

What I did wrong?

Thank you!

Does that happen in the Query Analyzer on the PDA?

Maybe it does not order the rows by the primary key column by default (?). I don't know if that would be a bug, although it sounds more convenient if it did order on any key columns.

|||I moved this thread to the SQL Mobile's team forusm|||

Neither SQL Server nor SQL Mobile guarrenty you about the physical order of the rows and you are not expected to concluded something from running multiple queries. It can always change. If you want the rows to be ordered on a column, you should ideally use ORDER BY. Your query result (with out ordering) always depends on the cursor position.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation