Typed dataset giving problem...

[praveenkumar palla]

I done one vb.net application which includes typed dataset (using SQL Server) Dragged one required database table on to the xsd(typed dataset) and right click select query then sqlstatement and then insert method and modified the populated query as required . And in the code i am using the method(insert) created in the xsd(typed dataset) The application is working fine in my local machine but when i moved the application to client machine (which uses another database but table and columns names and keys all are similar) there i am getting an exception "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." I also changed the database name in configuaration file (connection string-autogenerated when drag a table) Please help on this and Thanks in advance.

[Rajesh Anuhya]

i think this is not a dataset problem., first check the database connection in your client pc

Rajesh B --> A Poor Workman Blames His Tools <--

[Dave Kreskowiak]

I think you asked this already. The problem is in the setup of the SQL Server. By default, it does not allow connections from remote PC's on TCP/IP. Go into the Configuration Manager and enable remote connections.

A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
     2006, 2007, 2008