mdb talk to jdbc
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
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
DB Web interface
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
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
Dropdown Window connecting… Help!
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
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
Microsoft Access – I would like to have the first character of a field print without the first character?
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
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
table storing in oracle 10g
where does create table get stored in oracle 10g
Answer Question
| June 10, 2008 4:47 PM
CREATE TABLE statement, Oracle, Oracle 10g
where does create table get stored in oracle 10g
Answer Question
| June 10, 2008 4:47 PM
CREATE TABLE statement, Oracle, Oracle 10g
Convert OO Base to MSA
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
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
copying docs while retaining unique doc id
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
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
Business Reports Sybase
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
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
Problem converting Access SQL query to T-SQL 2005
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 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
Packed fields in Flat Files
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 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
QMF issue
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
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
Technical Questions / Interviews
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
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
Oracle 10g Clone Database
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 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
Date Picker
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
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
Planning to move data on new databse server?
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
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
Microsoft 2003 Access relationship window
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
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
set up file not installed in other system
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
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
how to update a remote sql server2005 database on webserver with multiple similar local database on windows server 2003
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
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
Data Modeling Tools for relational database & dimensional data mart
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
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
Joining More Than 2 Files
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
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
