473,326 Members | 2,126 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Access application dies connected to Oracle databases

If anyone has seen this before, please help. I work at a company that
has an Access application front end attached to tables in an Oracle 10g
backend. In order to run our application this way, the client
workstation needs to have the Oracle client with the ODBC driver
installed. When testing this with Oracle 9i, we found we had problems
performing a specific action if the Oracle driver version was anything
but a couple available from the Oracle website. Now we're seeing this
behavior with Oracle 10g, and as I look at the Event Viewer, the error
says the following:
"Faulting application msaccess.exe, version 10.0.2627.1, faulting
module dao360.dll, version 3.6.8618.0, fault address 0x0003fdb6"
If there are any IT experts (Access, Oracle, or OS) that can point me
in the right direction, I would truly appreciate the help.

Thanks,
Stewart

Nov 13 '05 #1
1 1865
s-dogg wrote:
If anyone has seen this before, please help. I work at a company that
has an Access application front end attached to tables in an Oracle 10g
backend. In order to run our application this way, the client
workstation needs to have the Oracle client with the ODBC driver
installed. When testing this with Oracle 9i, we found we had problems
performing a specific action if the Oracle driver version was anything
but a couple available from the Oracle website. Now we're seeing this
behavior with Oracle 10g, and as I look at the Event Viewer, the error
says the following:
"Faulting application msaccess.exe, version 10.0.2627.1, faulting
module dao360.dll, version 3.6.8618.0, fault address 0x0003fdb6"
If there are any IT experts (Access, Oracle, or OS) that can point me
in the right direction, I would truly appreciate the help.


Stewart,

This is NOT a definitive reply, but on a mail list for a specific Oracle
application I manage (it's a computerized maintenance management
system), some folks reported problems with Access and Oracle 10g. I
asked about this and one of the fellows who was having rpoblems reported
that using the Microsoft Oracle ODBC driver and not the Oracle supplied
one solved the problem. I have not heard back yet from the other person
who was having difficulty.

I say not definitive, because I have difficulty believing the Oracle
supplied driver would crap out, but I'm using 8i, myself.

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Nov 13 '05 #2

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

Similar topics

0
by: sedefo | last post by:
I ran into this Microsoft Patterns & Practices Enterprise Library while i was researching how i can write a database independent data access layer. In my company we already use Data Access...
10
by: Andrea M. Segovia | last post by:
Hello, I am a newbie to Oracle databases.... We have a visualization front-end tool connected to an Oracle back-end database on a Tru64 UNIX server. We also have clients with MS access...
6
by: Kenneth Courville | last post by:
Hello, I'm looking for assistance with the Access object model. I know this is VB, but I'm building an Office Add-using C# directed at Access 2002. I'm literate in VB, so you can reply in VB... I...
0
by: totierne | last post by:
comp.databases.ms-access, I want to know how to use Oracle views with session variables in Access. The parameterised views in access, are migrated to views with per session variables. The...
1
by: com | last post by:
Extreme Web Reports 2005 - Soft30.com The wizard scans the specified MS Access database and records information such as report names, parameters and subqueries. ......
17
by: Mell via AccessMonster.com | last post by:
Is there a way to find out where an application was created from? i.e. - work or home i.e. - if application sits on a (work) server/network, the IT people know the application is sitting...
9
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...
8
by: Greg Strong | last post by:
Hello All, The short questions are 1 Do you know how to make DSN connection close in Access to Oracle 10g Express Edition? &/or 2 Do you know how to make a DSN-less pass-through query...
12
by: Earl Anderson | last post by:
Recently, as I was 'flipping thru the TV channels', I heard some woman on a CSpan show 'chiding' the federal government for using MS Access for maintaining records on tracking something (I can't...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.