473,783 Members | 2,350 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

arghhh 64 bit Access oledb struggle

To all ,,,

with VS.Net 2005 you can not access a Access database when this runs on a
64 bit system ( when compiled in CPU type anny or X64 )

i feel that MS should include a 64 bit Oledb driver , maybe if a lot of us
complain about this missing driver we encourage them to create one

http://lab.msdn.microsoft.com/productfeedback/
No i can not switch to SQL Express and yes i know i can avoid this problem
by compiling to x86 mode and so forcing the framework into WOW modus
however i would like it if i could deploy my app in anny cpu type modus (
for the rest it runs perfect on 64 bit systems )

Also tried to put the Access stuff in a seperate assembly but it is not
getting fooled by this, the program will then not even start , so the only
scenario i can think of is creating a remoting component (thus a app that
handles the db traffic and marshall the data to the 64 bit app ) but this
will give so much overhead that i could better run my complete proggy 32 bit
Really wish there was a good alternative for Access but there isn`t ,,,,,,
( if you want to deploy your data secured , with a small footprint , that
also runs on win 9.x )
regards

Michel Posseth [MCP]
Dec 4 '05 #1
3 1323
Hi,

I agree with you. There should either be 64 bit odbc drivers or
the classes should automatically use the 32 bit ones. I submitted this
suggestion a while ago.

http://lab.msdn.microsoft.com/produc...0-d25b58ce8ae8

Ken Tucker
--------------------

"m.posseth" wrote:
To all ,,,

with VS.Net 2005 you can not access a Access database when this runs on a
64 bit system ( when compiled in CPU type anny or X64 )

i feel that MS should include a 64 bit Oledb driver , maybe if a lot of us
complain about this missing driver we encourage them to create one

http://lab.msdn.microsoft.com/productfeedback/
No i can not switch to SQL Express and yes i know i can avoid this problem
by compiling to x86 mode and so forcing the framework into WOW modus
however i would like it if i could deploy my app in anny cpu type modus (
for the rest it runs perfect on 64 bit systems )

Also tried to put the Access stuff in a seperate assembly but it is not
getting fooled by this, the program will then not even start , so the only
scenario i can think of is creating a remoting component (thus a app that
handles the db traffic and marshall the data to the 64 bit app ) but this
will give so much overhead that i could better run my complete proggy 32 bit
Really wish there was a good alternative for Access but there isn`t ,,,,,,
( if you want to deploy your data secured , with a small footprint , that
also runs on win 9.x )
regards

Michel Posseth [MCP]

Dec 4 '05 #2

Well i feel that more people should raise there voice and make MS clear that
this is a verry important issue for a good and quick migration path to
programs that can be compiled with the anny CPU option on ( wich is my
goal ) however as long as other developers do not see the need of the 64 bit
platform i guess we are allone in the dessert ... :-(

i hope we wake same of them up in time before it is to late .......
regards

Michel Posseth


"Ken Tucker [MVP]" <Ke**********@d iscussions.micr osoft.com> wrote in message
news:4D******** *************** ***********@mic rosoft.com...
Hi,

I agree with you. There should either be 64 bit odbc drivers or
the classes should automatically use the 32 bit ones. I submitted this
suggestion a while ago.

http://lab.msdn.microsoft.com/produc...0-d25b58ce8ae8

Ken Tucker
--------------------

"m.posseth" wrote:
To all ,,,

with VS.Net 2005 you can not access a Access database when this runs on
a
64 bit system ( when compiled in CPU type anny or X64 )

i feel that MS should include a 64 bit Oledb driver , maybe if a lot of
us
complain about this missing driver we encourage them to create one

http://lab.msdn.microsoft.com/productfeedback/
No i can not switch to SQL Express and yes i know i can avoid this
problem
by compiling to x86 mode and so forcing the framework into WOW modus
however i would like it if i could deploy my app in anny cpu type modus
(
for the rest it runs perfect on 64 bit systems )

Also tried to put the Access stuff in a seperate assembly but it is not
getting fooled by this, the program will then not even start , so the
only
scenario i can think of is creating a remoting component (thus a app that
handles the db traffic and marshall the data to the 64 bit app ) but this
will give so much overhead that i could better run my complete proggy 32
bit
Really wish there was a good alternative for Access but there isn`t
,,,,,,
( if you want to deploy your data secured , with a small footprint ,
that
also runs on win 9.x )
regards

Michel Posseth [MCP]

Dec 5 '05 #3
after some thinking ,, and as i feel that this is a verry important issume
for me and future people who want to write 64 bit compatible programs , i
decided to sent Steve B an e-mail regarding this , i wonder what the
reponse will be :-)

Met him once at a conference where he said that we ( developers ) could
always send him an e-mail , well i believe he is a man of his words

regards

Michel Posseth

"Ken Tucker [MVP]" <Ke**********@d iscussions.micr osoft.com> wrote in message
news:4D******** *************** ***********@mic rosoft.com...
Hi,

I agree with you. There should either be 64 bit odbc drivers or
the classes should automatically use the 32 bit ones. I submitted this
suggestion a while ago.

http://lab.msdn.microsoft.com/produc...0-d25b58ce8ae8

Ken Tucker
--------------------

"m.posseth" wrote:
To all ,,,

with VS.Net 2005 you can not access a Access database when this runs on
a
64 bit system ( when compiled in CPU type anny or X64 )

i feel that MS should include a 64 bit Oledb driver , maybe if a lot of
us
complain about this missing driver we encourage them to create one

http://lab.msdn.microsoft.com/productfeedback/
No i can not switch to SQL Express and yes i know i can avoid this
problem
by compiling to x86 mode and so forcing the framework into WOW modus
however i would like it if i could deploy my app in anny cpu type modus
(
for the rest it runs perfect on 64 bit systems )

Also tried to put the Access stuff in a seperate assembly but it is not
getting fooled by this, the program will then not even start , so the
only
scenario i can think of is creating a remoting component (thus a app that
handles the db traffic and marshall the data to the 64 bit app ) but this
will give so much overhead that i could better run my complete proggy 32
bit
Really wish there was a good alternative for Access but there isn`t
,,,,,,
( if you want to deploy your data secured , with a small footprint ,
that
also runs on win 9.x )
regards

Michel Posseth [MCP]

Dec 5 '05 #4

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

Similar topics

11
3765
by: Wolfgang Kaml | last post by:
Hello All, I have been working on this for almost a week now and I haven't anything up my sleeves anymore that I could test in addition or change.... Since I am not sure, if this is a Windows 2003 Server or ADO or ODBC issue, I am posting this on all of the three newsgroups. That's the setup: Windows 2003 Server with IIS and ASP.NET actiavted Access 2002 mdb file (and yes, proper rights are set on TMP paths and path,
1
6960
by: David | last post by:
Hi everyone. I have read every page that Google returns on this topic, but can't find anything that resolves my problem. Basically, I have an Access Database that does a number of different calculations. One of these calculations is rather complex, and could not be implemented properly using just nested IIF statements or anything similar, so was coded using VBA (in the VBE) as a function. This calculation is included in a query in the...
0
3731
by: TheCoder | last post by:
I am making a D-base with web conectivity for my class project. I have everything working but the subit button sends the data to the correct fields but afterwards it wants to reproduce new blank text boxes how do I stop this and how would I code it to redirect to a thank you page. All with out the help of a web server this has to br ran from the desktop and with in IE with a local directory. Pleas help I am stuck. here is the code! ...
1
2927
by: Abareblue | last post by:
I have no clue on how to insert a record into access. here is the whole thing using System; using System.Drawing; using System.Collections; using System.ComponentModel;
11
2055
by: CM Manager via DotNetMonster.com | last post by:
I am very frustrated due to this exception error I am receiving. I've tried searching numerous user support groups, Microsoft Support Net, Google, etc. and haven't found exactly my situation. Hopefully someone here can help. I am just learning VB.NET and purchased the SAM's "Teach Yourself VB.NET 2003 in 21 days' book. I am trying to connect to an Access database I created locally on my computer per Chapter 16. I originally had it on a...
22
3432
by: Bob and Sharon Hiller | last post by:
I have an ASP page that was done in VBScript It is setup to read an Access database and I need to change it to read a Sql 2005 Database. The code that is used to open the Access Database: Set adoConnection = server.CreateObject("ADODB.Connection") Set adoRecordset = server.CreateObject("ADODB.Recordset") adoConnection.Provider = "Microsoft.Jet.OLEDB.4.0" Dim strLocation, iLength
5
2325
by: Jeff Richardson | last post by:
I am creating a web service that returns data from an Access 2000 database using VS2005. The Access database is located on a different server than where the web service is running. The Access database is also opened by a different desktop application running on various workstations on the network. While developing / debugging the web service is hosted on my development machine using the 'ASP.NET Development Server' that is included...
9
3840
by: Wayne Smith | last post by:
I've come up against a major headache that I can't seem to find a solution for but I'm sure there must be a workaround and I would really be grateful of any help. I'm currently building a web site for a small club I belong to and one of the features I would like to include is the ability to allow users to upload image files. unfortunately the servers web root www folder only allows READ and EXECUTE permissions, which makes it...
5
3551
by: Peter | last post by:
Hi, i've got an older Access program, which is written in the version 2000 and i'd like to use it with my new office 2007, so access 2007. In the program, there is an replication written with the Jet Replica Library, and i read on a microsoft site, that replications in jet schould still work in access 2007, if you still use the old extension .mdb
0
9480
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,...
0
10313
Oralloy
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...
0
10147
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10081
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,...
0
8968
agi2029
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...
1
7494
isladogs
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...
0
5378
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...
2
3643
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2875
bsmnconsultancy
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...

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.