vbexpress and sql2000

  • Thread starter Thread starter Robert Bravery
  • Start date Start date
R

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
 
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
 
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
 
HI,

From this I gather that any of the express packages cannot connect to other
database servers, like oracle, Interbase, Firebird, MySQ etc

Robert
 
From this I gather that any of the express packages cannot connect to
other
database servers, like oracle, Interbase, Firebird, MySQ etc
Click to expand...

Seems odd considering all of the translation layers from the app to the DB
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
----------------
 
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.
Click to expand...

Any thoughts on JET connectivity?

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
 
If you do, let me know

Thanks
Robert

Ken Tucker said:
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
Click to expand...
 
Yes, you can run both on the same PC.

haber iletisinde þunlarý said:
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

message
Click to expand...
 
¤ 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)
 
Back
Top