-
Oracle 10g database creation errors in windows 7
hello friends this is avishek behera.. recently i installed oracle 10g database software only in windows 7. after that i tried to create a database.. but i got an error like oermission denied.. i have installed in d drive which is not my system drive and also installed with administrator previlage...
Last updated: -
Importing a “flat” field into a Lookup Table format in SQL database
* I have over 1000 records in a table (Context_Tasks_DB), one field of which (termed Purpose) should really be a Lookup to another table (tblPurpose), but currently simply has text (only 30 unique text values are in that field and are therefore repeated...). * I have created a table...
Last updated: -
Old Recovering Access database password
A client of mine worked on a database 5 years ago for a research project, but she had to quit for a while for cancer treatments. She's now responded well enough to go back to the project but her database, done probably in Access 2003 (perhaps even an earlier version, but certainly not a later one)...
Last updated: -
Recommend a Simple Data Input & Editing Tool
[strong]Please[/strong] recommend a simple to use data input, text editing tool that will create a "flat file" with data fields that are in specific starting positions of the flat file.
Last updated: -
Put date time into 15 interval value in MySQL
does any one know if mysql have a function where I can convert datetime value into : 15 mins interval for example : 03NOV2010:00:00:02 --> 0-15 03NOV2010:00:16:02 --> 15-30
Last updated: -
Hello, We have a ?LAN without any server Windows OS in it? , so everybody is a client (with fixed IP). The only ?server? we have, is our iSeries i5 (V5R3) with iSeries Access(CA) installed (also on the clients). We cannot ?map drive? the IFS f.e. root with \QS6555A8Aroot (or anything else on the...
Last updated: -
Benefits/disadvantages of hosting SQL server on site versus MySQL in cloud?
What are the benefits or disadvantages of hosting a SQL server on site or using a MYSQL server in the cloud? The MYSQL box is much cheaper is there anything I will not be able to do with my web app using MYSQL?
Last updated: -
Access 2000 Database Entry Question
When creating a table is there a way to set the first entry as a drop down menu and the associated entry as a currency entry on the same line? We are trying for an employee database that has several extra jobs that we would like in a drop down menu and then be able to associate the money that will...
Last updated: -
How do I INSERT records into AS400 DB2 file from SQL server?
I can pull data from AS400 to SQL but cannot get my command on the SQL server to push the data back. This is a very small process, I only need an item number and date. Also, the date on the SQL db is "datetime". I'll need to convert that to a more recognizable date field to put in the AS400...
Last updated: -
If there are special instructions for a superseded PTF that is not loaded or applied on your system in an ordered PTF cover letter, do you need to order the superseded PTF and follow the instructions for it before loading the PTF that will supersede it? I hope my question makes sense.
Last updated: -
Access Control List for users allowed to access network
Is it possible to setup an access list for allowed computers on the network and prevent others from using any network resources like internet and printers. Even with a valid username and password I want them blocked if they are not on the Access Control List.
-
SQL Server error 7125: Updated driver to get around?
I have used Microsoft ODBC SQL Server Driver to create a link to an SQL table using Microsoft Access. The table stores Word documents. However Access will not save records once large pictures are added to the Word document (thus increasing the size of the document). The following error occurs:...
Last updated: -
Using Excel 2010 to pull data from SQL Server?
How can I use excel 2010 to pull data from my sql server? I have an odbc connection set up and need data from a specific table in a specific database. I want excel to do some projections and calculations.
Last updated: -
DB2 or Websphere- for good career in IT
Out of IBM DB2 and IBM Websphere, which is a better technology to study in terms of career option????
Last updated: -
IT Book Giveaway: Oracle Solaris Cluster Essentials
We've got your ultimate in-depth resource on the start-to-finish lifecycle guidance for planning, implementation, management and troubleshooting your Oracle Solaris Cluster. There's even helpful advice for both Oracle and non-Oracle database environments. Win this valuable resource by answering one...
Last updated: -
Showing or hiding fields in an Access report
I have a db created for managing employee records. I would like to build a label report that shows or hides different fields on the label depending if a field has a value. The fields are Office, home address, city, state, and zip. If the member has an office location then i would like to hide the...
Last updated: -
Access Point configuration with Cisco 1240
how to configure two access point 1240 cisco with each other ?
Last updated: -
Total Balance for Concatenated Unique ID in Access and Excel
Hi, I have two spreadsheets that I import in to MS Access to compare. To get a comparable Unique Identified, I concatenate the data in three columns to one unique reference. I then want to find the total balance for each identifier, which normally have around 8 entries each and then compare it...
Last updated: -
Improve performance on Insert rows into DB2 400 table from SQL server
Using INSERT OPENQUERY and a linked server on SQL Svr 2005, to insert rows to DB2 table on AS400. To a local AS400 runs very quickly. Performance on a remote 400 is very slow, and seems to be out of proportion to the change in line speed. Is there anyway to improve the performance for Inserts to...
Last updated: -
How do I copy an Access 2003 database and table?
I'm using Microsoft Access 2003. How do I copy a database and table? They were set up by someone that's no longer with the company.