Crystal 8 & SQL problem
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
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
Bachelor of CSE vs Certifications
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
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
Paste records in OLE Unbound Excel Object in Access Form
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
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
Estimate SQL Server tempdb space for a query
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
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
unable to connect to SQL from Access
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
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
Qualified Data Structures
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
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
new CCNA certifications
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 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
MySQL Database – Multiple Images
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
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
Access – Bound sub form trying to set the value of an unbound field
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 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
Program Described file
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
Flat files
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
Flat files
Database Last modified.
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
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
Learning SQL Part 2
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
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
view data from ODBC to Crystal Reports
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
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
SQL server as data source for OBI EE
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
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
Database modeling question
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 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
Access 2003 default record locking
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
Access 2003
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
Access 2003
what is rack awareness of HDFS?
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
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
Improving the initial speed of a SQL query
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
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
How to pull a query on a particular table based on form selection
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
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
database saves to new file
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
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
