472,119 Members | 962 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,119 software developers and data experts.

why did i keep getting a connection error?


i've been developing a webservice on machine A and one WebMethod of this
webservice will connect to SQL Server2000 on machine B using a connect string
defined in Web.config as below:

<add key="sqlDbConn.ConnectionString" value="workstation
id="";packet size=4096;integrated security=SSPI;data
source=;persist security info=False;initial
catalog=RVLabeling_Joe" />

i'm sure the IP address as above is exactly the machine B's IP and database
name is correct! Also SQL server instance is running! but when i test the
WebMethod on IE through HTTP, i keep getting a error like this:

System.Data.SqlClient.SqlException: SQL Server does not exist or access
at System.Data.SqlClient.ConnectionPool.CreateConnect ion()
at System.Data.SqlClient.ConnectionPool.UserCreateReq uest()
at System.Data.SqlClient.ConnectionPool.GetConnection (Boolean&
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnectionString options, Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection,
ConnectionState& originalState)
at System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable, IDbCommand
command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at RVLabelingToolWebService.RVManagement.GetUserId(St ring userName) in
c:\inetpub\wwwroot\rvlabelingtoolwebservice\rvmana gement.asmx.cs:line 400

i'm confused and could anyone help me?

thanks in advance!

Aug 22 '06 #1
0 1077

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by anonymous_c | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.