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

lI'm having a difficult time getting my current VB.NET 2003
lapplication to point to my upgraded SQL Server 2005 database. I
lperformed the upgrade from SQL Server 2000 to SQL Server 2005 on my
llocal computer and when I try to reconnect my VB.NET project to SQL
lServer 2005, I received a message that states unable to connect.
l>
lDoes anyone have an idea on how to do this? I'm fairly new to both
lprograms and inherited the project from someone else who wrote the
lprogram.
l>
lThank 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 Nietzsche

[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?...2-b1ed16424252

I hope this helps,

Cor

"leo813" <le****@comcast.netschreef in bericht
news:11**********************@b28g2000cwb.googlegr oups.com...

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.

[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/DavidsB...3/Default.aspx

Cor Ligthert [MVP] wrote:

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?...2-b1ed16424252

I hope this helps,

Cor

"leo813" <le****@comcast.netschreef in bericht
news:11**********************@b28g2000cwb.googlegr oups.com...

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.