SQL Express Edition Network Deployment Error

[CypherDrive]

Guys and Gals,

Have a problem... Here it goes...

The file ..... is on a network path that is not supported for database
files..
an attempt to attached an auto named database for a file failed.
A database with the same name exist or specified file cannot be opened.

What we did was we copied our entire vb.net program with an mssql express
edition database to another computer on a network
and then we shared the folder as a full access folder and then .. we copied
our entire vb.net program on another machine and then...
we changed the connection string to an unc path using \\vbnet\program etc..

The error above appeared.

What was wrong?

Does it mean we need to have another license of an sql server express
edition run on that machine?
Is there another way to deploy them and install only .net framework and copy
the mdf file?

Thanks,

Cypher Drive.

 

[Jialiang Ge [MSFT]]

Hello Cypher,

The issue of "The file *.mdf is on a network path that is not supported for
database files" is caused by one of the SQL Express limits:

SQL Server 2005 Express Edition Overview
http://msdn.microsoft.com/en-us/library/ms345154.aspx

<quote>
SQL Server supports using multiple data and log files for a database and
these files can be distributed in multiple file groups. This is not
supported in the AttachDBFileName syntax. *Also the network share, HTTP
paths, or Universal Naming Conventional (UNC) remote databases are not
supported.*
</quote>

Because your mdf is located in a network share and our app accesses the mdf
through the unc path, the error is thrown for lack of the UNC remote DB
support. Having another license of an SQL Server Express edition run on
that machine will not help either. In other words, if we have to use SQL
Server Expression edition, the DB must be local for it to work. For your
scenario, the possible solutions are:

1. Install SQL Server of Non-Express edition (e.g. Enterprise Edition) and
attach the mdf to the server.
(I can understand that you may not choose this solution according to our
communications in the past.)

2. If the mdf must stay remotely, you may consider building a data access
layer (DAL) on that remote machine (DAL stays with the mdf), and expose the
interfaces of DAL to our application through the tech like web service. In
this way, our app calls the DAL to do the DB operations.

For more information about DAL, please refer to the articles:
http://msdn.microsoft.com/en-us/magazine/cc188750.aspx
http://msdn.microsoft.com/en-us/library/aa581778.aspx

Regards,
Jialiang Ge ([email protected], remove 'online.')
Microsoft Online Community Support

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[CypherDrive]

Ge,

Truly you are right.

Thanks so much.

I have instructed my colleague to ask for a quotation of MS SQL Standard to
solve our problem. There is a 25% Discount on SQL Server up to Sept this
year.

If it is still expensive. We will end up using Visual foxpro 7.0 or MS
Access 2003. In your opinion which among the two is better to use?


So sad to hear that it only functions locally.


Thanks again.

Regards,

Cypher...

Hello Cypher,

The issue of "The file *.mdf is on a network path that is not supported
for
database files" is caused by one of the SQL Express limits:

SQL Server 2005 Express Edition Overview
http://msdn.microsoft.com/en-us/library/ms345154.aspx

<quote>
SQL Server supports using multiple data and log files for a database and
these files can be distributed in multiple file groups. This is not
supported in the AttachDBFileName syntax. *Also the network share, HTTP
paths, or Universal Naming Conventional (UNC) remote databases are not
supported.*
</quote>

Because your mdf is located in a network share and our app accesses the
mdf
through the unc path, the error is thrown for lack of the UNC remote DB
support. Having another license of an SQL Server Express edition run on
that machine will not help either. In other words, if we have to use SQL
Server Expression edition, the DB must be local for it to work. For your
scenario, the possible solutions are:

1. Install SQL Server of Non-Express edition (e.g. Enterprise Edition) and
attach the mdf to the server.
(I can understand that you may not choose this solution according to our
communications in the past.)

2. If the mdf must stay remotely, you may consider building a data access
layer (DAL) on that remote machine (DAL stays with the mdf), and expose
the
interfaces of DAL to our application through the tech like web service. In
this way, our app calls the DAL to do the DB operations.

For more information about DAL, please refer to the articles:
http://msdn.microsoft.com/en-us/magazine/cc188750.aspx
http://msdn.microsoft.com/en-us/library/aa581778.aspx

Regards,
Jialiang Ge ([email protected], remove 'online.')
Microsoft Online Community Support

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no
rights.

 

[Kerry Moorman]

CypherDrive,

I would avoid Access for anything other than single-user, personal use.

You might also want to look into using one of the open source database
products like MySQL or PostGreSql.

Kerry Moorman

Ge,

Truly you are right.

Thanks so much.

I have instructed my colleague to ask for a quotation of MS SQL Standard to
solve our problem. There is a 25% Discount on SQL Server up to Sept this
year.

If it is still expensive. We will end up using Visual foxpro 7.0 or MS
Access 2003. In your opinion which among the two is better to use?


So sad to hear that it only functions locally.


Thanks again.

Regards,

Cypher...

Hello Cypher,

The issue of "The file *.mdf is on a network path that is not supported
for
database files" is caused by one of the SQL Express limits:

SQL Server 2005 Express Edition Overview
http://msdn.microsoft.com/en-us/library/ms345154.aspx

<quote>
SQL Server supports using multiple data and log files for a database and
these files can be distributed in multiple file groups. This is not
supported in the AttachDBFileName syntax. *Also the network share, HTTP
paths, or Universal Naming Conventional (UNC) remote databases are not
supported.*
</quote>

Because your mdf is located in a network share and our app accesses the
mdf
through the unc path, the error is thrown for lack of the UNC remote DB
support. Having another license of an SQL Server Express edition run on
that machine will not help either. In other words, if we have to use SQL
Server Expression edition, the DB must be local for it to work. For your
scenario, the possible solutions are:

1. Install SQL Server of Non-Express edition (e.g. Enterprise Edition) and
attach the mdf to the server.
(I can understand that you may not choose this solution according to our
communications in the past.)

2. If the mdf must stay remotely, you may consider building a data access
layer (DAL) on that remote machine (DAL stays with the mdf), and expose
the
interfaces of DAL to our application through the tech like web service. In
this way, our app calls the DAL to do the DB operations.

For more information about DAL, please refer to the articles:
http://msdn.microsoft.com/en-us/magazine/cc188750.aspx
http://msdn.microsoft.com/en-us/library/aa581778.aspx

Regards,
Jialiang Ge ([email protected], remove 'online.')
Microsoft Online Community Support

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no
rights.

 

[CypherDrive]

Dear Kerry,

The last time I checked my developers where finding it hard to find
documentations that will link the VB.NEt with MYSQL.
Do you have basic references that can help us with this? How do we create
connection strings, Binding Controls to datasets, Adding, Deleting, Editing,
Finding? Do we need to download something to implement this? How do I start?

Regards

Alvin

CypherDrive,

I would avoid Access for anything other than single-user, personal use.

You might also want to look into using one of the open source database
products like MySQL or PostGreSql.

Kerry Moorman

Ge,

Truly you are right.

Thanks so much.

I have instructed my colleague to ask for a quotation of MS SQL Standard
to
solve our problem. There is a 25% Discount on SQL Server up to Sept this
year.

If it is still expensive. We will end up using Visual foxpro 7.0 or MS
Access 2003. In your opinion which among the two is better to use?


So sad to hear that it only functions locally.


Thanks again.

Regards,

Cypher...

Hello Cypher,

The issue of "The file *.mdf is on a network path that is not supported
for
database files" is caused by one of the SQL Express limits:

SQL Server 2005 Express Edition Overview
http://msdn.microsoft.com/en-us/library/ms345154.aspx

<quote>
SQL Server supports using multiple data and log files for a database
and
these files can be distributed in multiple file groups. This is not
supported in the AttachDBFileName syntax. *Also the network share, HTTP
paths, or Universal Naming Conventional (UNC) remote databases are not
supported.*
</quote>

Because your mdf is located in a network share and our app accesses the
mdf
through the unc path, the error is thrown for lack of the UNC remote DB
support. Having another license of an SQL Server Express edition run on
that machine will not help either. In other words, if we have to use
SQL
Server Expression edition, the DB must be local for it to work. For
your
scenario, the possible solutions are:

1. Install SQL Server of Non-Express edition (e.g. Enterprise Edition)
and
attach the mdf to the server.
(I can understand that you may not choose this solution according to
our
communications in the past.)

2. If the mdf must stay remotely, you may consider building a data
access
layer (DAL) on that remote machine (DAL stays with the mdf), and expose
the
interfaces of DAL to our application through the tech like web service.
In
this way, our app calls the DAL to do the DB operations.

For more information about DAL, please refer to the articles:
http://msdn.microsoft.com/en-us/magazine/cc188750.aspx
http://msdn.microsoft.com/en-us/library/aa581778.aspx

Regards,
Jialiang Ge ([email protected], remove 'online.')
Microsoft Online Community Support

Delighting our customers is our #1 priority. We welcome your comments
and
suggestions about how we can improve the support we provide to you.
Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent
issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each
follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach
the
most efficient resolution. The offering is not appropriate for
situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are
best
handled working with a dedicated Microsoft Support Engineer by
contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no
rights.

 

[Jialiang Ge [MSFT]]

Hello CypherDrive,

MySQL issues are managed by http://dev.mysql.com/, but I'd like to share
some findings when I search "VB.NET MySQL" online:

The codeproject article

VB.net to mySQL Database Connection
http://www.codeproject.com/KB/vb/VBnet_to_mySQL_Server.aspx

would be a good start. The prerequisites to use MySQL with VB.NET include:

1. mySQL Server 5.0
2. mySQL Dot Net Connector 5.1
3. VB.net Express edition/ VB.net Family

Please let me know if there's anything else I can do for you.

Regards,
Jialiang Ge ([email protected], remove 'online.')
Microsoft Online Community Support

=================================================
Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).

This posting is provided "AS IS" with no warranties, and confers no rights.
=================================================

 

[Cypher Drive]

Dearest Ge,

I guess First, we should try MS Access then Move to MYSQL.
MS SQL is really expensive here in the Philippines and until such time came
when it is already cheap
for small business like us, we might as well try to use MS Access first to
reduce compexity and
be able to develop rapidly.

Thanks so much for the Information.

My Salute and Regards to you and your comrades

Cyp Drv.