Interaction between SQL2k, SQL2k5, and SQLExpress

I've got both SQL2000 and SQL2005 running side-by-side and now I want to
test a ClickOnce deployment of my app with SQLExpress. Anyone been down this
road and know whether I will step on the toes of the installed servers?Hi Earl
I have not tried this but I believe you should be ok, although it is worth
trying it first in as many different scenarios as you can get!
John
"Earl" wrote:
> I've got both SQL2000 and SQL2005 running side-by-side and now I want to
> test a ClickOnce deployment of my app with SQLExpress. Anyone been down this
> road and know whether I will step on the toes of the installed servers?
>
>

Interaction between SQL2k, SQL2k5, and SQLExpress

I've got both SQL2000 and SQL2005 running side-by-side and now I want to
test a ClickOnce deployment of my app with SQLExpress. Anyone been down this
road and know whether I will step on the toes of the installed servers?Hi Earl
I have not tried this but I believe you should be ok, although it is worth
trying it first in as many different scenarios as you can get!
John
"Earl" wrote:

> I've got both SQL2000 and SQL2005 running side-by-side and now I want to
> test a ClickOnce deployment of my app with SQLExpress. Anyone been down th
is
> road and know whether I will step on the toes of the installed servers?
>
>

Integrating MSDE 2000 with VB Applications

Hi,
I have VB 6.0 application using MSDE 2000.
I created setup file using Package & Deployment Wizard.
I have included "SQL Server Desktop Engine Merge Modules" and
"sqlredis.exe".
However, when I try to test it on another computer, I get following error.
DBNETLIB[ConnectionOpen(Connect()).] SQL Server does not exists or access is
denied.
clicking OK comes up with
Runtime error -2147467259 (80004005)
Automation Error
Unspecified error.
What am I missing?
Any Idea? Let me know if further info needed.
Shailesh
hi Shailesh,
Shailesh Patel wrote:
> Hi,
> I have VB 6.0 application using MSDE 2000.
> I created setup file using Package & Deployment Wizard.
> I have included "SQL Server Desktop Engine Merge Modules" and
> "sqlredis.exe".
> However, when I try to test it on another computer, I get following
> error. DBNETLIB[ConnectionOpen(Connect()).] SQL Server does not
> exists or access is denied.
> clicking OK comes up with
> Runtime error -2147467259 (80004005)
> Automation Error
> Unspecified error.
> What am I missing?
> Any Idea? Let me know if further info needed.
> Shailesh
please have a look at
http://support.microsoft.com/default...06&Product=sql
if helps
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply