• 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...

    Virtualfrankdotcom20 pointsBadges:
  • What’s a good, simple reliable way to log errors for later investigation?

    I'm doing new work in an old old system. It's built with a bit of everything you could use from System/34 onwards - except maybe WSU. Naturally, as I Put together new functions, I test return codes, record locks, database integrity as I go. Just spent a couple of hours finding out that a function...

    Yorkshireman5,580 pointsBadges:
  • 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 retrieved 2. Join...

    BR5 pointsBadges:
  • 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 of...

    Standaman15 pointsBadges:
  • Install QMF V9

    What are the conversion requirements for QMF objects going from V8 to V9 - queries, forms & procs and what about tables and views saved in QMF, do they need to be unloaded and re-loaded?

    BhleftD10 pointsBadges:
  • tablespace

    when does alter Tablespace trackmod yes become active

    BLR5 pointsBadges:
  • Automatic transfer of AS400 output file to PC folder

    Is there a way to automatically transfer an output file to PC folder in an Excel form? My boss want me to create a CL program that every time the output file was created, it automatically convert that output file to Excel(numeric values in comma seperated) in a PC folder. I usually do this...

    Radycal45 pointsBadges:
  • Oracle 9i migration

    How to migrate Oracle 9i from Windows 2000 server to Solaris and vice-versa?

    OracleandSQLServer5 pointsBadges:
  • I’ve been hacked — I think….

    I'm an IT administrator with a little over 500 end users, running Windows 2000 and XP. One of our users is experiencing a problem with her Internet connection suddenly dropping for no apparent reason. When she restarts her computer, everything works fine for awhile, but then the connection drops...

    LMullen0 pointsBadges:
  • 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 will be...

    Heato11220 pointsBadges:
  • 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...

    Spenzer25 pointsBadges:
  • 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?

    CompEng1,185 pointsBadges:
  • data base files

    How are the negative values in the packed fields are stored in the PF? How to enter negative data in those fields?

    ten20081,150 pointsBadges:
  • 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...

    VirgilReality20 pointsBadges:
  • Delete OLD files from Table not having date or timestamp

    Hi, In DB2, Is it possible to get the insert date of a record in a table which doesn't have a seperate field for creation date or timestamp. I have a task where I have to delete record older than 1 year from a table, but the files doesn't have creation date field. So, like RRN does DB2 have any...

    RJES45 pointsBadges:
  • After trigger select from other tables using joins

    Is it possible to create a trigger on table A if there is an insert, update, or delete then fire the trigger but in addition to the changes in table A I want to capture values from table B,C,D,E.... even if those records had no action applied to them. I tried declaring variables from the other...

    Pmnc81795 pointsBadges:
  • 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:

    Sryn5 pointsBadges:
  • Certification sites for Synon?

    Hello, Please can anyone suggest some good certification sites or courses for Synon or DB2 400. Except the ones from IBM. Synon is more broadly needed!!

    Jammypune5 pointsBadges:
  • Oracle 6i Log in – User-name & Password

    What is the user-name and password of Oracle 6i to Log in?

    4004145 pointsBadges:
  • Update Table use Left outer join in ms acces

    hello, i wont to ask i try to update table use from another table, i sue the left outer join if in ms sql server this command is run, but when i try to in ms acces its cant run please see the command Private Sub Command31_Click() Dim update_personallog As Integer update_personallog = "update...

    Wahyono25 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