Search results for query: *

I have several workstations where the switchboard suddenly quit working. On other workstations everything still works properly,  but on the problem stations I get an error when switchboard tries to set up a database variable. Im almost positive there's an mdac or dcom problem but cant...

I need to query on a date field on a forms 4.5 form. This is NOT a sql query. In a sql select its easy enough to to_char the date and trim the time portion. However, I cant seem to find any way to do it on a form so I can do an oracle "form query." The query always fails to find the date even...

Download the Data Access Components from Microsoft. That will give you the ODBC drivers. Ive never been able to get the Oracle provided ODBCD driver to work.<br> <br> As stated above you have to have sql/net or Net8 installed on your client and configured correctly.<br> <br> In ODBC...

I currently use a front end Oracle Forms 4.5 form with buttons that use run_product to submit Reports 2.5 reports. Lets say I have three or four form letters in Reports 2.5 submitted based on a SSN parameter. I want to submit several reports with the same button, for the same employee without...

This may be off the subject a bit, but Ive been working with Vb for a while and the last year or so using vb and access as a front end for Oracle databases, and some asp for providing data to web browsers and I end up spending most of my time trying to keep clients, odbc, mdac components etc...

You got that right. I have trouble remembering why I did something yesterday....:)<br> <br> Having a summary table always seemed like the most practical way to handle this problem, but I couldnt get over the feeling I was taking the easy way out just to avoid having to solve the problem in sql...

I have a hospital application where I want to report on demographics of residents (male, female, black, white, etc), the average daily population of the facility, and the average length of stay. I have a person table with the demographics and a movement table which gives me the dates and times...

I have several GUI forms that I would like to migrate to a browser form, what is the best way to pursue this migration? Has anyone actually converted existing developer forms to browser forms?<br> <br>

At least its not just me then. If win2000 could solve this one problem that would make it worth the upgrade. Our last workstations were NT workstation so we are better able to lock the users out of making changes, installing software etc. <br> <br> Ive done a couple "front ends" to Oracle...

There must be a secret. Ive been working with vb since version 4 now up to 6. Ive developed several applications including a simple personnel database. But there is one problem I have not been able to overcome, either with vb or access applications. I still can not create an application that...

It would probably pay to leverage your access/vb knowledge by upgrading to sql server. Like the post above points out you're going to run out of room in a couple years unless theres a possibility of purging old records to trim it down. You can build your front end in visual basic for an...

I have a persons table with a personid. As the individuals addresses, phone numbers etc. change new records are added to the address, phone number tables etc, linked by personid. The addresses, phones tables have sequence numbers to indicate the most recent entry. There must be a simple sql...

Ill wade through that and give it a shot. Is Visual Interdev worth the investment? Seems like Ive read some uncomplementary reviews?<br> <br> thanks for the reply<br> <br>

Unfortunately we are running on NT which doesnt have cron. <br> <br> How do you spool your text to file? Text_io, set spool on, or some other method?<br> <br> thanks for the reply<br>

What ODBC driver are you using? I use the standard MS Oracle ODBC driver to link Oracle8 tables in Access97 and have never had any problem. I havnt tried any of the new OleDB drivers or other methods of linking, but they might also be an option if you dl the MS MDAC components.<br> <br>

I found some references to dbms_job, but even in my best ref books there is no description of how to use it. It is mentioned by name but there are NO examples of how to use it. Is there any chance you could point me to any examples of using dbms_job? <br> <br> IT would be a great help if I could...

thanks, Ill give that a try and see if it helps. <br> <br>

Fortunately in our in-house developed reports I have the source, its only in the vendor supplied forms applications I dont. How would you go about converting to ascii instead of bitmap? The reports are developed in reports 2.5 and I can save them from developer as a "compiled" (i think its and...

I need to scan a large database at least every 10 minutes to identify records that have been added that match a certain critera. The sql statement is fairly simple and I don't need to pull more than a half dozen fields. I expect to find a few dozen records during a 24 hour period that match my...

There are only a couple of settings you can't adjust after installing the database. I can't remember them right off, but I know you have to set them properly to begin with or you have to reinstall. We just went through our go live on a new Oracle 8 database. Our only REAL major problem during...