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/microsoft.public.dotnet.framework.adonet/browse_frm/thread/d892fa3f16af2168/c085545c69936dcf?lnk=st&q=dotnet+vs+2005+connect+sql+2000&rnum=8#c085545c69936dcf ? 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@msn.com www.cindywinegarden.com "chris" wrote in message news:EC706D34-00CA-41F7-A750-C23A64C7C4CB@microsoft.com... > 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 >
