Click here to Skip to main content
14,361,948 members
   

C#

 
GeneralRe: Reading Access Into SQL - OLE Provider Errors Pin
Kevin Marois4-Oct-19 8:20
professionalKevin Marois4-Oct-19 8:20 
GeneralRe: Reading Access Into SQL - OLE Provider Errors Pin
Richard MacCutchan4-Oct-19 8:30
protectorRichard MacCutchan4-Oct-19 8:30 
GeneralRe: Reading Access Into SQL - OLE Provider Errors Pin
Kevin Marois4-Oct-19 8:40
professionalKevin Marois4-Oct-19 8:40 
GeneralRe: Reading Access Into SQL - OLE Provider Errors Pin
Richard MacCutchan4-Oct-19 23:37
protectorRichard MacCutchan4-Oct-19 23:37 
GeneralRe: Reading Access Into SQL - OLE Provider Errors Pin
Eddy Vluggen5-Oct-19 10:17
mveEddy Vluggen5-Oct-19 10:17 
GeneralRe: Reading Access Into SQL - OLE Provider Errors Pin
Kevin Marois6-Oct-19 7:25
professionalKevin Marois6-Oct-19 7:25 
GeneralRe: Reading Access Into SQL - OLE Provider Errors Pin
Eddy Vluggen6-Oct-19 7:52
mveEddy Vluggen6-Oct-19 7:52 
GeneralRe: Reading Access Into SQL - OLE Provider Errors Pin
Dave Kreskowiak6-Oct-19 9:47
mveDave Kreskowiak6-Oct-19 9:47 
If your Access drivers are 32-bit, your app must also be 32-bit. Because you're using the Access drivers, I'd switch the compile target to x86, not AnyCPU.

The reason your app currently works while being compiled as AnyCPU is because you have "Prefer 32-bit" enabled on the Build tab. This will run your app as 32-bit all the time, even on 64-bit Windows. If this is turned off, AnyCPU will run your app as 32-bit on 32-bit Windows and 64-bit on 64-bit Windows. This will screw with your Access drivers requirements. You cannot mix 32- and 64-bit code in the same process, so if your app is running as 64-bit, you cannot use 32-bit drivers, and the same goes for the other way around.

You must match the architecture of the Access drivers you need to your app, not to Windows. Unless you have a compelling reason to run your app as 64-bit, go back and change the compile target to x86. This will make your app 32-bit only no matter what it runs on and the 32-bit Access drivers will work all the time.

Why should you do this? Because the most popular Office installation, by far, is 32-bit, which already comes with the Access drivers installed. There's no need to install the separate drivers package. Unless, of course, your client is using the Click-To-Run version of Office, which introduces another headache for your app, necessitating installing the separate drivers pack.

GeneralRe: Reading Access Into SQL - OLE Provider Errors Pin
Kevin Marois6-Oct-19 9:51
professionalKevin Marois6-Oct-19 9:51 
AnswerRe: Reading Access Into SQL - OLE Provider Errors Pin
Gerry Schmitz4-Oct-19 11:22
mveGerry Schmitz4-Oct-19 11:22 
GeneralRe: Reading Access Into SQL - OLE Provider Errors Pin
Kevin Marois6-Oct-19 7:16
professionalKevin Marois6-Oct-19 7:16 
QuestionImpossible d'enregistrer les données, que faire??? Pin
Joel_Bidingija3-Oct-19 14:24
memberJoel_Bidingija3-Oct-19 14:24 
AnswerRe: Impossible d'enregistrer les données, que faire??? Pin
Dave Kreskowiak3-Oct-19 14:28
mveDave Kreskowiak3-Oct-19 14:28 
AnswerRe: Impossible d'enregistrer les données, que faire??? Pin
OriginalGriff3-Oct-19 21:03
protectorOriginalGriff3-Oct-19 21:03 
GeneralRe: Impossible d'enregistrer les données, que faire??? Pin
Eddy Vluggen4-Oct-19 0:27
mveEddy Vluggen4-Oct-19 0:27 
GeneralRe: Impossible d'enregistrer les données, que faire??? Pin
Richard MacCutchan4-Oct-19 4:13
protectorRichard MacCutchan4-Oct-19 4:13 
GeneralRe: Impossible d'enregistrer les données, que faire??? Pin
Kevin Marois4-Oct-19 8:24
professionalKevin Marois4-Oct-19 8:24 
QuestionAbout Luhn Algorithm Pin
Member 146114343-Oct-19 2:44
memberMember 146114343-Oct-19 2:44 
AnswerRe: About Luhn Algorithm Pin
Pete O'Hanlon3-Oct-19 2:53
protectorPete O'Hanlon3-Oct-19 2:53 
AnswerRe: About Luhn Algorithm Pin
Dave Kreskowiak3-Oct-19 2:57
mveDave Kreskowiak3-Oct-19 2:57 
AnswerRe: About Luhn Algorithm Pin
OriginalGriff3-Oct-19 5:04
protectorOriginalGriff3-Oct-19 5:04 
AnswerRe: About Luhn Algorithm Pin
CPallini3-Oct-19 8:55
mveCPallini3-Oct-19 8:55 
AnswerRe: About Luhn Algorithm Pin
Kevin Marois4-Oct-19 8:27
professionalKevin Marois4-Oct-19 8:27 
QuestionGet constant from column ordinal. Pin
MAW3030-Sep-19 9:47
memberMAW3030-Sep-19 9:47 
AnswerRe: Get constant from column ordinal. Pin
Richard MacCutchan30-Sep-19 10:17
protectorRichard MacCutchan30-Sep-19 10:17 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.