I'm having an issue with VS.Net 2005. I just installed it and can't
connect any remote SQL instance from the IDE. My project is set up to
reference a remote SQL 2000 DB. I can connect to the SQL DB from Enterprise
Manager and VS.Net 2003. Anyone else have this problem? Just another
note - the code just hangs when I get to the "cn.open" line.

By the way sorry for the cross-post, but this one has me stumped.

chris hankey

Hello Chris,

Have u tried smth from that discussion http://groups.google.com/group/micro...85545c69936dcf
?

C> I'm having an issue with VS.Net 2005. I just installed it and can't
C> connect any remote SQL instance from the IDE. My project is set up
C> to reference a remote SQL 2000 DB. I can connect to the SQL DB from
C> Enterprise Manager and VS.Net 2003. Anyone else have this problem?
C> Just another note - the code just hangs when I get to the "cn.open"
C> line.
C>
C> By the way sorry for the cross-post, but this one has me stumped.
C>
C> chris hankey
C>
---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/members/laflour

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

Hi Chris,

Can you connect to the server via the Server Explorer pane in VS 2005? Can
you connect to the data by using Data Connection? If so, does it work with
"Microsoft SQL Server (SqlClient)" or "Microsoft SQL Server (OLE DB)" or
both?

How about posting the connection string you are using in your program, and
your program code?

I played with this same issue today and finally got it to work, but I just
kept stabbing in the dark and changing stuff, and I'm not sure which
approach worked.

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden (AT) msn (DOT) com www.cindywinegarden.com


"chris" <chris (AT) discussions (DOT) microsoft.com> wrote