Deploying Web Service to my hosting service's server

  • Thread starter Thread starter PocketDeveloper
  • Start date Start date
P

PocketDeveloper

When I deploy my web service to my website on my hosting service, it
errors out and cannot get to the database on that server.

To simplify things, I created the same ODBC name and Access database
on both my development machine, and on the shared server where my
website is hosted.

The Web Service works great on my development machine. But when I call
it once it's on my website, I get:

"An unhandled exception of type
'System.Web.Services.Protocols.SoapException' occurred in
System.Web.Services.dll
Additional information: System.Web.Services.Protocols.SoapException:
Server was unable to process request. --->
System.Data.SqlClient.SqlException: Login failed for user 'ggalen'.
at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean&
isInTransaction)
at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString
options, Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection
connection, ConnectionState& originalState)
at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at ESIDATA.ESIDATA.GetAccounts()
--- End of inner exception stack trace ---



I've adjusted my web.config. I am lost here, but I am sure many of you
here successfully do what I am trying to do.

So...To those of you who successfully develop on one machine, and then
deploy to a shared server...exactly HOW do you do it? What are the
"best practices", and things I must be careful to do?

Many thanks!
 
I see that you are using SqlClient class. It means that neither ODBC nor
Access DB have anything to do with your situation. Check your SQL connection
string for correct User ID/Password combination. Make sure that the
specified User ID (ggalen) has rights on the database you want it to access.
Incorrect DB rights are the most frequent reason for this error after the
project is deployed to the hosting provider
 
Back
Top