I have MSDE on ASP1.1 on a PC and have a logon page that uses a stored procedure to check my auth_user table, if logon and password exist then it returns (1) else returns (0).
I used objparams.return to pick up the returned value and either server.transfer to opening page or label text message 'login not valid'. This is insde a try and the catch is another label, 'cannot connect to database'.
Running on my local PC all is fine, transferred SP and table to hosting server, along with web.comfig set to the host servername, uid, password and database. On the host server all errors messages are returned. I have created a connection in my VS7 database manager to the remote host and the same happens after amending my connection string to run on the remote server.
It clearly is the connection string, I am using the <appsettings> add Key to connect as I thought it would mean no change of coding in my pages when moving from Dev PC to Server. I have checked the hosting server setup and used the server name associated with the database (mssql3.securedc.com) , checked uid, password and database settings. Is there something I have missed like permissions, specific security settings on the host server (I have to go through a third party as the hosting is done through a friend of my client)??
Many thanks
Earle
EJW--
Regarding this...
EJW wrote:
...It clearly is the connection string...
...you might want to checkhttp://www.ConnectionStrings.com to make sure you are using the right format.
Furthermore, usually in shared hosting environments, one cannot use "Integrated Security"; so, make sure about that.
Can you post the connection string here?
|||The string is
<add key="strConn" value="server=mssql3.securedc.com;uid=fleetwo_admin;password=XXXXXXXX;database=fleetwo_erfp" />
Should I use uid=sa ? I don't have a password for it.
I am unsure if the problem is in the connection or the deployment. I can find very litttle information on deployment, but basically I have put all my aspx file into my root, the dll files into bin. Should there be files elsewhere (client_ dir?).
I am building the project using my web.config file as that has paths for my PC, and this is different to the web.config file used on the remote server. Can this be an issue?
As a general question, not to you personally:- I made an assumption, probably wrong, that the web.config file was outside the build so that you could deploy on different servers. The .NET product is really useful, but I am finding getting really basic information hard to find, any tutorials on deployment around?
Many thanks
Earle
No comments:
Post a Comment