Recent content by Pyrrhonist

Hmmm...I'm sorry to hear that...I am still awaiting the possibility of a system reset on my end, and still havn't had the chance to test out the suggested changes. One site I had encountered mentioned something like what you're experiencing...unfortuneately, the 'solution' that person listed...

**laugh** No worries! And I'm glad it worked...that bodes well for my problems ;) Just have to wait until we can do a system reboot now!!! Enjoy!

In the link I posted before... http://www.error-bank.com/microsoft.public.dotnet.framework.adonet/84787_Thread.aspx Towards the bottom (page 5 of 7 on my printed copy) it lists this error...(3) Oracle ODBC Driver Had you tried the solution suggested on that page?

We have IIS (fairly certain it's version 4) running on a W2K Server workstation. The Oracle DB is loaded on a NT4Server box, running version 8.0.5 of Oracle. MDAC that is loaded, I've been lead to believe, is 2.7. At this point, I'm still waiting to get admin rights granted to me to start...

Quick update... The application I've developed, has two main methods of communicating with the database...read-only access for queries, and a write/update access for logged in users. The DBA read through the links I posted yesturday, and did everything on them he was able to do (unable to...

Further site with some info that may be useful... http://support.microsoft.com/?scid=kb;en-us;Q255084 We can only restart our server when no users are active, so I havn't (am not able to) test any of these potential solutions. But it sounds like this may well be the same problem / solution...

Odd...we're running Oracle 8.0.5 on NT4.0 machine, and the IIS server is running on Win2K Server... If I read your info correctly, you're saying that the solution is an older version of Oracle? But that is what we have, and that still doesn't work...I encountered THIS URL that might help...

This is EXACTLY what I'm running into as well...if anyone out there comes up with an answer, I'm all ears ;) One of the options we are looking at (and one I'm NOT wanting to do) is to set up an ODBC connection and use that. The DBA I'm working with is using SQL Server on the IIS machine, and...

Pgk....not sure how you were opening notepad to begin with, but I had to open notepad through the accessories folder, then saveas from there....hope that and cmmrfrds suggestion helps :) And ya....the way you had suggested a recordset for linking Oracle to the Access DB sounded GREAT! Even...

Just been informed...the recordset notion of connectivity works great, for a single table, but I've gotten a peek at the Oracle backend, and there are ROUGHLY 60 tables that require linking...the avenue of solution I have been sent down now, is to create a User DSN by code, which the application...

Thanks for the prompt reply cmmrfrds!! That worked PERFECTLY!!! Well...one little thing that I had to change to your code... cn.open connString couldn't get it to work with the Set cn command you had provided. Trouble I'm having now, and I was JUST made aware of how the Oracle DB was...

Wondering if there is a specific chunk of code that you could use to create a DSN link to an Oracle database when the Access database loads, that can then be severed on close of the database? I've encountered the syntax as being driver=blah;server=blah;database=blah;uid=blah;pwd=blah but how...

Thanks for the prompt reply Jay.... Yes, the qryResults is the datasource for the main form...the nav buttons on the top are used to work through the results which get displayed. The subforms are connected through link child and link master fields with SSG File # (A seperate issue I'm having...

Having a problem getting my page to refresh the subforms the way I want them to The followink link will show the basic front end I'm working with http://deepblue.cs.camosun.bc.ca/~cst01046/SSG.JPG SSG File, Reserve, Ship Code and Project are all unbound text boxes. You can do a search, by...

Having a problem getting my page to refresh the subforms the way I want them to The following link will show the basic front end I'm working with http://deepblue.cs.camosun.bc.ca/~cst01046/SSG.JPG SSG File, Reserve, Ship Code and Project are all unbound text boxes. You can do a search, by...