Database

Database

Hi dear,

I am receiving this error. Please provide me its solution. How can I remove this error.

Details of Error:

Error in invoking target install of makefile/user/ora9/product/9.2/network/lib/ins_oemagent.

Mk

Press ‘Help’ for more information.

Press ‘Retry’ to try again.

Press ‘ignore’ to ignore this error and go on.

Press ‘Cancel’ to stop this installation

  • 1003 views
  • 1 answers
  • 0 votes

I want to take only the date part of passed date time string.

Example:

If I pass '8/16/2011 12:47:01.698187 AM -4.00 AM' . I only require '8/16/2011' from the following query:

select trunc(''8/16/2011 12:47:01.698187 AM -4.00 AM') from dual;

But it is throwing an error: ORA 01722- invalid number .

Can you please correct the query?

  • 1169 views
  • 1 answers
  • 0 votes

Hi,

I am writing one query:

select  * from user where logged_in_time='15aug2011 00:00:00' ;

as logged_in_time is a timestamp field and I want to list out all the users who logged in at this time.But it is not displaying any output, whereas if I write:

select * from user;

and try to find it manually, rows are present with this logged_in_time. Please help.

Regards,

Jake.

  • 840 views
  • 1 answers
  • 0 votes

Define meta data? Give three reasons why meta data can be useful?

  • 924 views
  • 3 answers
  • 0 votes

I am using SQL server in my office, it contains really sensitive databases, I have made a lot of securities in server like secured login to windows and its secured access on the LAN, but even then I want to set passwords in every database so that no one can access these highly secured databases except me.

  • 903 views
  • 1 answers
  • 0 votes

Hi Techyv people,

While I was working on my inventory encoding task using an application build from Microsoft Access, I met an error message when I saved my work. Please refer below for more details of the error message.

Change the data in the field or fields that contain duplicate data

 Microsoft Access

The changes you requested to the table were not successful because they 

would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the 

  • 1504 views
  • 1 answers
  • 0 votes

Hi guys,

I am at work generating some inventory reconciliation, when I am about to generate the final report an error message appeared on my screen, see below the screen shot.

Microsoft Office Access Application-defined or object-defined error

Microsoft Office Access

Application-defined or object-defined error

  • 1225 views
  • 1 answers
  • 0 votes

Hi MS Access Masters,

I am consulting an error that I met. I am wondering why I can't open my database. I always receive an error message that the database cannot be recognized.

Microsoft Office Access

Microsoft Office Access

Unrecognized database format ‘D:Files2maydb_2.mdb’.

The database that I want to open cannot be recognized by MS Access. I just used this file lately that is why I am wondering when I opened it a while ago, I received an error. I am afraid to lose all the data in it if I will do some experiment on it. Please help me in repairing the file. What is the cause of this error?

  • 1496 views
  • 1 answers
  • 0 votes

My best regards to all readers.

I was at work this morning working on our CRM application, when I wanted to save some edited record to the database an error message appeared about a drive space error.

Microsoft Office Access

ODBC—call failed

[IBM][i Series Access ODBC Driver][DB2 UDB]SQL0666 – SQL query exceeds specified time limit of storage limit. (#-666)

  • 2289 views
  • 1 answers
  • 0 votes

My warm greetings to all readers in techyv.

I have some issues here to consult. This is about my problem regarding ActiveX function. Whenever I am working on my Microsoft Access task that involves an ActiveX, I receive an error message. Please see below the error message for your reference on the problem.

A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX Control.

Microsoft Access

  • 2081 views
  • 2 answers
  • 0 votes

Latest Articles

Free cloud mining is coming! RICH Miner launches mobile mining, everyone can earn cryptocurrencies

RICH Miner officially launches a new mobile cloud mining application, subverting the traditional mining model! No need to buy mining machines, no technical experience required, just a mobile phone, global users can start the...

Rokid Max 2 Review: I Tried AR Glasses So I Could Watch Netflix in...

I’m not a tech geek. I don’t keep up with every new gadget launch. I fly a few times a year, watch many movies on my phone, and live in a small apartment where...

Top 10 Technology Trends For 2025

With 2025 just around the corner, it is time to start thinking about what tech trends will be coming our way. Tech moves at a rapid pace. Some things may pop up next year...

Latest Blogs

Top 10 New Laptop Entrants That Shook The Public

The finest laptops are powerful enough to do your daily tasks, comfortable enough to use all day, and power-efficient enough to ensure you don't run out of battery power unexpectedly. Of course, all these...

10 Facts About The Dark Web

Before getting into knowing the facts, let’s have a brief about the Dark Web. The dark web is the data of the World Wide Web that is accessible only through special software, combinations, or...

Top 10 Latest Steam Cleaner Machines

While looking for a chemical-free way to clear and purify both durable and low grounds in your home, a steam cleaner is an excellent solution. With a spurt of superheated steam, this cleaning equipment...

Latest Tips

Top 10 Internet Monitoring Software

Internet monitoring software keeps a log of all internet activities. You can install this type of software on your computer remotely or by the administrator. An operating console controls this software. This type of...

Top 10 Best Partition Manager Software

A Hard Disk Drive is usually partitioned into various smaller drives for optimization. A partition manager helps make this process easier and more efficient. Here, let’s discuss the top 10 best partition manager software. 1....

Top 10 Best Online Music Production Software

Music production is the initial stage of any song. Music production can be done either in studios or at home using an online music production software. Here, let’s discuss the top 10 best online...