vbexpress and sql2000

[Robert Bravery]

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]]

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/ex...t/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]

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]" <Ke**********@discussions.microsoft.com> wrote in message
news:BA**********************************@microsof t.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/ex...t/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]

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]" <Ke**********@discussions.microsoft.com> wrote in message
news:BA**********************************@microsof t.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/ex...t/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

[Homer J Simpson]

"Robert Bravery" <[e-mail]> wrote in message
news:e4**************@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

Seems odd considering all of the translation layers from the app to the DB
but I believe you.

[Ken Tucker [MVP]]

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" <[e-mail]> wrote in message
news:e4**************@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]" <Ke**********@discussions.microsoft.com> wrote in
message
news:BA**********************************@microsof t.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/ex...t/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
>
>
>

[Homer J Simpson]

"Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message
news:%2****************@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

[Cyril Gupta]

VB Express connects just fine to Jet. I am developing a commercial level
software in it right now and using Jet database.

Regards
Cyril

[Homer J Simpson]

"Cyril Gupta" <no****@mail.com> wrote in message
news:u8**************@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.

That's good to know!

[Robert Bravery]

Well I was able to connect to Access, I gather throu Jet

Robert

"Homer J Simpson" <no****@nowhere.com> wrote in message
news:5YByf.83917$AP5.4301@edtnps84...

"Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message
news:%2****************@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

[Robert Bravery]

If you do, let me know

Thanks
Robert

"Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message
news:%2****************@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" <[e-mail]> wrote in message
news:e4**************@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]" <Ke**********@discussions.microsoft.com> wrote in
message
news:BA**********************************@microsof t.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/ex...t/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
>
>
>

[hre]

Yes, you can run both on the same PC.

"Robert Bravery" <[e-mail]>, haber iletisinde þunlarý
yazdý:eo**************@TK2MSFTNGP11.phx.gbl...

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]" <Ke**********@discussions.microsoft.com> wrote in
message
news:BA**********************************@microsof t.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/ex...t/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
>
>
>

[Paul Clement]

On Mon, 16 Jan 2006 09:19:33 +0200, "Robert Bravery" <[e-mail]> 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)