I am trying to create a web application using VB.NET. I will be deploying
multiple instances of this application on the same server, each with it's own
Access database. Unfortunately, every example I've seen shows how to access
data using ODBC at design time. This won't work for me. I would have to have
a different code base for each instance. What I need is a way for the entire
application to know what ODBC source it is supposed to use, and I need to be
able to assign this at runtime. This must be fairly common, right? Can
someone help me figure out where to look for a solution here?
9  1400 
Are you using ASP.Net 2.0 or 1.1?
--
David Wier
MVP/ASPInsider http://aspnet101.com http://aspexpress.com
"Geoffrey Callaghan" <Ge************ ***@discussions .microsoft.comw rote in
message news:BB******** *************** ***********@mic rosoft.com...
I am trying to create a web application using VB.NET. I will be deploying
multiple instances of this application on the same server, each with it's
own
Access database. Unfortunately, every example I've seen shows how to
access
data using ODBC at design time. This won't work for me. I would have to
have
a different code base for each instance. What I need is a way for the
entire
application to know what ODBC source it is supposed to use, and I need to
be
able to assign this at runtime. This must be fairly common, right? Can
someone help me figure out where to look for a solution here?
I'm using Visual Studio .NET 2003...is there an easy way to tell what version
of ASP that implies?
"David Wier" wrote:
Are you using ASP.Net 2.0 or 1.1?
--
David Wier
MVP/ASPInsider
http://aspnet101.com
http://aspexpress.com
"Geoffrey Callaghan" <Ge************ ***@discussions .microsoft.comw rote in
message news:BB******** *************** ***********@mic rosoft.com...
I am trying to create a web application using VB.NET. I will be deploying
multiple instances of this application on the same server, each with it's
own
Access database. Unfortunately, every example I've seen shows how to
access
data using ODBC at design time. This won't work for me. I would have to
have
a different code base for each instance. What I need is a way for the
entire
application to know what ODBC source it is supposed to use, and I need to
be
able to assign this at runtime. This must be fairly common, right? Can
someone help me figure out where to look for a solution here?
You are using 1.1.
I would ignore any sample that uses the design time environment to create
database connections. etc. There should be plenty of samples that show you
how to do this in code yourself.
A common place to put connection information is in Web.config of the web
application. Each deployment would have a different value there with regards
to which database to connect to.
"Geoffrey Callaghan" <Ge************ ***@discussions .microsoft.comw rote in
message news:F0******** *************** ***********@mic rosoft.com...
I'm using Visual Studio .NET 2003...is there an easy way to tell what
version
of ASP that implies?
"David Wier" wrote:
>Are you using ASP.Net 2.0 or 1.1?
--
David Wier
MVP/ASPInsider
http://aspnet101.com
http://aspexpress.com
"Geoffrey Callaghan" <Ge************ ***@discussions .microsoft.comw rote
in
message news:BB******** *************** ***********@mic rosoft.com...
I am trying to create a web application using VB.NET. I will be
deploying
multiple instances of this application on the same server, each with
it's
own
Access database. Unfortunately, every example I've seen shows how to
access
data using ODBC at design time. This won't work for me. I would have to
have
a different code base for each instance. What I need is a way for the
entire
application to know what ODBC source it is supposed to use, and I need
to
be
able to assign this at runtime. This must be fairly common, right? Can
someone help me figure out where to look for a solution here?
It's .NET 1.1, if that means the same thing.
"David Wier" wrote:
Are you using ASP.Net 2.0 or 1.1?
--
David Wier
MVP/ASPInsider
http://aspnet101.com
http://aspexpress.com
"Geoffrey Callaghan" <Ge************ ***@discussions .microsoft.comw rote in
message news:BB******** *************** ***********@mic rosoft.com...
I am trying to create a web application using VB.NET. I will be deploying
multiple instances of this application on the same server, each with it's
own
Access database. Unfortunately, every example I've seen shows how to
access
data using ODBC at design time. This won't work for me. I would have to
have
a different code base for each instance. What I need is a way for the
entire
application to know what ODBC source it is supposed to use, and I need to
be
able to assign this at runtime. This must be fairly common, right? Can
someone help me figure out where to look for a solution here?
So you're saying I have to do all of my data connections in code, as opposed
to using any of the wizards or designers? I was trying to avoid that. MS
seems to have put a lot of trouble into building those tools...are they
really that limited? This is a fairly simple application, and I'm not doing
anything special here. Development time is a major concern.
"Marina Levit [MVP]" wrote:
You are using 1.1.
I would ignore any sample that uses the design time environment to create
database connections. etc. There should be plenty of samples that show you
how to do this in code yourself.
A common place to put connection information is in Web.config of the web
application. Each deployment would have a different value there with regards
to which database to connect to.
"Geoffrey Callaghan" <Ge************ ***@discussions .microsoft.comw rote in
message news:F0******** *************** ***********@mic rosoft.com...
I'm using Visual Studio .NET 2003...is there an easy way to tell what
version
of ASP that implies?
"David Wier" wrote:
Are you using ASP.Net 2.0 or 1.1?
--
David Wier
MVP/ASPInsider
http://aspnet101.com
http://aspexpress.com
"Geoffrey Callaghan" <Ge************ ***@discussions .microsoft.comw rote
in
message news:BB******** *************** ***********@mic rosoft.com...
I am trying to create a web application using VB.NET. I will be
deploying
multiple instances of this application on the same server, each with
it's
own
Access database. Unfortunately, every example I've seen shows how to
access
data using ODBC at design time. This won't work for me. I would have to
have
a different code base for each instance. What I need is a way for the
entire
application to know what ODBC source it is supposed to use, and I need
to
be
able to assign this at runtime. This must be fairly common, right? Can
someone help me figure out where to look for a solution here?
If you're putting multiple instances of the application on the same
server, will they have different project names? Different folders? If
so, and you're going to have multiple databases, just put them in the
same folder relative to the web applicaiton. Then your connection
string could be relative (and the same).
I guess I could do that, though I was hoping to use ODBC data sources instead
of hardcoding the database name. Thanks, good idea. Although, when I run the
program, the "current directory" seems to be my windows directory, so the
file isn't found.
"JT" wrote:
>
If you're putting multiple instances of the application on the same
server, will they have different project names? Different folders? If
so, and you're going to have multiple databases, just put them in the
same folder relative to the web applicaiton. Then your connection
string could be relative (and the same).
this sounds like the way to go. I can't find any examples of this, either how
to put the connection into the web.config, or how to access it from my pages
later. Can you point me to an example?
"Marina Levit [MVP]" wrote:
You are using 1.1.
I would ignore any sample that uses the design time environment to create
database connections. etc. There should be plenty of samples that show you
how to do this in code yourself.
A common place to put connection information is in Web.config of the web
application. Each deployment would have a different value there with regards
to which database to connect to.
"Geoffrey Callaghan" <Ge************ ***@discussions .microsoft.comw rote in
message news:F0******** *************** ***********@mic rosoft.com...
I'm using Visual Studio .NET 2003...is there an easy way to tell what
version
of ASP that implies?
"David Wier" wrote:
Are you using ASP.Net 2.0 or 1.1?
--
David Wier
MVP/ASPInsider
http://aspnet101.com
http://aspexpress.com
"Geoffrey Callaghan" <Ge************ ***@discussions .microsoft.comw rote
in
message news:BB******** *************** ***********@mic rosoft.com...
I am trying to create a web application using VB.NET. I will be
deploying
multiple instances of this application on the same server, each with
it's
own
Access database. Unfortunately, every example I've seen shows how to
access
data using ODBC at design time. This won't work for me. I would have to
have
a different code base for each instance. What I need is a way for the
entire
application to know what ODBC source it is supposed to use, and I need
to
be
able to assign this at runtime. This must be fairly common, right? Can
someone help me figure out where to look for a solution here?
Hey Geoffrey,
I'm not real happy about the way this site notifies you (or doesn't
notify you) of activity. I just now realized you posted again. If you
haven't gotten it working, tell me where you're hung up and I'll try to
help. I haven't tried using a relative path in the web.config file, so
I don't know if that would work, but if you make your connection in
code, you can use the MapPath() method to get the full path from your
relative specification.
Geoffrey Callaghan wrote:
this sounds like the way to go. I can't find any examples of this, either how
to put the connection into the web.config, or how to access it from my pages
later. Can you point me to an example?
"Marina Levit [MVP]" wrote:
You are using 1.1.
I would ignore any sample that uses the design time environment to create
database connections. etc. There should be plenty of samples that show you
how to do this in code yourself.
A common place to put connection information is in Web.config of the web
application. Each deployment would have a different value there with regards
to which database to connect to.
"Geoffrey Callaghan" <Ge************ ***@discussions .microsoft.comw rote in
message news:F0******** *************** ***********@mic rosoft.com...
I'm using Visual Studio .NET 2003...is there an easy way to tell what
version
of ASP that implies?
>
"David Wier" wrote:
>
>Are you using ASP.Net 2.0 or 1.1?
>>
>--
>David Wier
>MVP/ASPInsider
>http://aspnet101.com
>http://aspexpress.com
>>
>>
>"Geoffrey Callaghan" <Ge************ ***@discussions .microsoft.comw rote
>in
>message news:BB******** *************** ***********@mic rosoft.com...
I am trying to create a web application using VB.NET. I will be
deploying
multiple instances of this application on the same server, each with
it's
>own
Access database. Unfortunately, every example I've seen shows how to
>access
data using ODBC at design time. This won't work for me. I would have to
>have
a different code base for each instance. What I need is a way for the
>entire
application to know what ODBC source it is supposed to use, and I need
to
>be
able to assign this at runtime. This must be fairly common, right? Can
someone help me figure out where to look for a solution here?
>>
>>
>>
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Catalin |
last post by:
Can Python replace PHP?
Can I use a python program to make an interface to a mysql 4.X database?
If that's possible where can I find a tutorial?
|
by: Gernot Hillier |
last post by:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi!
I'm the developer of a Linux ISDN application which uses embedded Python for
controlling the communication. It starts several threads (i.e. one for each
incoming call and for outgoing faxes) which run Python scripts in embedded
Python interpreters which in turn do the real communication stuff. Any
incoming data or confirmations of done jobs are sent via Email.
|
by: 3f |
last post by:
Hello;
We have made a web application that people can download from our web site
and installed on:
Windows XP
Windows 2000 Professional
Windows 2003 Server
Windows 2000 Server
|
by: Keith |
last post by:
All,
I have been told this is an ASP.NET issue and not an IIS
issue, so I am posting this here.
I have a problem with ASP.NET returning an HTTP 500 error
when trying to run ASPX pages on Windows Server 2003
Enterprise Edition Only.
This works on Windows 2000, Windows 2003 Web Edition and
|
by: William LaMartin |
last post by:
I have a problem, mentioned here before, of Session and Application
variables disappearing at one site but not at others or on my development
computer.
The problem is illustrated by an example at
http://www.lamartin.com/dotnet/sessiontestset.aspx, were I set Session,
Application and Cache variables on the first page and then on the second
page view them as the second page is refreshed every five seconds. Before
10 refreshes, the...
| | |
by: SL |
last post by:
All,
As I understand it, a single application (i.e. IIS virtual directory)
in ASP.NET may in fact have more than one corresponding
HttpApplicationState object (more or less one per server thread, I
think). During each request, only one of these objects is exposed to
the page as Page.Application. This seems to be supported by the fact
that when I use the debugger, I can see the Application_Start event
firing more than one time even...
|
by: Steve Richfie1d |
last post by:
Now that it finally works, I'm in the process of converting my large
rapid-prototyped Access app into production VB, one DDE-linked piece at
a time. One piece now already in VB takes ~2 seconds to run all by
itself, but when I start running other gigantic resource hogs like
Dragon NaturallySpeaking and SAPI at the same time, its execution time
goes WAY up - past the 5 seconds needed to time out a DDE link, so I get
an Error 286 DDE...
|
by: roadrunner |
last post by:
Hi,
Our website has recently been experiencing some problems under load. We have
pinpointed a particular function which slows dramatically when we have these
problems. Normally it should execute in under a second but it rises to about
one minute under duress.
The code is fairly straight forward with no calls to databases or any other
servers. The only dubious thing I can see is that it retrieves several arrays
from the Application...
|
by: Benny Ng |
last post by:
Dear All,
Now I met some performance problems in my application. Because according
to our business. The size of some web forms are larger than 1xxx MB. So it
takes a long time for user opening a web page. Surely we are modifying some
source code for performance improvment.
But now i'm thinking should we improve the application performance by
IIS Compression? I saw many mentions from Google/Yahoo. Some people said it
can be useful for...
|
by: =?Utf-8?B?SkhhbGV5?= |
last post by:
Our system is:
IIS Server: dual Intel Xeon 2.80 GHz, 4 GB Ram
Windows Server 2003 SP2
IIS 6.0
SQL Server: dual Intel Xeon 2.80 GHz, 4 GB Ram (separate server)
Windows Server 2003 SP2
SQL Server 2000
We are having some problems with a website we are developing, and had some
|
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: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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: 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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
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...
| |
