Execute a query on table in different db that will make a table in currentdb
Cheers, I have an Access 2007 application that uses mostly vb.net code to create an excel spreadsheet with all the necessary data in the right places… The program uses a specific set of data that resides in a different database. What I would like to do is connect to the foreign table (which I can [...]
Answer Question
| June 23, 2009 9:55 PM
Access 2007, Database, Visual Basic, Visual Basic .NET
Cheers, I have an Access 2007 application that uses mostly vb.net code to create an excel spreadsheet with all the necessary data in the right places… The program uses a specific set of data that resides in a different database. What I would like to do is connect to the foreign table (which I can [...]
Answer Question
| June 23, 2009 9:55 PM
Access 2007, Database, Visual Basic, Visual Basic .NET
Conversion of table into XML
How to load a table into XML in a CLOb using Oracle 8.1.4
Answer Question
| June 22, 2009 10:10 AM
CLOB, Oracle 8.1.4, Table to XML, XML
How to load a table into XML in a CLOb using Oracle 8.1.4
Answer Question
| June 22, 2009 10:10 AM
CLOB, Oracle 8.1.4, Table to XML, XML
pasting a database query into crystal
I am creating reports in Crystal 8.5 because it is required for the CRM system we use. I am having trouble pasting the SQL query that I need into the report. It will populate but it is not updating the contents of the report. Can anyone hel with this?
Answer Question
| June 19, 2009 4:37 PM
Crystal Reports, Crystal Reports 8.5, Crystal Reports Database, SQL queries
I am creating reports in Crystal 8.5 because it is required for the CRM system we use. I am having trouble pasting the SQL query that I need into the report. It will populate but it is not updating the contents of the report. Can anyone hel with this?
Answer Question
| June 19, 2009 4:37 PM
Crystal Reports, Crystal Reports 8.5, Crystal Reports Database, SQL queries
Information Systems Security or Computer and Information Science Degree?
I am roughly one year from graduating with my B.S. in Information Systems Security. So far, I’ve completed my general education requirements, and am now beginning my core and major classes. Lately, I’ve found myself second-guessing my decision of ISS: is an ISS degree such a good idea? Or should I change to a more [...]
Answer Question
| June 29, 2009 11:40 PM
Career development, CCNA, CCNP, Certifications, CIO, Computer and Information Science, Information Systems Security, IT careers, IT education, Network+, Security+
I am roughly one year from graduating with my B.S. in Information Systems Security. So far, I’ve completed my general education requirements, and am now beginning my core and major classes. Lately, I’ve found myself second-guessing my decision of ISS: is an ISS degree such a good idea? Or should I change to a more [...]
Answer Question
| June 29, 2009 11:40 PM
Career development, CCNA, CCNP, Certifications, CIO, Computer and Information Science, Information Systems Security, IT careers, IT education, Network+, Security+
How to show two query results in one Microsoft Access report
I have two queries saved, one shows the record that match a criteria and the othe query shows the record that do not match the criteria. ie. query1 in the feild lastname the criteria is “jones” in query2 in the feild lastname the criteria is Not”jones”. What I want to have is a report that [...]
Answer Question
| June 29, 2009 9:55 PM
Access 2003, Database programming, Microsoft Access, Micrsoft Access reporting
I have two queries saved, one shows the record that match a criteria and the othe query shows the record that do not match the criteria. ie. query1 in the feild lastname the criteria is “jones” in query2 in the feild lastname the criteria is Not”jones”. What I want to have is a report that [...]
Answer Question
| June 29, 2009 9:55 PM
Access 2003, Database programming, Microsoft Access, Micrsoft Access reporting
Would you go with iSCSI or Fibre Channel for mass storage in this case?
Is there any TPS benchmarking available in deciding whether to go for Fibre channel or iSCSI? We are using Oracle database which requires a Terabyte of storage and will be operating at the 1000TPS at peak level. In this case – should we go for iSCSI or Fibre Channel as the mass storage device? Thank [...]
Answer Question
| June 23, 2009 3:19 PM
Fibre channel, iSCSI, Oracle Benchmark Testing, Storage Channel, Storage management, Transactions Per Second
Is there any TPS benchmarking available in deciding whether to go for Fibre channel or iSCSI? We are using Oracle database which requires a Terabyte of storage and will be operating at the 1000TPS at peak level. In this case – should we go for iSCSI or Fibre Channel as the mass storage device? Thank [...]
Answer Question
| June 23, 2009 3:19 PM
Fibre channel, iSCSI, Oracle Benchmark Testing, Storage Channel, Storage management, Transactions Per Second
Difference between ODBC and JDBC?
I’m writing a Java application. In short, this application needs to connect to DB2 on an AS/400 for some SQL data. I cannot find a straightforward comparison of ODBC and JDBC. Do any of you know where I can find one? Or, have any of you done java programming with the intent to connect to [...]
Answer Question
| April 19, 2013 1:49 PM
AS/400, Database, DB2, Development, Java applications, JDBC, ODBC, SQL
I’m writing a Java application. In short, this application needs to connect to DB2 on an AS/400 for some SQL data. I cannot find a straightforward comparison of ODBC and JDBC. Do any of you know where I can find one? Or, have any of you done java programming with the intent to connect to [...]
Answer Question
| April 19, 2013 1:49 PM
AS/400, Database, DB2, Development, Java applications, JDBC, ODBC, SQL
How to retrieve images from the database programmatically using .NET?
insert and retrieve pictures from database
Answer Question
| June 18, 2009 3:10 AM
.NET, .NET development, Database connectivity
insert and retrieve pictures from database
Answer Question
| June 18, 2009 3:10 AM
.NET, .NET development, Database connectivity
What backend works best with Cognos frontend?
Our company is looking to install Cognos as an upgrade from the Access reporting system we currently use. What is the best backend database to a Cognos frontend? We are considering SQL Server, but aren’t sure if that is the best option. Any suggestions?
Answer Question
| June 18, 2009 8:19 PM
Cognos, Microsoft Access, SQL Server
Our company is looking to install Cognos as an upgrade from the Access reporting system we currently use. What is the best backend database to a Cognos frontend? We are considering SQL Server, but aren’t sure if that is the best option. Any suggestions?
Answer Question
| June 18, 2009 8:19 PM
Cognos, Microsoft Access, SQL Server
what is the responsible of the junior network engineer?
Hello everyone. i want to know the responsibilities of the Junior Network Engineer. please tell abt the main role of JNE.
Answer Question
| July 9, 2009 6:36 PM
Careers, IT careers, Junior Network Engineer, Network Engineers
Hello everyone. i want to know the responsibilities of the Junior Network Engineer. please tell abt the main role of JNE.
Answer Question
| July 9, 2009 6:36 PM
Careers, IT careers, Junior Network Engineer, Network Engineers
Query showing vbCRLF in string data
Can someone provide SQL code that would generate a table showing any instance where a vbCRLF character can be found anywhere in my table? IOW, I’m trying to list records where the user input 2 or more lines of data in a simple text field. E.g., “John Q. vbCRLFSmith” as opposed to just “John Q. [...]
Answer Question
| June 24, 2009 4:25 PM
Access 2003, Access Database, Microsoft Access, SQL Query, vbCRLF
Can someone provide SQL code that would generate a table showing any instance where a vbCRLF character can be found anywhere in my table? IOW, I’m trying to list records where the user input 2 or more lines of data in a simple text field. E.g., “John Q. vbCRLFSmith” as opposed to just “John Q. [...]
Answer Question
| June 24, 2009 4:25 PM
Access 2003, Access Database, Microsoft Access, SQL Query, vbCRLF
Configuration Management tool
Is anyone aware of a configuration management tool that allows tracking and management of all resources (hardware, software, people, budget and schedules etc) associated with an application? Ideally this would cover both open systems (Linux, MS etc) and Mainframe ZoS. For example, a new project may require part cloning of an existing environment for testing, [...]
Answer Question
| October 17, 2010 9:55 AM
Application management, Configuration management, Environment Variables, Relational databases
Is anyone aware of a configuration management tool that allows tracking and management of all resources (hardware, software, people, budget and schedules etc) associated with an application? Ideally this would cover both open systems (Linux, MS etc) and Mainframe ZoS. For example, a new project may require part cloning of an existing environment for testing, [...]
Answer Question
| October 17, 2010 9:55 AM
Application management, Configuration management, Environment Variables, Relational databases
Is any AS/400 CBT (Computer Based Training) available for free
Hi All, I am learning AS400 can any one please help me where i can get CBTs for free i found CBTs in some of the websites for $1000 but now i am not in a position to purchase for that much amount.
Answer Question
| June 18, 2009 7:28 AM
AS/400 training, Computer Based Training, IT careers, IT education
Hi All, I am learning AS400 can any one please help me where i can get CBTs for free i found CBTs in some of the websites for $1000 but now i am not in a position to purchase for that much amount.
Answer Question
| June 18, 2009 7:28 AM
AS/400 training, Computer Based Training, IT careers, IT education
Find and replace in Foxpro 2.06 for DOS
Hello i am using foxpro 2.06 for dos fro my small application needs. i want use find and replace a character in low level file opening….. ( using fopen() ) pls help. 2nd Q : How to use the ; (semicolon ) as Delimiter in fox 2.06 for dos. Thx Giri
Answer Question
| June 17, 2009 5:23 AM
Find and Replace, FoxPro 2.6, FoxPro 2.6 for DOS
Hello i am using foxpro 2.06 for dos fro my small application needs. i want use find and replace a character in low level file opening….. ( using fopen() ) pls help. 2nd Q : How to use the ; (semicolon ) as Delimiter in fox 2.06 for dos. Thx Giri
Answer Question
| June 17, 2009 5:23 AM
Find and Replace, FoxPro 2.6, FoxPro 2.6 for DOS
Capitalize First Character
How can ensure that when certain columns in a row are INSERTed/UPDATEd, the first letter of the value is capitalized and the rest are lower case? For example “QUESTION” or “question” should be converted to “Question”.
Answer Question
| June 17, 2009 2:43 PM
INSERT statement, T-SQL
How can ensure that when certain columns in a row are INSERTed/UPDATEd, the first letter of the value is capitalized and the rest are lower case? For example “QUESTION” or “question” should be converted to “Question”.
Answer Question
| June 17, 2009 2:43 PM
INSERT statement, T-SQL
ORA-01031 Insufficient privileges
I am trying to generate FK on table in schema A, which is the reference of PK on another table in schema B. The owner of schema A is also a DBA. It gives an error ORA-01031 Insufficient privillages
Answer Question
| June 16, 2009 6:51 AM
Foreign keys, ORA-01031, Oracle development, Oracle error messages, Oracle foreign keys, Oracle primary keys, Primary keys
I am trying to generate FK on table in schema A, which is the reference of PK on another table in schema B. The owner of schema A is also a DBA. It gives an error ORA-01031 Insufficient privillages
Answer Question
| June 16, 2009 6:51 AM
Foreign keys, ORA-01031, Oracle development, Oracle error messages, Oracle foreign keys, Oracle primary keys, Primary keys
How to publish a MS Access application as a regular web page in Internet Explorer.
I’m publishing a Microsoft Access application, on a Windows Server 2008 machine, with RemoteApp. I want to know if there is a way to access this application over the Internet without using the web access feature. To be more precise, I want to publish my application as a regular web page in Internet Explorer.
Answer Question
| June 15, 2009 6:47 PM
Microsoft Access, RemoteApp, Windows Server 2008
I’m publishing a Microsoft Access application, on a Windows Server 2008 machine, with RemoteApp. I want to know if there is a way to access this application over the Internet without using the web access feature. To be more precise, I want to publish my application as a regular web page in Internet Explorer.
Answer Question
| June 15, 2009 6:47 PM
Microsoft Access, RemoteApp, Windows Server 2008
IT Career advice
Please note: The following question was recently submitted by a user via e-mail: I am kindly requesting you to assist me.I am university graduate.I did Degree in Library and Information Science,of which i was majoring in two subject, Library Science and I.T.So i want to divert my career totally to I.T, So my problem is [...]
Answer Question
| June 15, 2009 1:52 PM
Careers, Certifications, IT careers
Please note: The following question was recently submitted by a user via e-mail: I am kindly requesting you to assist me.I am university graduate.I did Degree in Library and Information Science,of which i was majoring in two subject, Library Science and I.T.So i want to divert my career totally to I.T, So my problem is [...]
Answer Question
| June 15, 2009 1:52 PM
Careers, Certifications, IT careers
Lotus Notes Calendar to Microsoft Project or Access
I want to be able to track the current meetings in my Lotus Notes (LN) calendar. Am I am able to link my meeting entries to Project or Access to track them. I realize there are CRM databases and etc. However, I do not want to re-write the information that is already in my meeting [...]
Answer Question
| June 15, 2009 9:38 PM
Lotus Notes Calendar and Meeting Tracking, Lotus Notes calender, Lotus Notes interoperability, Lotus Notes Meeting, Microsoft Access, Microsoft Project
I want to be able to track the current meetings in my Lotus Notes (LN) calendar. Am I am able to link my meeting entries to Project or Access to track them. I realize there are CRM databases and etc. However, I do not want to re-write the information that is already in my meeting [...]
Answer Question
| June 15, 2009 9:38 PM
Lotus Notes Calendar and Meeting Tracking, Lotus Notes calender, Lotus Notes interoperability, Lotus Notes Meeting, Microsoft Access, Microsoft Project
Career switch from programming to SAP functional role
hi, i have 2.5 years experience in .net programming with a software firm.i want a career switch to SAP.i also want to avoid programming.Which SAP module should i take up?Can i move into any of functional modules of SAP?
Answer Question
| January 8, 2010 12:53 PM
.NET development, IT careers, SAP careers, SAP Functional
hi, i have 2.5 years experience in .net programming with a software firm.i want a career switch to SAP.i also want to avoid programming.Which SAP module should i take up?Can i move into any of functional modules of SAP?
Answer Question
| January 8, 2010 12:53 PM
.NET development, IT careers, SAP careers, SAP Functional
