christrinder
10-24-2006, 11:41 AM
Hi all,
I've recently upgraded my laptop and moved my ASP.NET C# application over to a new machine. However, since doing it, my site can't call any stored procedures. The procs have been created, I have given the website user permission to run the execute function but I get the error: "The underlying connection was closed: The remote name could not be resolved". It might be worth pointing out that if I change my connection string to user the "root" user, then they do work, but I don't really want my site to have full access to the database with all the permissions.
Does anybody have any ideas what I need to change?
Thanks,
Chris
I've recently upgraded my laptop and moved my ASP.NET C# application over to a new machine. However, since doing it, my site can't call any stored procedures. The procs have been created, I have given the website user permission to run the execute function but I get the error: "The underlying connection was closed: The remote name could not be resolved". It might be worth pointing out that if I change my connection string to user the "root" user, then they do work, but I don't really want my site to have full access to the database with all the permissions.
Does anybody have any ideas what I need to change?
Thanks,
Chris