January 12, 2010 at 3:40 am
Hi All,
I'm setting up a new workstation with windows 7 x64. I have installed Visual Studio 2005 and did all the updates. I have SQL 2005 Express running at the machine. What happens:
I copied a project from my XP x86 machine in to it. The application uses 2 databases, one local ( in the 2005 express installation) and one remote at my ISP. When I run it, it won't connect to the remote database.
Management Studio accessed the remote DB just fine. Within visual studio, using the Data Sources view, I'm able to create a new data source and open the tables there.
Project was copied working (still works on the XP system). The only thing I have changed was the connection string to the local database, reflecting the new machine name.
Where should I look?
TIA,
Ricardo
January 12, 2010 at 4:37 am
Check the connection string to the remote server. Does the user which connects have the necessary privileges?
January 12, 2010 at 4:42 am
Like I said, it's the exact same project that runs just fine from the XP machine. Nothing is changed but the workstation. The connection string is exactly the same that works on the machine besides this one.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply