911 questions
**S:**MyPath\MyDB.mdb
What for a drive is S:? A local drive, SAN or NAS? Do the IIS service account have access to?
Connection string working for WinForm but not working for asp.net
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 15%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
-- --
957
Reputation points
Hi
In a net framewok WinForm app below connection string works in x86 and Any CPU active platforms.
connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Password=;User ID=Admin;Data Source=' S:\MyPath\MyDB.mdb';Mode=Share Deny None;"
However in asp.net classic same connection string in Visual Studio debug (IIS Express) comes out with errors as below;
x86: Could not load file or assembly 'xxxxxxx' or one of its dependencies. An attempt was made to load a program with an incorrect format.
Any CPU: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.
Same machines was used for both WinForm and asp.net classic.
How can I make the connection string work in asp.net classic?
Thanks
Regards
Microsoft 365 and Office Access Development
1 answer
Sort by: Most helpful
-
Olaf Helper 47,436 Reputation points2024-04-03T11:16:46.0133333+00:00 -
-- -- 957 Reputation points
2024-04-03T11:59:42.6866667+00:00 S: is a network drive on a server on same LAN.
Environemt for both WinForm and aps.net was same. Same machine accessing same db on network via S: drive.
-
-- -- 957 Reputation points
2024-04-03T12:00:26.9233333+00:00 IIS is local and should have access.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 46%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Albert Kallal 5,586 Reputation points2024-04-04T00:23:15.4+00:00 Have you forced the web site to run as x86? You can't use any cpu here, since then how the application is launched (from win32 or win64 command line will determine the bit size). So, for the web site, you need to force the web site to run as x32 bits (or x64 bits if you using ACE x64 bits). ACE (the Access data engine) is not .net code, so this means you need to ALWAYS force your .net project to match that of the x32 or x64 bit version of ACE. Don't use ANY CPU in such cases.
-
-- -- 957 Reputation points
2024-04-04T01:54:44.48+00:00 Hi Albert
In application pool I have set Enable 32-Bit Applications to True but that has not helped.
Thanks
Regards
-
Albert Kallal 5,586 Reputation points
2024-04-04T03:27:32.4133333+00:00 Setting and enabling the x32 bit applications is a step I recommend, but as noted, you can't "guess" - so in addition to enabling the x32 bit app pool, you STILL have to force the project build to match the version of Access you have - don't leave this issue up to the wind here. In other words, don't risk using ANY cpu, but force the project to x32 or x64 (to match the version of Access you using - they need to match).
-
Olaf Helper 47,436 Reputation points
2024-04-04T05:57:55.9233333+00:00 S: is a network drive on a server on same LAN.
So it's on a NAS and the share is mapped as drive S: in your profile/for your user; it's not avaliable for IIS.
Sign in to comment -