• Crystal Reports 8.5 Access 2007

    When rewriting a report I get an error that the table of a 2nd datasource in the report could not be found. This happens when trying to verify the DB which I need to do since the db has changed. A field was added. Any idea what to do? Thank you in advance.

    kravetzgita5 pointsBadges:
  • What wiki software do you recommend?

    Just as the title suggests, what wiki software (DokuWiki, MediaWiki, etc...) do you suggest to run?  The purpose of this is nothing more than to make a remote note-taking sort of scenario, so it's not something for anyone but me to be used.  I know I could do my own thing and stuff, but I'd...

    Eric Hansen2,065 pointsBadges:
  • Microsoft Access Relationship/Query Question

    I have a database with around 3,000,000 records organized by account number, and another database with 100,000 or so organized by the same account number. I import both these databases into Access, and link up the account numbers… I want to pull data from both databases in order to create a new...

    Highamperage15 pointsBadges:
  • SQL Connection

    Using VB6 How can I build a connection code to connect to SQL DB

    Khl5 pointsBadges:
  • Import Microsoft Access tables into Oracle

    Can tables created in Access or Excel be imported into Oracle?

    Micheline foxxe10 pointsBadges:
  • CONNECTION VB WITH ACCESS

    how to connect visual basic 6 and msaccess 2003 by using connection string

    Yusuphsngoroge5 pointsBadges:
  • SQL statement using RRN(file) on join pulling only Max(date) records from second file in iSeries

    I am using WebSmart with the I-series data base files. I am joining two data base files receiving the RRN so that I can use the fetch rrn and the fextnext to display one screen at a time in my WebSmart program. I have used this method many times except this time I have a one to many relationship...

    Isjld35 pointsBadges:
  • How to store an IP address in MySQL

    Could anybody tell me what the right field type would be for storing an IP address in MySQL? Also, what's the right way to store it too?

    ITKE351,905 pointsBadges:
  • SORT/MERGE in COBOL/400

    Hello, Can anyone, provide sample programs for SORT/MERGE statements in COBOL/400?

    AnonymousUser13,030 pointsBadges:
  • Knowledge management (KM) system for large organization?

    We are a large non-profit organisation (20,000+) with many individuals producing minutes and summaries from internal and external meetings, parliamentary debates, conferences, etc. We are considering to implement a Knowledge Management system, which should allow local users to enter summaries...

    RBS5 pointsBadges:
  • Free online practice exercises on SQL/Oracle

    I would like to know is there any website which offers free practice exercises on SQL/Oracle queries? Preferably advanced level queries. Thanks, Kruti

    Kpatel0 pointsBadges:
  • Migrate MySQL database to SQL 2005

    We are looking to migrate from MySQL to a full blown iteration of SQL 2005. Are there tools in place that will allow us to migrate our data and tables or are we on our own for getting our data into the MS database?

    Karl Gechlik9,860 pointsBadges:
  • How can I determine by database size in MySQL?

    Does anyone know if there's a specific query or function that can determine the size of my database in MySQL? If there isn't one, what's the best way to go about it? I tried this and it came up with 474989023196466.25 MB (even though I know the database is 400 MB). SELECT...

    ITKE351,905 pointsBadges:
  • How should I store large files in a MySQL database?

    We have a PHP script that we upload large files with (up to 500MB) and it's stored in a MySQL database. Here's the code we're using: mysql_query("INSERT INTO table VALUES('')"); $uploadedfile = fopen($_FILES['file']['tmp_name'], 'rb'); while (!feof($uploadedfile)) { $line =...

    ITKE351,905 pointsBadges:
  • Recovering lost data from SQL Server 2005

    Running SQL Server 2005. I found that I had lost about 2000 records the Assets table and more records in the associated tables Timeassets and AssetBillingrates.  Each of the tables uses an Id field as the Primary Key. I was able to identify the key records that had been lost and tried inserting...

    BClawson10 pointsBadges:
  • Trigger Use in SQL Server 2005

    I have a Sequel Server 2005 database with a Table called Main Call Issue. I want to update the DateTimeModifed field to be the Current System date without changing my original DateTimeAdded field when the record was added to the database. I know a Trigger will work here. Where do I place the...

    Jjc98105 pointsBadges:
  • Web based contacts for small business

    We are a non-profit buying group with 3 persons in our office. We need a contact data base that can be shared including on the fly changes. We have a network, but no dedicated server. We currently are using Act 6.0, but that is getting old and problem riddled. Is there a web based contacts...

    Wick5 pointsBadges:
  • What type of IT degree/training do you need?

    I am currently looking to get into becoming a DBA. Unfortunately even after many weeks of researching I cant find many clear answers to what I want to accomplish. I am looking to start out with a 2 year degree somewhere grab a few certifications that will greatly increase my job hunting, and...

    Mh865 pointsBadges:
  • How to I insert a table if it doesn’t exist in a MySQL database?

    In a MySQL database, I'm trying to do the following query: INSERT INTO table_listnames (name, address, tele) VALUES ('Rupert', 'Somewhere', '022') WHERE NOT EXISTS ( SELECT name FROM table_listnames WHERE name='value' ); But it keeps returning the same error. I don't want to insert a record if the...

    ITKE351,905 pointsBadges:
  • How can we check if a MySQL database exists?

    Can anyone tell me if it's possible to check if our MySQL database exists after we've made a connection? We already know how to check if a table exists in our database but now we need to see if the actual database exists. Thanks!

    ITKE351,905 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following