| Groups | Blog | Home |
vb.net data : VBNet 2005 and SQL Server
It seems to me the current VB.NET 2005 Express version does not support connect to SQL Server 2000 or SQL Server 2005. Or I am not doing correctly. I cannot even make the some samples project working Thanks
[quoted text, click to view]
On Mon, 17 Apr 2006 16:27:39 -0700, "M" <mxchen@hotvoice.com> wrote: ¤ ¤ It seems to me the current VB.NET 2005 Express version does not support ¤ connect to SQL Server 2000 or SQL Server 2005. Or I am not doing correctly. ¤ I cannot even make the some samples project working ¤ Could you be a bit more specific. How are you trying to connect? What sort of errors are you getting? Paul ~~~~
If I try add a connection in database Explorer On database Explorer I select "Add connection" The Choose DataSource screen appear. It alway assunme to connect to SQL server 2005 and let you select a MDF file. After locate a MDF file and click test connection I get the error message: An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the daufault setting SQL Server does not allow remote connections (provider: SQL Newwork interfaces, error:25 - connection string is not valid) Actually my SQL server 2005 database Engine set to using both TCP/IP and named pipes, allow remote connection. If I try to open a SQL Database samples project:Creating and using User Defined Types with SQL Server 2005 the message is The project file "..Microsoft Visual Studio 8\Samples\Data\Creating and using User Defined Types with SQL Server 2005\UDT\UDT.vbproject" cannot opened. The project type is not supported by this installiation. [quoted text, click to view] "Paul Clement" <UseAdddressAtEndofMessage@swspectrum.com> wrote in message news:nim942t0om308jq5v32c62sp9pq642b4g0@4ax.com... > On Mon, 17 Apr 2006 16:27:39 -0700, "M" <mxchen@hotvoice.com> wrote: > > ¤ > ¤ It seems to me the current VB.NET 2005 Express version does not support > ¤ connect to SQL Server 2000 or SQL Server 2005. Or I am not doing correctly. > ¤ I cannot even make the some samples project working > ¤ > > Could you be a bit more specific. How are you trying to connect? What sort of errors are you > getting? > > > Paul > ~~~~ > Microsoft MVP (Visual Basic) >
While I don't work with the Express edition of VS, it seems to me that the
Visual Studio UI does not support anything except the shared memory provider which means that it won't permit you to connect to any data source that's not on the same machine. That said, there is nothing to stop you from creating a ConnectionString on your own to connect to any data source--local or remote. -- ____________________________________ William (Bill) Vaughn Author, Mentor, Consultant Microsoft MVP INETA Speaker www.betav.com/blog/billva www.betav.com Please reply only to the newsgroup so that others can benefit. This posting is provided "AS IS" with no warranties, and confers no rights. __________________________________ [quoted text, click to view] "Chen" <mxchen100@hotmail.com> wrote in message news:OBf6BGwYGHA.4752@TK2MSFTNGP02.phx.gbl... > > If I try add a connection in database Explorer > > On database Explorer > I select "Add connection" > The Choose DataSource screen appear. > It alway assunme to connect to SQL server 2005 > and let you select a MDF file. > > After locate a MDF file and click test connection I get the error message: > An error has occured while establishing a connection to the server. When > connecting to SQL Server 2005, this failure may be caused by the fact that > under the daufault setting SQL Server does not allow remote connections > (provider: SQL Newwork interfaces, error:25 - connection string is not > valid) > Actually my SQL server 2005 database Engine set to using both TCP/IP and > named pipes, > allow remote connection. > > > If I try to open a SQL Database samples project:Creating and using User > Defined Types with SQL Server 2005 > > the message is > > The project file "..Microsoft Visual Studio 8\Samples\Data\Creating and > using User Defined Types with SQL Server 2005\UDT\UDT.vbproject" cannot > opened. > The project type is not supported by this installiation. > > "Paul Clement" <UseAdddressAtEndofMessage@swspectrum.com> wrote in message > news:nim942t0om308jq5v32c62sp9pq642b4g0@4ax.com... >> On Mon, 17 Apr 2006 16:27:39 -0700, "M" <mxchen@hotvoice.com> wrote: >> >> ¤ >> ¤ It seems to me the current VB.NET 2005 Express version does not support >> ¤ connect to SQL Server 2000 or SQL Server 2005. Or I am not doing > correctly. >> ¤ I cannot even make the some samples project working >> ¤ >> >> Could you be a bit more specific. How are you trying to connect? What >> sort > of errors are you >> getting? >> >> >> Paul >> ~~~~ >> Microsoft MVP (Visual Basic) >> > > >
[quoted text, click to view]
On Tue, 18 Apr 2006 09:02:31 -0700, "Chen" <mxchen100@hotmail.com> wrote: ¤ ¤ If I try add a connection in database Explorer ¤ ¤ On database Explorer ¤ I select "Add connection" ¤ The Choose DataSource screen appear. ¤ It alway assunme to connect to SQL server 2005 ¤ and let you select a MDF file. ¤ ¤ After locate a MDF file and click test connection I get the error message: ¤ An error has occured while establishing a connection to the server. When ¤ connecting to SQL Server 2005, this failure may be caused by the fact that ¤ under the daufault setting SQL Server does not allow remote connections ¤ (provider: SQL Newwork interfaces, error:25 - connection string is not ¤ valid) ¤ Actually my SQL server 2005 database Engine set to using both TCP/IP and ¤ named pipes, ¤ allow remote connection. Bill is correct. The GUI data tools in the Express Editions only support local databases. If you use the ADO.NET libraries instead it works just fine. Paul ~~~~
Thanks Actually the VB 2005 express Set 'Just my code' enabled and no way to change. If I declare Dim cn as New adodb.connection() or Dim cn as New SQLClient.sqlconnection(ConStr) None of them Allow me add the statement cn.open . The message is declaration expected. ALthough I declare it just one line ahead [quoted text, click to view] "Paul Clement" <UseAdddressAtEndofMessage@swspectrum.com> wrote in message news:qf9a4256p8e4aeooteccrc78tsictfmkdb@4ax.com... > On Tue, 18 Apr 2006 09:02:31 -0700, "Chen" <mxchen100@hotmail.com> wrote: > > ¤ > ¤ If I try add a connection in database Explorer > ¤ > ¤ On database Explorer > ¤ I select "Add connection" > ¤ The Choose DataSource screen appear. > ¤ It alway assunme to connect to SQL server 2005 > ¤ and let you select a MDF file. > ¤ > ¤ After locate a MDF file and click test connection I get the error message: > ¤ An error has occured while establishing a connection to the server. When > ¤ connecting to SQL Server 2005, this failure may be caused by the fact that > ¤ under the daufault setting SQL Server does not allow remote connections > ¤ (provider: SQL Newwork interfaces, error:25 - connection string is not > ¤ valid) > ¤ Actually my SQL server 2005 database Engine set to using both TCP/IP and > ¤ named pipes, > ¤ allow remote connection. > > Bill is correct. The GUI data tools in the Express Editions only support local databases. If you use > the ADO.NET libraries instead it works just fine. > > > Paul > ~~~~ > Microsoft MVP (Visual Basic) >
did you import the system.data.sqlclient DLL or add a reference to the
ADODB.DLL? -- ____________________________________ William (Bill) Vaughn Author, Mentor, Consultant Microsoft MVP INETA Speaker www.betav.com/blog/billva www.betav.com Please reply only to the newsgroup so that others can benefit. This posting is provided "AS IS" with no warranties, and confers no rights. __________________________________ [quoted text, click to view] "M" <mxchen@hotvoice.com> wrote in message news:eKyXBPzYGHA.1196@TK2MSFTNGP03.phx.gbl... > > Thanks > > Actually the VB 2005 express Set 'Just my code' enabled and no way to > change. > If I declare > Dim cn as New adodb.connection() > or > Dim cn as New SQLClient.sqlconnection(ConStr) > None of them Allow me add the statement > cn.open . > The message is declaration expected. ALthough I declare it just one line > ahead > > > > "Paul Clement" <UseAdddressAtEndofMessage@swspectrum.com> wrote in message > news:qf9a4256p8e4aeooteccrc78tsictfmkdb@4ax.com... >> On Tue, 18 Apr 2006 09:02:31 -0700, "Chen" <mxchen100@hotmail.com> wrote: >> >> ¤ >> ¤ If I try add a connection in database Explorer >> ¤ >> ¤ On database Explorer >> ¤ I select "Add connection" >> ¤ The Choose DataSource screen appear. >> ¤ It alway assunme to connect to SQL server 2005 >> ¤ and let you select a MDF file. >> ¤ >> ¤ After locate a MDF file and click test connection I get the error > message: >> ¤ An error has occured while establishing a connection to the server. >> When >> ¤ connecting to SQL Server 2005, this failure may be caused by the fact > that >> ¤ under the daufault setting SQL Server does not allow remote connections >> ¤ (provider: SQL Newwork interfaces, error:25 - connection string is not >> ¤ valid) >> ¤ Actually my SQL server 2005 database Engine set to using both TCP/IP >> and >> ¤ named pipes, >> ¤ allow remote connection. >> >> Bill is correct. The GUI data tools in the Express Editions only support > local databases. If you use >> the ADO.NET libraries instead it works just fine. >> >> >> Paul >> ~~~~ >> Microsoft MVP (Visual Basic) >> > > >
Yes.I did both the declare statements do not have problem. but VBEXPRESS ignore them. I think Microsoft do not want the free software to do to much thing. [quoted text, click to view] "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message news:O6pW0B1YGHA.1192@TK2MSFTNGP04.phx.gbl... > > did you import the system.data.sqlclient DLL or add a reference to the > ADODB.DLL? > > -- > ____________________________________ > William (Bill) Vaughn > Author, Mentor, Consultant > Microsoft MVP > INETA Speaker > www.betav.com/blog/billva > www.betav.com > Please reply only to the newsgroup so that others can benefit. > This posting is provided "AS IS" with no warranties, and confers no rights. > __________________________________ > > "M" <mxchen@hotvoice.com> wrote in message > news:eKyXBPzYGHA.1196@TK2MSFTNGP03.phx.gbl... > > > > Thanks > > > > Actually the VB 2005 express Set 'Just my code' enabled and no way to > > change. > > If I declare > > Dim cn as New adodb.connection() > > or > > Dim cn as New SQLClient.sqlconnection(ConStr) > > None of them Allow me add the statement > > cn.open . > > The message is declaration expected. ALthough I declare it just one line > > ahead > > > > > > > > "Paul Clement" <UseAdddressAtEndofMessage@swspectrum.com> wrote in message > > news:qf9a4256p8e4aeooteccrc78tsictfmkdb@4ax.com... > >> On Tue, 18 Apr 2006 09:02:31 -0700, "Chen" <mxchen100@hotmail.com> wrote: > >> > >> ¤ > >> ¤ If I try add a connection in database Explorer > >> ¤ > >> ¤ On database Explorer > >> ¤ I select "Add connection" > >> ¤ The Choose DataSource screen appear. > >> ¤ It alway assunme to connect to SQL server 2005 > >> ¤ and let you select a MDF file. > >> ¤ > >> ¤ After locate a MDF file and click test connection I get the error > > message: > >> ¤ An error has occured while establishing a connection to the server. > >> When > >> ¤ connecting to SQL Server 2005, this failure may be caused by the fact > > that > >> ¤ under the daufault setting SQL Server does not allow remote connections > >> ¤ (provider: SQL Newwork interfaces, error:25 - connection string is not > >> ¤ valid) > >> ¤ Actually my SQL server 2005 database Engine set to using both TCP/IP > >> and > >> ¤ named pipes, > >> ¤ allow remote connection. > >> > >> Bill is correct. The GUI data tools in the Express Editions only support > > local databases. If you use > >> the ADO.NET libraries instead it works just fine. > >> > >> > >> Paul > >> ~~~~ > >> Microsoft MVP (Visual Basic) > >> > > > > > > > > >
I just tried it in code in a virgin Visual Studio Express setup here. It
works fine. Again, the Visual Studio IDE won't let you setup a Database Explorer connection to external data sources but you can connect in code. Did you add an Imports System.Data.SqlClient? -- ____________________________________ William (Bill) Vaughn Author, Mentor, Consultant Microsoft MVP INETA Speaker www.betav.com/blog/billva www.betav.com Please reply only to the newsgroup so that others can benefit. This posting is provided "AS IS" with no warranties, and confers no rights. __________________________________ [quoted text, click to view] "M" <mxchen@hotvoice.com> wrote in message news:%23r0dZXVZGHA.4884@TK2MSFTNGP02.phx.gbl... > > Yes.I did both > the declare statements do not have problem. but VBEXPRESS ignore them. > I think Microsoft do not want the free software to do to much thing. > > > > "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message > news:O6pW0B1YGHA.1192@TK2MSFTNGP04.phx.gbl... >> >> did you import the system.data.sqlclient DLL or add a reference to the >> ADODB.DLL? >> >> -- >> ____________________________________ >> William (Bill) Vaughn >> Author, Mentor, Consultant >> Microsoft MVP >> INETA Speaker >> www.betav.com/blog/billva >> www.betav.com >> Please reply only to the newsgroup so that others can benefit. >> This posting is provided "AS IS" with no warranties, and confers no > rights. >> __________________________________ >> >> "M" <mxchen@hotvoice.com> wrote in message >> news:eKyXBPzYGHA.1196@TK2MSFTNGP03.phx.gbl... >> > >> > Thanks >> > >> > Actually the VB 2005 express Set 'Just my code' enabled and no way to >> > change. >> > If I declare >> > Dim cn as New adodb.connection() >> > or >> > Dim cn as New SQLClient.sqlconnection(ConStr) >> > None of them Allow me add the statement >> > cn.open . >> > The message is declaration expected. ALthough I declare it just one >> > line >> > ahead >> > >> > >> > >> > "Paul Clement" <UseAdddressAtEndofMessage@swspectrum.com> wrote in > message >> > news:qf9a4256p8e4aeooteccrc78tsictfmkdb@4ax.com... >> >> On Tue, 18 Apr 2006 09:02:31 -0700, "Chen" <mxchen100@hotmail.com> > wrote: >> >> >> >> ¤ >> >> ¤ If I try add a connection in database Explorer >> >> ¤ >> >> ¤ On database Explorer >> >> ¤ I select "Add connection" >> >> ¤ The Choose DataSource screen appear. >> >> ¤ It alway assunme to connect to SQL server 2005 >> >> ¤ and let you select a MDF file. >> >> ¤ >> >> ¤ After locate a MDF file and click test connection I get the error >> > message: >> >> ¤ An error has occured while establishing a connection to the server. >> >> When >> >> ¤ connecting to SQL Server 2005, this failure may be caused by the >> >> fact >> > that >> >> ¤ under the daufault setting SQL Server does not allow remote > connections >> >> ¤ (provider: SQL Newwork interfaces, error:25 - connection string is > not >> >> ¤ valid) >> >> ¤ Actually my SQL server 2005 database Engine set to using both TCP/IP >> >> and >> >> ¤ named pipes, >> >> ¤ allow remote connection. >> >> >> >> Bill is correct. The GUI data tools in the Express Editions only > support >> > local databases. If you use >> >> the ADO.NET libraries instead it works just fine. >> >> >> >> >> >> Paul >> >> ~~~~ >> >> Microsoft MVP (Visual Basic) >> >> >> > >> > >> > >> >> >> > > >
Thank, both of you are right. Last time when I tested it, I was using a microsoft sample project. I added few lines of the code but put them at wrong place-- outside a procedure [quoted text, click to view] "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message news:%23loqjeWZGHA.3524@TK2MSFTNGP04.phx.gbl... > > I just tried it in code in a virgin Visual Studio Express setup here. It > works fine. Again, the Visual Studio IDE won't let you setup a Database > Explorer connection to external data sources but you can connect in code. > Did you add an Imports System.Data.SqlClient? > > > -- > ____________________________________ > William (Bill) Vaughn > Author, Mentor, Consultant > Microsoft MVP > INETA Speaker > www.betav.com/blog/billva > www.betav.com > Please reply only to the newsgroup so that others can benefit. > This posting is provided "AS IS" with no warranties, and confers no rights. > __________________________________ > > "M" <mxchen@hotvoice.com> wrote in message > news:%23r0dZXVZGHA.4884@TK2MSFTNGP02.phx.gbl... > > > > Yes.I did both > > the declare statements do not have problem. but VBEXPRESS ignore them. > > I think Microsoft do not want the free software to do to much thing. > > > > > > > > "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message > > news:O6pW0B1YGHA.1192@TK2MSFTNGP04.phx.gbl... > >> > >> did you import the system.data.sqlclient DLL or add a reference to the > >> ADODB.DLL? > >> > >> -- > >> ____________________________________ > >> William (Bill) Vaughn > >> Author, Mentor, Consultant > >> Microsoft MVP > >> INETA Speaker > >> www.betav.com/blog/billva > >> www.betav.com > >> Please reply only to the newsgroup so that others can benefit. > >> This posting is provided "AS IS" with no warranties, and confers no > > rights. > >> __________________________________ > >> > >> "M" <mxchen@hotvoice.com> wrote in message > >> news:eKyXBPzYGHA.1196@TK2MSFTNGP03.phx.gbl... > >> > > >> > Thanks > >> > > >> > Actually the VB 2005 express Set 'Just my code' enabled and no way to > >> > change. > >> > If I declare > >> > Dim cn as New adodb.connection() > >> > or > >> > Dim cn as New SQLClient.sqlconnection(ConStr) > >> > None of them Allow me add the statement > >> > cn.open . > >> > The message is declaration expected. ALthough I declare it just one > >> > line > >> > ahead > >> > > >> > > >> > > >> > "Paul Clement" <UseAdddressAtEndofMessage@swspectrum.com> wrote in > > message > >> > news:qf9a4256p8e4aeooteccrc78tsictfmkdb@4ax.com... > >> >> On Tue, 18 Apr 2006 09:02:31 -0700, "Chen" <mxchen100@hotmail.com> > > wrote: > >> >> > >> >> ¤ > >> >> ¤ If I try add a connection in database Explorer > >> >> ¤ > >> >> ¤ On database Explorer > >> >> ¤ I select "Add connection" > >> >> ¤ The Choose DataSource screen appear. > >> >> ¤ It alway assunme to connect to SQL server 2005 > >> >> ¤ and let you select a MDF file. > >> >> ¤ > >> >> ¤ After locate a MDF file and click test connection I get the error > >> > message: > >> >> ¤ An error has occured while establishing a connection to the server. > >> >> When > >> >> ¤ connecting to SQL Server 2005, this failure may be caused by the > >> >> fact > >> > that > >> >> ¤ under the daufault setting SQL Server does not allow remote > > connections > >> >> ¤ (provider: SQL Newwork interfaces, error:25 - connection string is > > not > >> >> ¤ valid) > >> >> ¤ Actually my SQL server 2005 database Engine set to using both TCP/IP > >> >> and > >> >> ¤ named pipes, > >> >> ¤ allow remote connection. > >> >> > >> >> Bill is correct. The GUI data tools in the Express Editions only > > support > >> > local databases. If you use > >> >> the ADO.NET libraries instead it works just fine. > >> >> > >> >> > >> >> Paul > >> >> ~~~~ > >> >> Microsoft MVP (Visual Basic) > >> >> > >> > > >> > > >> > > >> > >> > >> > > > > > > > > >
[quoted text, click to view]
On Fri, 21 Apr 2006 08:11:18 -0700, "M" <mxchen@hotvoice.com> wrote: ¤ ¤ Yes.I did both ¤ the declare statements do not have problem. but VBEXPRESS ignore them. ¤ I think Microsoft do not want the free software to do to much thing. ¤ You might want to post some code if you are still having problems. Paul ~~~~
VB 2005 Express doesn't support remote access to databases. You can only use local files.
Actually, that's not really true--at least not completely. While the user
interface in VS Express does not support remote databases, there is nothing to stop you from writing code to do so. -- ____________________________________ William (Bill) Vaughn Author, Mentor, Consultant Microsoft MVP INETA Speaker www.betav.com/blog/billva www.betav.com Please reply only to the newsgroup so that others can benefit. This posting is provided "AS IS" with no warranties, and confers no rights. __________________________________ [quoted text, click to view] <Rui> wrote in message news:uBgOYHzaGHA.508@TK2MSFTNGP02.phx.gbl... > VB 2005 Express doesn't support remote access to databases. You can only > use local files. > > See this http://msdn.microsoft.com/vstudio/products/compare/
Don't see what you're looking for? Try a search.
|
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
| home · blog · groups | Questions? Comments? Contact the dn |