I created 80+ reports for the company intranet and they worked great. At the time the ODBC’s were set up for a general SQL connection of sa/blank password. Now the connection connects via windows login/password. The reports have stopped working. I rebuilt one from scratch and put in on the intranet but it still doesn’t [...]
Answer Question | August 5, 2009 2:19 PM
Crystal Reports, Crystal Reports 8, ODBC, SQL
Does a bachelor degree in computer science and engineering cover the contents of A+, MCSE or CCNA? If not, why and then what are basic fields of career of a graduate of computer science and engineering?
Answer Question | August 4, 2009 8:32 PM
A+, A+ Certification, Careers, CCNA, Certifications, IT careers, MCSE
Ok so I have built a database that is used to house and manipulate records that I get from a monthly report that is posted online. Basically I work for the Army and we have over 50 units. Each unit has anywhere from 10 to 1000 soldiers in it. I initially had tried to build [...]
Answer Question | August 5, 2009 2:26 PM
Access forms, Microsoft Access, Microsoft Excel, OLE
Database – MS Sql Server How to estimate the amount of space that a query uses in tempdb? I am trying to join certain transaction tables that are really huge – about 300GB. Is there a way I can compute the space that the query might take in tempdb based on factors like: 1. Columns [...]
Answer Question | August 3, 2009 7:46 PM
Space allocation, SQL Server, SQL Server Data Storage, TempDB
I want to create a new database on SQL Server 2008 from Access 2007. I had no problem before I updated to vista from XP professional. When I test the connection, no problem, however when I try to create the database I get the message: The new database wizard does not work with the version [...]
Answer Question | August 3, 2009 6:10 PM
Access 2007, Microsoft Access, SQL Server 2008, SQL Server to Microsoft Access
What is a Qualified Data Structure? Where can I find information on them? IBM RedBooks dont seem to have the answer????
Answer Question | August 4, 2009 11:18 AM
Data structures, IBM RedBooks, Programming, Qualified Data Structures, RPG IV
Hi all, I have recnetly get my mcsa2003 certification and looking to enter in cisco arena, but confused which track to chose security, wirless or voice. I personally dont consider myself well for security are then 2 left, can anyone advise which is the best in context of future prospective. Wireless or Voice. Also can [...]
Answer Question | February 14, 2011 8:44 AM
Careers, CCNA, CCNA Certification, IT careers
Hi, I am going to build a database soon for a website that can grow tremendously in the long run when it comes to the amount of records being added. This will be a MySql Database integrating with a Flash website. My main question is how should I handle multiple images being uploaded. A user [...]
Answer Question | July 30, 2009 8:17 PM
MySQL, MySQL Database
I have a bound sub form with a Datasheet view.. One of the fields on the form I want to be unbound, but still display the value of a field for row displayed. How do I show the value.
Answer Question | August 6, 2009 3:44 PM
Access Database, Access Datasheet, Microsoft Access, Microsoft Access subforms, VBA
I have defiend the program described file (flat file) as update mode and defined the data structure (for the flat file). i’m trying to update the specifice data that i structured in DS. But, when i try to compile, i’m getting an compilation error saying that record format as not defined (for update which is [...]
Answer Question | July 30, 2009 3:28 PM
I have a 150 databases in a server. and i want to know the last modified date of each database
Answer Question | April 23, 2010 10:45 PM
Database Last modified., Database management, Last modified
Is there anything out there that would teach help me to learn SQL dealing with communicating with an AS400 system and using MS Access passthrough query system to bring it into Access but using the SQL system as the communicator? What books or Web sight is available?
Answer Question | July 30, 2009 9:11 AM
AS/400, AS/400 SQL, Microsoft Access, SQL, SQL Training
i am using Crystal Reports 10 to display data from ODBC. The error “Failed to open rowset. Details:HY000:
Answer Question | July 29, 2009 7:14 AM
Crystal Reports, Crystal Reports 10, ODBC
hi everyone,i have been using OBI EE for the past 2 months.I have been using Oracle 10g database as a data source for OBI EE and it worked just fine and now im trying to use SQL server 2005 as my data source. My ODBC was succesful and i can import from that database but [...]
Answer Question | July 24, 2009 9:35 AM
obi, OBI EE, ODBC, SQL Server 2005
I have a quandry on my hands. Another developer and I are designing a replacement for an older custom application, and we’re deep into data modeling. We can’t agree on a solution. More precisely, I think it should go one way, he thinks it should go a different way, and I can’t quite prove that [...]
Answer Question | July 30, 2009 9:04 PM
Database, Modeling, Normalization
I’m working with a multi-user Access system. When I change the default record locking option via Tools/Options/Advanced and then save the database, the other users still have the original setting for record locking, i.e. the change I have made is not shown on their machines. Shouldn’t the change I have made be stored with the [...]
Answer Question | July 23, 2009 6:45 PM
What is reck awareness of HDFS and how can i optimize the network bandwidth using replication factor 2 ?
Answer Question | July 21, 2009 7:41 PM
Database optimization, HDFS, Network performance, Rack Awareness
I have optimized my SQL query to the maximum extent. The first time I ran the query, it took 7 seconds; the next time it took half a second. Why did this happen? How can I make the query run faster the first time around?
Answer Question | July 21, 2009 6:11 PM
SQL queries, SQL Query, SQL query optimization
Ok this is not as simple as the title suggest, this is what I’m trying to do: I have a database with about 30 tables (which are actually linked to Excel spredsheets). I need to be able to query each table and make a report only showing certain information for it. I started by doing [...]
Answer Question | July 21, 2009 5:27 PM
Access forms, Microsoft Access
Hi all. Why would an access database save to a new file each time it is worked on? Mine keeps saving to db1, db2, db3, etc.
Answer Question | July 17, 2009 3:36 PM
Access Database, Microsoft Database