is it possible to make an inner procedure in (any) jdbc db that will produce simple p2p connection with another db for example a mdb, this is highly needed that the other db will be a flat file (mdb), if you know any way to create connection through another db, with a non-java db (not [...]
Answer Question | June 6, 2008 3:40 PM
Flat files, JDBC, Microsoft Access, Query
What would be the easiest language to use/learn if I want to create a web interface for my Access DB?
Answer Question | June 6, 2008 7:26 AM
Database frontend, Database programming, Microsoft Access
Ok, to get to the point, I’ll talk about the WHAT, I am asking the HOW and I’ll leave out the WHY. I have 3 peices of Data, + credits (positive credits), – credits (negative credits) and I want a dropdown window to the left that stores ways of ‘getting’ those credits or losing them, [...]
Answer Question | June 6, 2008 6:29 AM
DropDownList, Microsoft Access
I would like to have the first character of a field print without the first character? (ex: LC7 to print as C7, The size of the field may vary)
Answer Question | June 6, 2008 10:42 PM
Access 97, Microsoft Access
where does create table get stored in oracle 10g
Answer Question | June 10, 2008 4:47 PM
CREATE TABLE statement, Oracle, Oracle 10g
Is there a way to convert an existing Open Office Base database to MS Access?
Answer Question | June 18, 2008 4:51 PM
Access, Microsoft Access, OO, OpenOffice, VB
I am having to restore data (alot of it!). I am doing this in stages due to the volume of data I’m dealing with. I’d like to copy the docs from the backup copy (made via replica) to the production database while retaining the unique document id. I know I’ve seen code for this, and [...]
Answer Question | June 5, 2008 5:32 PM
LotusScript, Replicating databases
What is a quick & easy solution to generate reports in excel format from a Sybase database?
Answer Question | June 3, 2008 5:09 PM
Business Reports, Scripts, Sybase
I have a SQL Server 2005 database. One of my co-workers has put a MS Access front-end on it, because of the ease of designing queries in Access. I need to convert an existing query from Access SQL to T-SQL to put it into production. So far, I have removed all the obvious differences between [...]
Answer Question | June 4, 2008 3:41 PM
Microsoft Access, SQL, SQL Server 2005, T-SQL
I have a flat 400 file wich is 36 long internally described as follows: 1 2 0ICL 3 6 0ORDNO 7 8 0SUB 9 11 0DEPT P 12 13 2RATE P 14 18 2TOTMTH P 19 23 2OTODAT P 24 28 1HRS2DT 29 36 0INFODT I creasted alogical as follows: R DLLOHD PFILE(DLPLOHD) ICL I [...]
Answer Question | April 24, 2010 3:27 PM
AS/400, Flat files, OS/400
I have my QMF for windows version 8.1 Fix Pack 13, and I try to run this instruction INSERT INTO destination table SELECT * FROM origin table and every time I receive this error message: An error occurred while running the query. destrination table not valid for operation. (SQL code = -7008, SQL state = [...]
Answer Question | October 31, 2009 9:28 PM
AS/400 DB2, QMF, Query Management Facility, SQL
Hi All, Out of curiosity – following up from another thread…. 1. What do you think of the technical questions you’ve had at job interviews? 2. Do you think these questions are relevant? 3. What’s your best/worst experiences of technical questions at interviews? Regards, Martin Gilbert.
Answer Question | June 2, 2008 3:12 PM
Interview questionaire, IT careers
Can anybody please give detail steps how to clone a database(created in Oracle 10g)by hot backup?
Answer Question | June 5, 2008 3:33 PM
Clone database, Hot Backup, Oracle, Oracle 10g
Can I create a Date Picker (enabling users to look up a date from a calendar) in Access 2003 forms?
Answer Question | June 5, 2008 2:11 PM
Calendar control, Database programming, Date Picker, Microsoft Access
Well i m working in MNC As a Network admin actually we have one server having data & application so both our application and database on same server & now we are facing some problem on it so we plan to seperate database server & application if any body has a plan or he/she know [...]
Answer Question | June 1, 2008 10:03 AM
Application Server, Database servers, SQL Server 2000
The relationships window is displayed, and you notice that one of the tables has two feilds shownin bold. What does this mean?
Answer Question | July 8, 2009 2:05 PM
Access 2003, Microsoft Access, Relationship window
Dear sir i created an application useing VB 6.0 and MS-Access.i made it exe and packaged as well as deployed using “Pavkge and Deployment Wizard” from Add-Ins menu. it is installed in my own system where i created the application.While i am installing in another system an Warning shows that “SET UP CAN’T CONTINUE BECAUSE [...]
Answer Question | May 30, 2008 6:51 AM
Microsoft Access, Package and Deployment wizard, VB, Visual Basic 6
Hello, I am developing an application which has several local windows server 2003. All the servers are having sql server 2005 database exactly similar structure but different datas. I want to keep a remote webserver server having a similar database updated online from all these local servers over internet. I was thinking of using ssis [...]
Answer Question | May 30, 2008 4:56 AM
SQL Server 2005, SSIS, Update remote database
I am working with both an Oracle relational database as well as an Oracle data mart, with snowflake schema. Do I need a particular modeling tool to reverse engineer the data mart to produce a data model diagram? Presently I am using Toad Data Modeler to produce a data model for the transaction database.
Answer Question | May 31, 2008 2:27 PM
Data mart, Data Model Diagram, Data modeling, Oracle, Oracle Data Mart, Relational databases, Snowflake Schema, Toad Data Modeler
What is the best way to join more than 2 files using SQLRPGLE with embedded sql?
Answer Question | April 22, 2010 1:59 PM
Embedded SQL, SQLRPGLE