Changing VB.NET 2003 connection from SQL Server 2000 to 2005 database.

[leo813]

I'm having a difficult time getting my current VB.NET 2003 application
to point to my upgraded SQL Server 2005 database. I performed the
upgrade from SQL Server 2000 to SQL Server 2005 on my local computer
and when I try to reconnect my VB.NET project to SQL Server 2005, I
received a message that states unable to connect.

Does anyone have an idea on how to do this? I'm fairly new to both
programs and inherited the project from someone else who wrote the
program.

Thank you for your help.

 

[Michael Nemtsev]

Hello leo813,

try to experiment with different type of connection drivers

l> I'm having a difficult time getting my current VB.NET 2003
l> application to point to my upgraded SQL Server 2005 database. I
l> performed the upgrade from SQL Server 2000 to SQL Server 2005 on my
l> local computer and when I try to reconnect my VB.NET project to SQL
l> Server 2005, I received a message that states unable to connect.
l>
l> Does anyone have an idea on how to do this? I'm fairly new to both
l> programs and inherited the project from someone else who wrote the
l> program.
l>
l> Thank you for your help.
l>
---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsch

 

[Cor Ligthert [MVP]]

Leo,

Why do you not try it in a little new project doing this.
That takes 2 minutes and gives you the connection string in the created
config.file.

http://www.vb-tips.com/dbpages.aspx?ID=1139f14a-c236-4ad7-8882-b1ed16424252

I hope this helps,

Cor

 

[dosborn278]

I believe that SQL 2005 has tcp/ip access disabled by default. If this
is the method you are using to connect then make sure it is enabled.
You can do this by going to SQL Server configuration manager and then
to protocols. Also make sure your new connection string is valid. An
easy way to do this is to use a .udl file. Check out this link for
instructions on how to do that:

http://www.ctrlalt313373.com/DavidsBlog/tabid/71/EntryID/3/Default.aspx