Hi,
My winform vb.net app need to be packaged to distribute
for other people. This app has a back-end MS Access
database, and VB.net program files. In one of its
winforms, there's an OLEDBConnection connect to the
Access database. My question is how can I keep database
connection viable when deploying app?
Please help with suggestions.
9  11362 
Put it in the app.config file or something. Don't use DSNs. I assume the MDB
is on the network somewhere?
I don't quite understand what you mean by "viable".
--
Klaus H. Probst, MVP http://www.vbbox.com/
"Tracey" <an*******@disc ussions.microso ft.com> wrote in message
news:23******** *************** ******@phx.gbl. .. Hi,
My winform vb.net app need to be packaged to distribute
for other people. This app has a back-end MS Access
database, and VB.net program files. In one of its
winforms, there's an OLEDBConnection connect to the
Access database. My question is how can I keep database
connection viable when deploying app?
Please help with suggestions.
I never tried deploy apps before. The thing is how can I
keep the app and database connection working without any
loss ? -----Original Message-----
Put it in the app.config file or something. Don't use
DSNs. I assume the MDBis on the network somewhere?
I don't quite understand what you mean by "viable".
--
Klaus H. Probst, MVP
http://www.vbbox.com/
"Tracey" <an*******@disc ussions.microso ft.com> wrote in
messagenews:23******* *************** *******@phx.gbl ... Hi,
My winform vb.net app need to be packaged to distribute
for other people. This app has a back-end MS Access
database, and VB.net program files. In one of its
winforms, there's an OLEDBConnection connect to the
Access database. My question is how can I keep database
connection viable when deploying app?
Please help with suggestions.
.
Where is the database file? On a network share?
If that's the case then you'll have "loss" if the network flakes out on you.
If you put the connection string in the app.config file and make it point to
the database on the network you should be OK if the code works when the MDB
is opened locally.
--
Klaus H. Probst, MVP http://www.vbbox.com/
"Tracey" <an*******@disc ussions.microso ft.com> wrote in message
news:23******** *************** ******@phx.gbl. .. I never tried deploy apps before. The thing is how can I
keep the app and database connection working without any
loss ?
-----Original Message-----
Put it in the app.config file or something. Don't use
DSNs. I assume the MDBis on the network somewhere?
I don't quite understand what you mean by "viable".
--
Klaus H. Probst, MVP
http://www.vbbox.com/
"Tracey" <an*******@disc ussions.microso ft.com> wrote in
messagenews:23******* *************** *******@phx.gbl ... Hi,
My winform vb.net app need to be packaged to distribute
for other people. This app has a back-end MS Access
database, and VB.net program files. In one of its
winforms, there's an OLEDBConnection connect to the
Access database. My question is how can I keep database
connection viable when deploying app?
Please help with suggestions.
.
The database file is in local host not network.
Can you offer me more details ?
Thanks -----Original Message-----
Where is the database file? On a network share?
If that's the case then you'll have "loss" if the
network flakes out on you.
If you put the connection string in the app.config file
and make it point tothe database on the network you should be OK if the code
works when the MDBis opened locally.
--
Klaus H. Probst, MVP
http://www.vbbox.com/
"Tracey" <an*******@disc ussions.microso ft.com> wrote in
messagenews:23******* *************** *******@phx.gbl ... I never tried deploy apps before. The thing is how can
I keep the app and database connection working without
any loss ?
>-----Original Message-----
>Put it in the app.config file or something. Don't use
DSNs. I assume the MDB >is on the network somewhere?
>
>I don't quite understand what you mean by "viable".
>
>
>--
>Klaus H. Probst, MVP
> http://www.vbbox.com/
>
>
>"Tracey" <an*******@disc ussions.microso ft.com> wrote
in message >news:23******* *************** *******@phx.gbl ...
>> Hi,
>>
>> My winform vb.net app need to be packaged to
distribute >> for other people. This app has a back-end MS Access
>> database, and VB.net program files. In one of its
>> winforms, there's an OLEDBConnection connect to the
>> Access database. My question is how can I keep
database >> connection viable when deploying app?
>>
>> Please help with suggestions.
>>
>
>
>.
>
.
<an*******@disc ussions.microso ft.com> wrote in message
news:23******** *************** ******@phx.gbl. .. The database file is in local host not network.
Can you offer me more details ?
Yes, if you tell me what you think the problem is. How are you connecting to
the database right now? Are you using a DSN or a simple connection string?
What do you mean by "loss"?
If the target computer has all the prerequisites (in your case I suppose
that's .NET and ADO/DAO) then simply copying the EXE and other files the app
requires should be enough.
But it's difficult to know since you haven't *really* asked a question =)
--
Klaus H. Probst, MVP http://www.vbbox.com/
Sorry Klaus, English is not my native language.
I'm connecting database with DNS and in my program, the
code-behind file contains the connection string. -----Original Message-----
<an*******@dis cussions.micros oft.com> wrote in message
news:23******* *************** *******@phx.gbl ... The database file is in local host not network.
Can you offer me more details ?
Yes, if you tell me what you think the problem is. How
are you connecting tothe database right now? Are you using a DSN or a simple
connection string?What do you mean by "loss"?
If the target computer has all the prerequisites (in
your case I supposethat's .NET and ADO/DAO) then simply copying the EXE and
other files the apprequires should be enough.
But it's difficult to know since you haven't *really*
asked a question =)
--
Klaus H. Probst, MVP
http://www.vbbox.com/
.
No problem. I just want to understand what you're trying to do so I can
actually help you =)
OK, so you say "code behind", does that mean this is an ASP.NET application
written in VB.NET?
Web applications don't need to be "deployed" unless you want to install and
run them in a different server than, say, your workstation. Is that your
case? Do you want to move it to another machine to run it from there?
--
Klaus H. Probst, MVP http://www.vbbox.com/
"Tracey" <an*******@disc ussions.microso ft.com> wrote in message
news:24******** *************** ******@phx.gbl. .. Sorry Klaus, English is not my native language.
I'm connecting database with DNS and in my program, the
code-behind file contains the connection string.
it's not code-behind, its winform application.
I connect with Access with ADO.net -----Original Message-----
No problem. I just want to understand what you're trying
to do so I canactually help you =)
OK, so you say "code behind", does that mean this is an
ASP.NET applicationwritten in VB.NET?
Web applications don't need to be "deployed" unless you
want to install andrun them in a different server than, say, your
workstation. Is that yourcase? Do you want to move it to another machine to run
it from there?
--
Klaus H. Probst, MVP
http://www.vbbox.com/
"Tracey" <an*******@disc ussions.microso ft.com> wrote in
messagenews:24******* *************** *******@phx.gbl ... Sorry Klaus, English is not my native language.
I'm connecting database with DNS and in my program, the
code-behind file contains the connection string.
.
It sounds like you have developed a VB .NET application that connects to an
Access database via ADO .NET. You want to distribute the application with
your database and have the link between the application and database work on
the various machines you are installing it onto.
If this is correct I recommend having the access database being located
where the executable will reside. Then setup your application to connect to
the database via a connection string which points to the database file in
Application.Exe cutablePath. When you create your installer just place the
executable and database in the same directory, no messing around with DSN
entries.
"Tracey" <an*******@disc ussions.microso ft.com> wrote in message
news:24******** *************** ******@phx.gbl. .. it's not code-behind, its winform application.
I connect with Access with ADO.net
-----Original Message-----
No problem. I just want to understand what you're trying
to do so I canactually help you =)
OK, so you say "code behind", does that mean this is an
ASP.NET applicationwritten in VB.NET?
Web applications don't need to be "deployed" unless you
want to install andrun them in a different server than, say, your
workstation. Is that yourcase? Do you want to move it to another machine to run
it from there?
--
Klaus H. Probst, MVP
http://www.vbbox.com/
"Tracey" <an*******@disc ussions.microso ft.com> wrote in
messagenews:24******* *************** *******@phx.gbl ... Sorry Klaus, English is not my native language.
I'm connecting database with DNS and in my program, the
code-behind file contains the connection string.
. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Wilson Ricardo Passos Oliveira |
last post by:
Hi fellows,
I have two simple questions regarding the Framework's deploy and the Setup
and Deploy Projects:
1. As I've read in another posts and newsgroups (and as I can imagine),
VS.NET IDE isn't capable of create a setup and deploy project and, in a
elegant way, during the setup process, detect the absence of the Framework.
In this case, I'd like to run the Dotnetredist.exe file, first, and the
|
by: James X. Li |
last post by:
We are using an ISP to host our web site. All we get
from our ISP is a root directory for our web site.
We can deploy a single ASP.NET application by copying all the
related files (global.asax, web.config, etc.) to the root directory.
Things work fine in this way. But, we would like to deploy a second
application ( for administration purpose) on this web site. How
can we do it? In general, How can we deploy multiple ASP.NET
applications...
|
by: Robert Warnestam |
last post by:
Hello,
I have some problems deploying Crystal Reports.
I'm using Visual Studio 2005 Beta 1. In this version Crystal Reports
(9.7.3500.0) is included. I created a small test application (ASP.NET) that
shows a simple report. It work fine with on my local computer. Now I'm
trying to deploy this sample application on our web server but I really need
some help.
|
by: Nils Hedström |
last post by:
I have a ASP.NET 1.1 project that I want to be able to deploy on my web-servers
while they have real traffic (40 requests/second).
When I copy the projects assembly in the bin-directory of the website directory
the application gets restarted and the web server needs to recompile all
my aspx-pages. Because the traffic is high the web server needs to recompile
a lot of aspx-pages at the same time.
Because of this alot of requests gets...
|
by: bob lambert |
last post by:
Help
I am trying to deploy to another pc a vb.net std 2002
windows form application. I am confused.
I created a project - windows form
I built form, compiled and debugged.
I created a deployment project (myproj installer)
I added my windows app to the installer
under myproj installer properties, I set bootstrapper
| | |
by: alan |
last post by:
I've try to deploy my application by using Setup Wizard. But after I
build the setup application, it got a error said "unrecoverable
error!". I don't know what's the problem. In order to the what problem
is it, I open a new project and just use one form, use one text box
and one button and try to deploy by setup wizard. Finally it also said
"unrecoverable error!".
What's wrong with it? It's just a simple application, why it got this...
|
by: meo |
last post by:
Does .NET provide the way to deploy library to internal developer?
I am trying to find the way to deploy a library file to developer for having
integration to their application BUT the customer who is using that
application will not use that library file.
If I choose to deploy like a DLL file, the DLL file will deploy to the
customer. I thought this is the easy way if customer copy DLL file to
include to the project and use it.
|
by: AGP |
last post by:
I resisted for many years but I've just written my first app in .NET2005
and am looking to deploy my app with a third-party installer. ClickOnce
and the VS Installer do not meed my needs and I am already well versed
in another installer.
My question is mainly dealing with deploying the app dependecies. I think
I know where im headed but could use the advice of others who have had
more experience. Should i just take all the files in the...
|
by: =?Utf-8?B?QW5kcmV3X2QxMjM=?= |
last post by:
Here is my problem. I have an app that has over 9 web services. For years I
had not issues with clickonce but now it looks like the build is missing
XmlSerializers.dll.deploy. I did have this issue once in vs 2005 and one the
problem just went away. Well now its back. If I build the app 20 times it
may work once. I did find that if I remove this as a required dll that I can
get my program to run. I can't seem to find any info about...
|
by: stephen |
last post by:
Hi,
I am using Click Once Deploy to deploy an application.(this application has
an .exe, .config, .xml files) and after deployment to a location, I checked
for the files and all the files are stored as (.exe.deploy, .config.deploy
and .xml.deploy).
Upon testing, I found that one data entry in the xml file was incorrect and
i want to correct. Can i change it in the xml.deploy file itself or do I
have to use the editor, recompile and then...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
