• dBASE Program Result File

    Created a program to extract certain records from a file. What do I need to put in program to create a new file with the results?

    curley20165 pointsBadges:
  • Storing XML data in MySQL database

    How can I go about storing my XML data into a MySQL database? It's pretty complex data so I want to make sure it's done the right way. Do I have to use foreign keys?

    ITKE413,530 pointsBadges:
  • List Microsoft Access database tables using SQL

    Would there possibly be a way to list all of my tables in a Microsoft Access database using SQL? I know how to do it in SQL Server but not sure of the command in Access. Thanks!

    ITKE413,530 pointsBadges:
  • How to import MySQL database dump file in Java

    Is there a way for me to import my MySQL database dump file programmatically in a Java program? I've tried the below code but nothing is working. Connection conn = dbConnectionSource.getConnection(); Statement stmt = conn.createStatement(); stmt.execute(FileUtils.readFileToString(new...

    ITKE413,530 pointsBadges:
  • Best format to store images in SQL Server database

    For my SQL Server database, what's the best format to store images? Would binary be the best bet? Thanks so much.

    ITKE413,530 pointsBadges:
  • How to encrypt my database

    With all these hacks going around, I need my database to be very secure (particularly my hard disk). But I'm not sure which databases support encryption. Can someone help me out? If it's not possible, are there other ways I can encrypt my database. Thanks!

    ITKE413,530 pointsBadges:
  • Compact Microsoft Access database in VBA

    My apologizes for the brief question but, in Microsoft Access, can I compact my current database using VBA? Thanks!

    ITKE413,530 pointsBadges:
  • SQL Server 2012 error message when restoring database

    I keep getting this odd error message in SQL Server 2012 when I'm trying to restore a backup that was made from a previous version. Here's the error message I'm getting: System.Data.SqlClient.SqlError: Directory lookup for the file "C:\PROGRAM FILES\MICROSOFT SQL...

    ITKE413,530 pointsBadges:
  • MS Access 2007: 15 years of contract

    Hello, I'm a student in an intern program right now. My organization give me a MS Access file that contain information of contract workers. They asked me to separate which of the workers that almost work for 15 years and make a reminder for user 6 months before due date. My department scope is...

    Vencro25 pointsBadges:
  • MySQL: Get last deleted ID

    In MySQL, is there a way for me to get the actual last deleted ID after a row has been deleted? Perhaps a command / query that's similar to getting the last inserted ID. Thanks.

    ITKE413,530 pointsBadges:
  • How to get list of tables in Microsoft Access database through C#

    I just opened a connection to a Microsoft Access file through C# but would there be a way for me to retrieve a list of tables that exist in the Access database? I appreciate the help.

    ITKE413,530 pointsBadges:
  • DB2: Decrease column length

    Can I decrease the column length in DB2? In one of my columns, it's currently defined as VARCHAR(80). I want to move it to VARCHAR(60). How can I do that?

    ITKE413,530 pointsBadges:
  • Error when accessing MySQL database through web admin console

    For the past week, I've been trying to access a MySQL database through the web admin console. But I keep getting this strange error message: SQL select table_schema,table_name from information_schema.views where table_schema = ? failed : Got error 28 from storage engine. What should I do?

    ITKE413,530 pointsBadges:
  • Can two foreign keys reference the same primary key that is team table and fextures table having team a and team b referencing the team table primary

    Can two foreign keys reference the same primary key on another table. That I have team table attributes (Team_id, Team_name, Team_captain) and fixtures table having this attributes (Fixtures_id, fixture_time, fixture_date, fixture_venue, 1team_id, 2team_id). My question is this: Is it possible for...

    jupake15 pointsBadges:
  • Loading image into MySQL database from Excel file

    I have an excel file that contains an image in the first col. When I save it to an csv format, the excel program creates two images ( 1 small, 1 large) for each line in the excel file. How do I load both the file data and the large image into my mysql database?

    Wlm49hv5 pointsBadges:
  • Partition MySQL database by date automatically

    My colleague and I have a MySQL database that we need to partition by date (especially the month / year). But when we add new data, we don't want to update the database manually. How can we do it automatically? What's the process? Thank you.

    ITKE413,530 pointsBadges:
  • Incremental backup of MySQL log files

    We're currently using MySQL and several of our tables are InnoDB. This is followed by a replication to a slave server. Now, here's what we need to do: Backup our MySQL log files on a daily basis. What's the best way to do an incremental backup? Thanks!

    ITKE413,530 pointsBadges:
  • Issue Exchange 2013 error mount database

    Server exchange can't mount database. Error failed an active manageroperation failed, disk or controller issues may cause slow mount, failed due to timeout 300 seconds on server. I need help with this urgent.

    Wmorales5 pointsBadges:
  • Database connectivity from Oracle Forms

    We are having a legacy running running on Oracle Forms and Reports. I want to change the database connection to point to a different database, how do I do that? P.S: I am pretty new to forms and reports

    Ms123115 pointsBadges:
  • Add comment to SQL code in MySQL

    One of my co-workers sent me a SQL code and I need to add a comment to it. Is there a way to do that? This is currently for MySQL. Thank you so much.

    ITKE413,530 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.

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

Following