Friday, February 10, 2012

Connection Problem

I am developing a web app using VB.NET and SQL server 2000. My database server is on a different machine. I have no problems connecting to the server from my local machine but when i deploy the application on to the server where my database is running, I get all sorts of wierd messages. This is happening when I try to connect to the database.
My development machine is XP pro and my server is running win 2k server.

My connection string looks like
server=ip address\database server name; database=name;user id="test";pwd="test";

The exception occurs when I try to open the connection.

Please help.
Thanks in advance.I am getting the following error and I do not understand.

Expected '=' delimiter while parsing connection value pair.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentException: Expected '=' delimiter while parsing connection value pair.|||Check out the SQL Server connection strings athttp://www.connectionstrings.com/ and see if that helps.

Terri|||Thanks Terri. It helped. I was not using the Trusted_Connection=False statement.

No comments:

Post a Comment