|
web
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
vbexpress and sql2000HI all,
I downloaded vbexpress and am trying to connect to my sql 2000 server, but keep on getting this error messag: "An error occured while establishing a conenction to the server. When connecting to SQL server 2005, this failure may be caused by the fact that under the default settings SQL server does not allow remote connections" My sqlserver2000 is running. I can connect to it via VS2003, and via dBASE. So I know its workin. Downloaded SQLEXPRESS and reied to install, but never saw any changes Does VBexpress only work with SQLexpress. When installing SQLexpress, will it install a seperate instance to an existing sql2000 instalation. Thanks Robert Hi,
Frpm the vb express readme file. 1.3.13 SQL Server Express is the only version of SQL Server that will work with Express Editions other than Visual Web Developer Express Edition. SQL Server Express is the only version of SQL Server that will work with Visual Basic 2005 Express Edition, Visual C++ 2005 Express Edition, Visual C# 2005 Express Edition, and Visual J# 2005 Express Edition. To resolve this issue If you did not specify SQL Server Express when you installed your Express Edition, you can install it by using Add or Remove Programs in the Windows Control Panel. http://msdn.microsoft.com/vstudio/express/support/readme/#exvb Ken --------------------- Show quoteHide quote "Robert Bravery" wrote: > HI all, > > I downloaded vbexpress and am trying to connect to my sql 2000 server, but > keep on getting this error messag: > "An error occured while establishing a conenction to the server. When > connecting to SQL server 2005, this failure may be caused by the fact that > under the default settings SQL server does not allow remote connections" > > My sqlserver2000 is running. I can connect to it via VS2003, and via dBASE. > So I know its workin. > Downloaded SQLEXPRESS and reied to install, but never saw any changes > Does VBexpress only work with SQLexpress. > When installing SQLexpress, will it install a seperate instance to an > existing sql2000 instalation. > > Thanks > Robert > > > HI Ken,
I did run the install of SQLserverExpress. it installed, but does not seem to be running. Altho my SQL2000 is still running. My question is can you have SQL2000 and SQLExpress running on the same PC, in order to evaluate and use VBexpress. If you cant, then it is of no use to me because I cannot uninstall my sqlserver, on my development PC If you can have bot sql server versions running, How then? Thanks Robert Show quoteHide quote "Ken Tucker [MVP]" <KenTucker***@discussions.microsoft.com> wrote in message news:BA25CA7C-66DD-48B0-B43E-5C8951E4C553@microsoft.com... > Hi, > > Frpm the vb express readme file. > > 1.3.13 SQL Server Express is the only version of SQL Server that will work > with Express Editions other than Visual Web Developer Express Edition. > > SQL Server Express is the only version of SQL Server that will work with > Visual Basic 2005 Express Edition, Visual C++ 2005 Express Edition, Visual C# > 2005 Express Edition, and Visual J# 2005 Express Edition. > > To resolve this issue > > If you did not specify SQL Server Express when you installed your Express > Edition, you can install it by using Add or Remove Programs in the Windows > Control Panel. > > http://msdn.microsoft.com/vstudio/express/support/readme/#exvb > > Ken > --------------------- > > "Robert Bravery" wrote: > > > HI all, > > > > I downloaded vbexpress and am trying to connect to my sql 2000 server, but > > keep on getting this error messag: > > "An error occured while establishing a conenction to the server. When > > connecting to SQL server 2005, this failure may be caused by the fact that > > under the default settings SQL server does not allow remote connections" > > > > My sqlserver2000 is running. I can connect to it via VS2003, and via dBASE. > > So I know its workin. > > Downloaded SQLEXPRESS and reied to install, but never saw any changes > > Does VBexpress only work with SQLexpress. > > When installing SQLexpress, will it install a seperate instance to an > > existing sql2000 instalation. > > > > Thanks > > Robert > > > > > > Yes, you can run both on the same PC.
"Robert Bravery" <m*@u.com>, haber iletisinde þunlarý yazdý:eouoPDhGGHA.3***@TK2MSFTNGP11.phx.gbl...Show quoteHide quote > HI Ken, > > I did run the install of SQLserverExpress. it installed, but does not seem > to be running. Altho my SQL2000 is still running. > My question is can you have SQL2000 and SQLExpress running on the same PC, > in order to evaluate and use VBexpress. If you cant, then it is of no use > to > me because I cannot uninstall my sqlserver, on my development PC > If you can have bot sql server versions running, How then? > > Thanks > Robert > > "Ken Tucker [MVP]" <KenTucker***@discussions.microsoft.com> wrote in > message > news:BA25CA7C-66DD-48B0-B43E-5C8951E4C553@microsoft.com... >> Hi, >> >> Frpm the vb express readme file. >> >> 1.3.13 SQL Server Express is the only version of SQL Server that will >> work >> with Express Editions other than Visual Web Developer Express Edition. >> >> SQL Server Express is the only version of SQL Server that will work with >> Visual Basic 2005 Express Edition, Visual C++ 2005 Express Edition, >> Visual > C# >> 2005 Express Edition, and Visual J# 2005 Express Edition. >> >> To resolve this issue >> >> If you did not specify SQL Server Express when you installed your Express >> Edition, you can install it by using Add or Remove Programs in the >> Windows >> Control Panel. >> >> http://msdn.microsoft.com/vstudio/express/support/readme/#exvb >> >> Ken >> --------------------- >> >> "Robert Bravery" wrote: >> >> > HI all, >> > >> > I downloaded vbexpress and am trying to connect to my sql 2000 server, > but >> > keep on getting this error messag: >> > "An error occured while establishing a conenction to the server. When >> > connecting to SQL server 2005, this failure may be caused by the fact > that >> > under the default settings SQL server does not allow remote >> > connections" >> > >> > My sqlserver2000 is running. I can connect to it via VS2003, and via > dBASE. >> > So I know its workin. >> > Downloaded SQLEXPRESS and reied to install, but never saw any changes >> > Does VBexpress only work with SQLexpress. >> > When installing SQLexpress, will it install a seperate instance to an >> > existing sql2000 instalation. >> > >> > Thanks >> > Robert >> > >> > >> > > > HI,
From this I gather that any of the express packages cannot connect to other database servers, like oracle, Interbase, Firebird, MySQ etc Robert Show quoteHide quote "Ken Tucker [MVP]" <KenTucker***@discussions.microsoft.com> wrote in message news:BA25CA7C-66DD-48B0-B43E-5C8951E4C553@microsoft.com... > Hi, > > Frpm the vb express readme file. > > 1.3.13 SQL Server Express is the only version of SQL Server that will work > with Express Editions other than Visual Web Developer Express Edition. > > SQL Server Express is the only version of SQL Server that will work with > Visual Basic 2005 Express Edition, Visual C++ 2005 Express Edition, Visual C# > 2005 Express Edition, and Visual J# 2005 Express Edition. > > To resolve this issue > > If you did not specify SQL Server Express when you installed your Express > Edition, you can install it by using Add or Remove Programs in the Windows > Control Panel. > > http://msdn.microsoft.com/vstudio/express/support/readme/#exvb > > Ken > --------------------- > > "Robert Bravery" wrote: > > > HI all, > > > > I downloaded vbexpress and am trying to connect to my sql 2000 server, but > > keep on getting this error messag: > > "An error occured while establishing a conenction to the server. When > > connecting to SQL server 2005, this failure may be caused by the fact that > > under the default settings SQL server does not allow remote connections" > > > > My sqlserver2000 is running. I can connect to it via VS2003, and via dBASE. > > So I know its workin. > > Downloaded SQLEXPRESS and reied to install, but never saw any changes > > Does VBexpress only work with SQLexpress. > > When installing SQLexpress, will it install a seperate instance to an > > existing sql2000 instalation. > > > > Thanks > > Robert > > > > > > "Robert Bravery" <m*@u.com> wrote in message Seems odd considering all of the translation layers from the app to the DB news:e4gXPKhGGHA.3776@TK2MSFTNGP10.phx.gbl... > From this I gather that any of the express packages cannot connect to > other > database servers, like oracle, Interbase, Firebird, MySQ etc but I believe you. Hi,
I remember reading some was able to connect to an sql server 2000 with the oledb classes. I cant seam to find the link right now. Ken ---------------- Show quoteHide quote "Robert Bravery" <m*@u.com> wrote in message news:e4gXPKhGGHA.3776@TK2MSFTNGP10.phx.gbl... > HI, > > From this I gather that any of the express packages cannot connect to > other > database servers, like oracle, Interbase, Firebird, MySQ etc > > Robert > > "Ken Tucker [MVP]" <KenTucker***@discussions.microsoft.com> wrote in > message > news:BA25CA7C-66DD-48B0-B43E-5C8951E4C553@microsoft.com... >> Hi, >> >> Frpm the vb express readme file. >> >> 1.3.13 SQL Server Express is the only version of SQL Server that will >> work >> with Express Editions other than Visual Web Developer Express Edition. >> >> SQL Server Express is the only version of SQL Server that will work with >> Visual Basic 2005 Express Edition, Visual C++ 2005 Express Edition, >> Visual > C# >> 2005 Express Edition, and Visual J# 2005 Express Edition. >> >> To resolve this issue >> >> If you did not specify SQL Server Express when you installed your Express >> Edition, you can install it by using Add or Remove Programs in the >> Windows >> Control Panel. >> >> http://msdn.microsoft.com/vstudio/express/support/readme/#exvb >> >> Ken >> --------------------- >> >> "Robert Bravery" wrote: >> >> > HI all, >> > >> > I downloaded vbexpress and am trying to connect to my sql 2000 server, > but >> > keep on getting this error messag: >> > "An error occured while establishing a conenction to the server. When >> > connecting to SQL server 2005, this failure may be caused by the fact > that >> > under the default settings SQL server does not allow remote >> > connections" >> > >> > My sqlserver2000 is running. I can connect to it via VS2003, and via > dBASE. >> > So I know its workin. >> > Downloaded SQLEXPRESS and reied to install, but never saw any changes >> > Does VBexpress only work with SQLexpress. >> > When installing SQLexpress, will it install a seperate instance to an >> > existing sql2000 instalation. >> > >> > Thanks >> > Robert >> > >> > >> > > > "Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message Any thoughts on JET connectivity?news:%23ui4OCjGGHA.3200@tk2msftngp13.phx.gbl... > Hi, > > I remember reading some was able to connect to an sql server 2000 > with the oledb classes. I cant seam to find the link right now. H VB Express connects just fine to Jet. I am developing a commercial level
software in it right now and using Jet database. Regards Cyril "Cyril Gupta" <nom***@mail.com> wrote in message That's good to know!news:u8PXJajGGHA.2036@TK2MSFTNGP14.phx.gbl... > VB Express connects just fine to Jet. I am developing a commercial level > software in it right now and using Jet database. Well I was able to connect to Access, I gather throu Jet
Robert "Homer J Simpson" <nob***@nowhere.com> wrote in message news:5YByf.83917$AP5.4301@edtnps84...Show quoteHide quote > > "Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message > news:%23ui4OCjGGHA.3200@tk2msftngp13.phx.gbl... > > > Hi, > > > > I remember reading some was able to connect to an sql server 2000 > > with the oledb classes. I cant seam to find the link right now. > > Any thoughts on JET connectivity? > > H > > If you do, let me know
Thanks Robert Show quoteHide quote "Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message news:%23ui4OCjGGHA.3200@tk2msftngp13.phx.gbl... > Hi, > > I remember reading some was able to connect to an sql server 2000 > with the oledb classes. I cant seam to find the link right now. > > Ken > ---------------- > "Robert Bravery" <m*@u.com> wrote in message > news:e4gXPKhGGHA.3776@TK2MSFTNGP10.phx.gbl... > > HI, > > > > From this I gather that any of the express packages cannot connect to > > other > > database servers, like oracle, Interbase, Firebird, MySQ etc > > > > Robert > > > > "Ken Tucker [MVP]" <KenTucker***@discussions.microsoft.com> wrote in > > message > > news:BA25CA7C-66DD-48B0-B43E-5C8951E4C553@microsoft.com... > >> Hi, > >> > >> Frpm the vb express readme file. > >> > >> 1.3.13 SQL Server Express is the only version of SQL Server that will > >> work > >> with Express Editions other than Visual Web Developer Express Edition. > >> > >> SQL Server Express is the only version of SQL Server that will work with > >> Visual Basic 2005 Express Edition, Visual C++ 2005 Express Edition, > >> Visual > > C# > >> 2005 Express Edition, and Visual J# 2005 Express Edition. > >> > >> To resolve this issue > >> > >> If you did not specify SQL Server Express when you installed your Express > >> Edition, you can install it by using Add or Remove Programs in the > >> Windows > >> Control Panel. > >> > >> http://msdn.microsoft.com/vstudio/express/support/readme/#exvb > >> > >> Ken > >> --------------------- > >> > >> "Robert Bravery" wrote: > >> > >> > HI all, > >> > > >> > I downloaded vbexpress and am trying to connect to my sql 2000 server, > > but > >> > keep on getting this error messag: > >> > "An error occured while establishing a conenction to the server. When > >> > connecting to SQL server 2005, this failure may be caused by the fact > > that > >> > under the default settings SQL server does not allow remote > >> > connections" > >> > > >> > My sqlserver2000 is running. I can connect to it via VS2003, and via > > dBASE. > >> > So I know its workin. > >> > Downloaded SQLEXPRESS and reied to install, but never saw any changes > >> > Does VBexpress only work with SQLexpress. > >> > When installing SQLexpress, will it install a seperate instance to an > >> > existing sql2000 instalation. > >> > > >> > Thanks > >> > Robert > >> > > >> > > >> > > > > > > > On Mon, 16 Jan 2006 09:19:33 +0200, "Robert Bravery" <m*@u.com> wrote: ¤ If you do, let me know¤ Dim DatabaseConnection As New System.Data.OleDb.OleDbConnection 'Standard Security DatabaseConnection.ConnectionString = "Provider=sqloledb;" & _ "Data Source=myServerName;" & _ "Initial Catalog=myDatabaseName;" & _ "User Id=myUsername;" & _ "Password=myPassword" 'Trusted connection DatabaseConnection.ConnectionString = "Provider=sqloledb;" & _ "Data Source=myServerName;" & _ "Initial Catalog=myDatabaseName;" & _ "Integrated Security=SSPI" 'Named instance DatabaseConnection.ConnectionString = "Provider=sqloledb;" & _ "Data Source=myServerName\myInstanceName;" & _ "Initial Catalog=myDatabaseName;" & _ "User Id=myUsername;" & _ "Password=myPassword" DatabaseConnection.Open() Paul ~~~~ Microsoft MVP (Visual Basic) 
Other interesting topics
Which database should I use?
How to set the TextBox digital only? help urgent help !!!! databinding with text box Wall Charts 2005 No Setup Project in 2005 Express Edition? Keep form on top of everything - even other apps ? Namespace not available... Deleting all forms in collection next / next x difference |
|||||||||||||||||||||||
