Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
matusco
Starting Member
1 Post |
 Posted - 2008-04-16 : 05:14:44
|
| I have installed MSDE2000 (name: mypc\sql2000, port 1433) and sql2005 Express (mypc\sql2005, port 1434) on my WinXP.I'm developing some application and I need to test both server. It has worked fine about 1 year, but last month i got error message.When i'm trying to connect to SQL2005 from my application or import data from Excel, i get error message: [DBNETLIB][ConnectionOpen (Invalid Connection()).]Invalid connection.I can access SQL2005 with Management Studio or cmd line (sqlcmd). But not with Excel (or with my application).MSDE2000 works fine, i haven't any problems.Last weekend I have reinstalled my WinXP and also MSDE2000, SQL2005 Express.Worked fine, but when turn on automatic updates ON and afterwards installed latest updates, the problem is here again...Any idea to solve this problem?(sorry for my english...) |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-04-16 : 05:39:28
|
| Can you post the connection string.It sounds like it's incorrect but allowed before the update.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-04-16 : 06:16:24
|
| What application are you developing ? Also check this out www.connectionstrings.com |
|
|
|
|
|
|
sql2000 and sql2005 on the same machine