Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old March 26th, 2008, 03:42 PM
Registered User
 
Join Date: Mar 2008
Location: Winnipeg, Mb, Canada.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to gcharri Send a message via Yahoo to gcharri
Default SQL remote connection

Hi,

I wrote this application in visual basic .net and installed it on a server with SQL 2000 installed. I can locally start the application and I have confirmed that I can communicate with SQL.

Our environment is a little different as the server that I have installed the application does not have access to IE. It is on a network, but on a restricted network behind a fire wall.

I used the Click once deploy and I have processed the installation on a client pc. The client installation worked fine. When the client starts the application, it comes back to tell me that it cannot establish a SQL connection. I have created an ODBC connection on the server and I have used SQL Query to prove that I am able to communicate with the database.

Any suggestions on how I can get this remote connection to work.


Similar Threads
Thread Thread Starter Forum Replies Last Post
Remote Connection to SQL Server asharkashif Visual Studio 2005 1 November 24th, 2007 12:11 PM
SQL Server remote connection error sterreyl ASP.NET 2.0 Basics 1 April 6th, 2007 07:17 PM
remote connection sql reporting services sara_23apr BOOK: Professional SQL Server 2005 Reporting Services ISBN: 0-7645-8497-9 0 April 3rd, 2007 06:54 PM
Bugbase SQL 2005 remote connection error dtcalif BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 1 January 12th, 2007 06:46 PM
remote connection to MS SQL 2000 db Adam H-W Classic ASP Databases 0 July 19th, 2005 02:54 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.