473,394 Members | 1,083 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

Deploying VB .NET application WITH MS Access db

Hi Everybody,

I have created a three-tiered db application in VB .NET but I can't get the deployment to work right. I have added a SetUp project to the existing application. I also selected RELEASE as appropriate in the Application Folder and on the Users Desktop and Start menu. I didn't know whether the Project Output though would be enough or whether I would need to add the .mdb file to the Application folder too. I tested the deployment both ways though and in each case, when the user installs the application, they can see my GUI...but nothing populates in the combo boxes on form_load??

I also tried copying the .mdb file to the original projects BIN folder and changing the db's File Path to just the name of the db but that also didn't work??

It seems to me that I need to figure out how to stipulate where to install the db on the clients machine? If that is the case, I can just type that file path into my data class module (I think)!!

Thanks in advance!!

John
Jan 7 '06 #1
4 4375
well i use this
Friend Shared ReadOnly Property Assemblypath() As String

Get

Return
Path.GetDirectoryName(System.Reflection.Assembly.G etExecutingAssembly.Location())

End Get

End Property

Me.Datasource = Path.Combine(Assemblypath, strDatasource)
strdatasource can be "\DATA\YOURDB.MDB"

so this results in the folowing path being built

full location path were your assembly is beeing deployed &
"\DATA\YOURDB.MDB"
hth

Michel Posseth [MCP]

"JOHN MALONEY" <jm*******@email.uophx.edu> wrote in message
news:uW*************@TK2MSFTNGP09.phx.gbl...
Hi Everybody,

I have created a three-tiered db application in VB .NET but I can't get the
deployment to work right. I have added a SetUp project to the existing
application. I also selected RELEASE as appropriate in the Application
Folder and on the Users Desktop and Start menu. I didn't know whether the
Project Output though would be enough or whether I would need to add the
..mdb file to the Application folder too. I tested the deployment both ways
though and in each case, when the user installs the application, they can
see my GUI...but nothing populates in the combo boxes on form_load??

I also tried copying the .mdb file to the original projects BIN folder and
changing the db's File Path to just the name of the db but that also didn't
work??

It seems to me that I need to figure out how to stipulate where to install
the db on the clients machine? If that is the case, I can just type that
file path into my data class module (I think)!!

Thanks in advance!!

John
Jan 7 '06 #2
Thanks very much for your HELP Michel,

Would you suggest that I post the code you mentioned in my data access class module?? I was thinking that I might be able to have the deployment include the installation of the .mdb file to the root of the C:// drive or something (but I didn't know how to configure the installation instructions). Either way, I will change the File Path in my current data access class and see if that helps? I will try your code in that class module this evening and let you know!! I guess where I'm having the difficulty is in figuring out where the deployment files go on the client and to code my data access class file path to agree with that path??

Thanks again!
--
John
"m.posseth" <mi*****@nohausystems.nl> wrote in message news:O4**************@TK2MSFTNGP12.phx.gbl...
well i use this
Friend Shared ReadOnly Property Assemblypath() As String

Get

Return
Path.GetDirectoryName(System.Reflection.Assembly.G etExecutingAssembly.Location())

End Get

End Property

Me.Datasource = Path.Combine(Assemblypath, strDatasource)
strdatasource can be "\DATA\YOURDB.MDB"

so this results in the folowing path being built

full location path were your assembly is beeing deployed &
"\DATA\YOURDB.MDB"
hth

Michel Posseth [MCP]

"JOHN MALONEY" <jm*******@email.uophx.edu> wrote in message
news:uW*************@TK2MSFTNGP09.phx.gbl...
Hi Everybody,

I have created a three-tiered db application in VB .NET but I can't get the
deployment to work right. I have added a SetUp project to the existing
application. I also selected RELEASE as appropriate in the Application
Folder and on the Users Desktop and Start menu. I didn't know whether the
Project Output though would be enough or whether I would need to add the
.mdb file to the Application folder too. I tested the deployment both ways
though and in each case, when the user installs the application, they can
see my GUI...but nothing populates in the combo boxes on form_load??

I also tried copying the .mdb file to the original projects BIN folder and
changing the db's File Path to just the name of the db but that also didn't
work??

It seems to me that I need to figure out how to stipulate where to install
the db on the clients machine? If that is the case, I can just type that
file path into my data class module (I think)!!

Thanks in advance!!

John
Jan 7 '06 #3
Hello John ,,
Would you suggest that I post the code you mentioned in my data access
class module??

yes it is alwaysbetter to use a sub directory under your assembly path as
the data directory
there are even ocasions wwre users have messed up there file system (
partitioning , changing harddisks) and do not even have a C:\ disk
with the described code you can determine the assembly path and so discover
the data dir

regards

Michel Posseth [MCP]

"JOHN MALONEY" <jm*******@email.uophx.edu> wrote in message
news:%2***************@tk2msftngp13.phx.gbl...
Thanks very much for your HELP Michel,

Would you suggest that I post the code you mentioned in my data access class
module?? I was thinking that I might be able to have the deployment include
the installation of the .mdb file to the root of the C:// drive or something
(but I didn't know how to configure the installation instructions). Either
way, I will change the File Path in my current data access class and see if
that helps? I will try your code in that class module this evening and let
you know!! I guess where I'm having the difficulty is in figuring out where
the deployment files go on the client and to code my data access class file
path to agree with that path??

Thanks again!
--
John
"m.posseth" <mi*****@nohausystems.nl> wrote in message
news:O4**************@TK2MSFTNGP12.phx.gbl...
well i use this
Friend Shared ReadOnly Property Assemblypath() As String

Get

Return
Path.GetDirectoryName(System.Reflection.Assembly.G etExecutingAssembly.Location())

End Get

End Property

Me.Datasource = Path.Combine(Assemblypath, strDatasource)
strdatasource can be "\DATA\YOURDB.MDB"

so this results in the folowing path being built

full location path were your assembly is beeing deployed &
"\DATA\YOURDB.MDB"
hth

Michel Posseth [MCP]

"JOHN MALONEY" <jm*******@email.uophx.edu> wrote in message
news:uW*************@TK2MSFTNGP09.phx.gbl...
Hi Everybody,

I have created a three-tiered db application in VB .NET but I can't get
the
deployment to work right. I have added a SetUp project to the existing
application. I also selected RELEASE as appropriate in the Application
Folder and on the Users Desktop and Start menu. I didn't know whether the
Project Output though would be enough or whether I would need to add the
.mdb file to the Application folder too. I tested the deployment both ways
though and in each case, when the user installs the application, they can
see my GUI...but nothing populates in the combo boxes on form_load??

I also tried copying the .mdb file to the original projects BIN folder and
changing the db's File Path to just the name of the db but that also
didn't
work??

It seems to me that I need to figure out how to stipulate where to install
the db on the clients machine? If that is the case, I can just type that
file path into my data class module (I think)!!

Thanks in advance!!

John

Jan 8 '06 #4
Thanks again Michel,

I was able to get my project deployed just by setting up the correct file path! I can see though that your code would be better because it allows the configuration to occur wherever the user wants and the db is still added on correctly!

--
John Maloney
UOP Online Faculty
jm*******@email.uophx.edu
on********@bellsouth.net (alternate)
(954) 441-5091
"m.posseth" <mi*****@nohausystems.nl> wrote in message news:ul**************@TK2MSFTNGP11.phx.gbl...
Hello John ,,
Would you suggest that I post the code you mentioned in my data access
class module??

yes it is alwaysbetter to use a sub directory under your assembly path as
the data directory
there are even ocasions wwre users have messed up there file system (
partitioning , changing harddisks) and do not even have a C:\ disk
with the described code you can determine the assembly path and so discover
the data dir

regards

Michel Posseth [MCP]

"JOHN MALONEY" <jm*******@email.uophx.edu> wrote in message
news:%2***************@tk2msftngp13.phx.gbl...
Thanks very much for your HELP Michel,

Would you suggest that I post the code you mentioned in my data access class
module?? I was thinking that I might be able to have the deployment include
the installation of the .mdb file to the root of the C:// drive or something
(but I didn't know how to configure the installation instructions). Either
way, I will change the File Path in my current data access class and see if
that helps? I will try your code in that class module this evening and let
you know!! I guess where I'm having the difficulty is in figuring out where
the deployment files go on the client and to code my data access class file
path to agree with that path??

Thanks again!
--
John
"m.posseth" <mi*****@nohausystems.nl> wrote in message
news:O4**************@TK2MSFTNGP12.phx.gbl...
well i use this
Friend Shared ReadOnly Property Assemblypath() As String

Get

Return
Path.GetDirectoryName(System.Reflection.Assembly.G etExecutingAssembly.Location())

End Get

End Property

Me.Datasource = Path.Combine(Assemblypath, strDatasource)
strdatasource can be "\DATA\YOURDB.MDB"

so this results in the folowing path being built

full location path were your assembly is beeing deployed &
"\DATA\YOURDB.MDB"
hth

Michel Posseth [MCP]

"JOHN MALONEY" <jm*******@email.uophx.edu> wrote in message
news:uW*************@TK2MSFTNGP09.phx.gbl...
Hi Everybody,

I have created a three-tiered db application in VB .NET but I can't get
the
deployment to work right. I have added a SetUp project to the existing
application. I also selected RELEASE as appropriate in the Application
Folder and on the Users Desktop and Start menu. I didn't know whether the
Project Output though would be enough or whether I would need to add the
.mdb file to the Application folder too. I tested the deployment both ways
though and in each case, when the user installs the application, they can
see my GUI...but nothing populates in the combo boxes on form_load??

I also tried copying the .mdb file to the original projects BIN folder and
changing the db's File Path to just the name of the db but that also
didn't
work??

It seems to me that I need to figure out how to stipulate where to install
the db on the clients machine? If that is the case, I can just type that
file path into my data class module (I think)!!

Thanks in advance!!

John

Jan 8 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Sean Campbell | last post by:
Hi, My group have a ASP.NET based application ( currently running on 1.0.3705 ). Ideally, we would like to deploy new components(asp files/assemblies/db updates) into a live environment without...
1
by: Mister_d | last post by:
When deploying a solution using the Access 2003 runtime engine, do you have to use the packaging wizard that comes with the Access 2003 Developer Extentions, or can you use other packaging software...
10
by: Gerben van Loon | last post by:
Hi there, hope someone can help me on this: I'm planning to deploy several ASP.NET projects to a production server. Normally I used the "Project / Copy project" option in VS.NET, but to this...
3
by: Johnny | last post by:
Hi, I have created an ASP.NET application (let's call it FooBar) with VS.NET on my local machine, residing in http://localhost/FooBar. Deploying it to another folder on my machine works well...
3
by: Rachel | last post by:
Hi, I am using the data access application block successfully in our development environment, however when I deploy to our testing server as Private Assemblies I keep getting the following ...
3
by: Rachel | last post by:
Hi, I am using the data access application block successfully in our development environment, however when I deploy to our testing server as Private Assemblies I keep getting the following ...
0
by: Dave | last post by:
Hello The application I'm building an installer for uses dlls which were developed originally in C. Since the application itself is developed in C#, these dlls were wrapped using SWIG....
3
by: pooba53 | last post by:
I have a VB .NET 2003 application that communicates with an Access db. I am deploying the application using the Wizard that creates an install package and it IS properly grabbing the Access db and...
0
by: jimmarq | last post by:
I need reporting functionality in my app, but for several reasons, I don't want to have to package any DLL files in a setup. I want to deploy my application straight to a shared network drive with...
3
by: =?Utf-8?B?eWtmZmM=?= | last post by:
I try deploying a very simple (very simple indeed) Vb.net application by following the basic steps according to some tutorials. My pc runs Visual Studio 2005 and it reports "Build successful"...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.