Printable View
Hello,
Here's some general information about my environment:
Visual Studio 2010
SQL Server 2008 R2
Windows 7 64bit
When I try to add a connection to my server explorer, I type in the server name and it fetches the tables correctly (so i choose the one I want). When I click on "Test connection" or "OK" I get the following error:
Attachment 96611
As mentioned above, I have SQL Server 2008 R2 ...
Thank you!
Alex
My guess is that you're programming for 64bit using a 32bit version of SQL Server or vice versa!
Interesting... Both my SQL Server and Visual Studio 2010 are 32bits but my computer is running a 64 bit version of Windows 7. That wouldn't bother anything right?
Not in itself, no. The crucial problem is what platform you're building for. From the Build Menu select Configuration Manager. If any of the configurations target AnyCPU or x64, you'll need to set them to x86.
Yeah I tried changing the Targetted CPU to x86 and I still received the same error. Bummer... I tried deleting my SQL 2005 version that I had previously as well, didn't change anything either.
Are you doing all this with the built-in datasource tools? I don't use them much, so I'm not even sure I have the name right, but that's what it sounds like you are doing. It also sounds like the connection string may be less than you would hope for. Can you see the connection string? If so, that would be the first place I would look.
Umm I'm not sure what the built-in datasource tool is but here's what I'm doing:
1. I go in my server explorer to add a new database connection
Attachment 96625
2. I choose SQL Server
Attachment 96623
3. I enter in the correct information. Also one with a username and password (the one required to access the database)
Attachment 96621 Attachment 96627
5. To get this result in both cases
Attachment 96619
My apologies. After triple checking with the system administrators they found out that the server (AMFSE) that I was trying to connect to, was infact SQL Server 2000. You can stamp this as resolved or FAIL on my part... Thank you everyone who tried to help!