468,133 Members | 1,265 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,133 developers. It's quick & easy.

VB Express 2005 and SQL 2000

I've installed VB Express 2005 and SQL Server 2005 Express on a workstation
that had SQL 2000 on it.

I can only get VB Express to connect to the SQL Server 2005. From other
groups I read that SQLEXPRESS was the connection to SQL Server 2005 and I
should use LOCAL for SQL 2000. However, in VB Express this field is not
editable.

I would have thought there would have been entries for SQL 2000 when
creating a new data connection.

Is there another component (or add-in) that I need to add?

THANKS,

MEG

Jul 10 '07 #1
3 1162
When multiple versions of SQL Server/multiple SQL Server instances installed
on single computer, you can only have one instance (regardless SQL Server
version) as default instance, all others must be named instance. "Default
instance" means you can refer to it with the computer name or "local".

In you case, you have to know which on is installed as default instance.
Since you installed SQL Server Express with VB2005Express, so it most likely
is a named instance, called "MachineName\SQLEXPRESS" (unless you specified
different name for it during installation), or you can refer it as
".\SQLEXPRESS" in the ConnectionString.

If you are sure the SQL Server2000 was installed as default instance, you
can refer to it as "local" or "MachineName"

"MEG" <ME*@discussions.microsoft.comwrote in message
news:03**********************************@microsof t.com...
I've installed VB Express 2005 and SQL Server 2005 Express on a
workstation
that had SQL 2000 on it.

I can only get VB Express to connect to the SQL Server 2005. From other
groups I read that SQLEXPRESS was the connection to SQL Server 2005 and I
should use LOCAL for SQL 2000. However, in VB Express this field is not
editable.

I would have thought there would have been entries for SQL 2000 when
creating a new data connection.

Is there another component (or add-in) that I need to add?

THANKS,

MEG

Jul 10 '07 #2
Norman:

Thank you for the reply.

You're correct that the data source is .\SQLEXPRESS. When I try to change
the value, the list box only has that entry. And of course, it won't let me
type it in. Is there a "parameter" list somewhere that I need to add that
entry in?

Thanks,

MEG

"Norman Yuan" wrote:
When multiple versions of SQL Server/multiple SQL Server instances installed
on single computer, you can only have one instance (regardless SQL Server
version) as default instance, all others must be named instance. "Default
instance" means you can refer to it with the computer name or "local".

In you case, you have to know which on is installed as default instance.
Since you installed SQL Server Express with VB2005Express, so it most likely
is a named instance, called "MachineName\SQLEXPRESS" (unless you specified
different name for it during installation), or you can refer it as
".\SQLEXPRESS" in the ConnectionString.

If you are sure the SQL Server2000 was installed as default instance, you
can refer to it as "local" or "MachineName"

"MEG" <ME*@discussions.microsoft.comwrote in message
news:03**********************************@microsof t.com...
I've installed VB Express 2005 and SQL Server 2005 Express on a
workstation
that had SQL 2000 on it.

I can only get VB Express to connect to the SQL Server 2005. From other
groups I read that SQLEXPRESS was the connection to SQL Server 2005 and I
should use LOCAL for SQL 2000. However, in VB Express this field is not
editable.

I would have thought there would have been entries for SQL 2000 when
creating a new data connection.

Is there another component (or add-in) that I need to add?

THANKS,

MEG


Jul 11 '07 #3
Can anyone answer this question about choosing a data source?

"MEG" wrote:
Norman:

Thank you for the reply.

You're correct that the data source is .\SQLEXPRESS. When I try to change
the value, the list box only has that entry. And of course, it won't let me
type it in. Is there a "parameter" list somewhere that I need to add that
entry in?

Thanks,

MEG

"Norman Yuan" wrote:
When multiple versions of SQL Server/multiple SQL Server instances installed
on single computer, you can only have one instance (regardless SQL Server
version) as default instance, all others must be named instance. "Default
instance" means you can refer to it with the computer name or "local".

In you case, you have to know which on is installed as default instance.
Since you installed SQL Server Express with VB2005Express, so it most likely
is a named instance, called "MachineName\SQLEXPRESS" (unless you specified
different name for it during installation), or you can refer it as
".\SQLEXPRESS" in the ConnectionString.

If you are sure the SQL Server2000 was installed as default instance, you
can refer to it as "local" or "MachineName"

"MEG" <ME*@discussions.microsoft.comwrote in message
news:03**********************************@microsof t.com...
I've installed VB Express 2005 and SQL Server 2005 Express on a
workstation
that had SQL 2000 on it.
>
I can only get VB Express to connect to the SQL Server 2005. From other
groups I read that SQLEXPRESS was the connection to SQL Server 2005 and I
should use LOCAL for SQL 2000. However, in VB Express this field is not
editable.
>
I would have thought there would have been entries for SQL 2000 when
creating a new data connection.
>
Is there another component (or add-in) that I need to add?
>
THANKS,
>
MEG
>
Jul 13 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Lubomir | last post: by
6 posts views Thread by Grey Alien | last post: by
1 post views Thread by gcdp | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.