Motoma,
Yes, the database access works just fine when running the application on the same server (no access errors) and using the UCN name
( \\Server3\MSAcc essDB\DatabaseF ile.mdb )
User Profile
Collapse
-
how to connect to an Access DB from a webfarm?
Scenario:
I've a WebFarm with 2 web servers which are NLBs (network load balanced).
Web1 and Web2; they are not part of a domain.
I have a third server, Server3, which is part of a domain and on the same physical network, and it has an MSAccess database which is used on the external webfarm as well as on the internal intranet. I can connect via the intranet because the DB file is on the same box from which the intranet is being... -
Here's more info:
I'm using ASP.NET v1.1, using a standard OLEDb connection (referencing the database by path [see code below]).
From the ASP.NET v1.1 "web.config " file (I'll refer to this as ConnectStringA)
Code:<appSettings> <add key="strConnectAccess" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\Server3\MSAccess\DatabaseFile.mdb"/> </appSettings>
Leave a comment:
-
Motoma, all,
I did post "some" code, per se.
I'm using ASP.NET v1.1, using a standard OLEDb connection (referencing the database by path [see code below]).
From the ASP.NET v1.1 "web.config " file (I'll refer to this as ConnectStringA)
Code:<appSettings> <add key="strConnectAccess" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\Server3\MSAccess\DatabaseFile.mdb"/>
Leave a comment:
-
ByteSize Solutions is already "taken" (per se).
http://www.bytesizesol utions.com/Leave a comment:
-
How can I mount a shared fold at startup or automatic; no login?
We've a Windows 2003 server; 2 of them in a webfarm (network load balanced, or NLBs).
We have a 3rd server which has an Access database to which the NLBs need access to.
Is there any way to "mount" a shared folder on the 3rd server (\\Server3\MSAc cess\) as a specific lettered drive when the sever starts up (vs having to log on)?
Also, how would one set it up to ensure the folder remains mounted... -
Code:Protected Sub TestCode(ByVal sTemp as string) If sTemp.Length = 0 then 'no data in variable. End if End Sub
Leave a comment:
-
machine.config contains configuration information specific to the machine (server). changes to this file affect all .NET applications, and other programs, running on that machine.
Web.config contains configuration information specific to the .NET application (web application). changes to this file affect only the .NET application of the folder it resites in, other programs are not affected.
You don't want to remove...Leave a comment:
-
MS Access on a web farm
Is there any way to set up connecting to an MS Access file on a 3rd server (which is on a domain) from a Web Farm (which is not on the domain)?
Hardware/OS:
Windows Server 2003
Web Farm (two web servers which are network load balanced, or NLBs)
ASP.NET v1.1
Microsoft Access 2003
We're seeking to set up an NLB webfarm. One of the web-apps uses a MS Access database.
Given the NLB (2 boxes),...
No activity results to display
Show More
Leave a comment: