• SQL Server 2005 or 2008?

    I am a database user going back many years and have used several different platforms from the high-end (NCR's Teradata) down to MS Access. I work for a Marketing Service Provider and we do alot of Marketing Database building with associated reporting and analysis and also use SAS for statistical...

    Habana5 pointsBadges:
  • CMake – Automatically regenerate a file using an external tool and custom target upon “make”

    Hi. I'm working on a project and I use cmake for generating "projects", that is, under Linux, a Makefile. I also use an external tool (re2c) to generate the scanner, and an included tool to generate the parser (lemon, part of sqlite). The problem is I need to "cmake" every time I change something...

    OriginalCopy30 pointsBadges:
  • How can I join 3 tables using JOIN keyword

    Hi Experts, Pls hlp me with my query How can i join 3 tables using JOIN Keyword inside PL/SQL block in SELECT ... WHERE clause Query 3 Tables namely Reg,ROOTS,ME and the select statement takes both parameter variable and local variable Thanks!!!!!

    Inprise610 pointsBadges:
  • Can’t manually enter data any more; get Error Message: String or binary data would be truncated.

    Three databases that were forced restored now do nor allow manual entry, even one single character, although using an update statement works. This is not a matter of changing the length of the datatype, but something else. For the life of me, I can't figure out why this mere attempt at manual data...

    Jimruddy5 pointsBadges:
  • Rights to Exchange Information Store

    I am running an ERP webapplication Exact eSynergy in which I can schedule appointments. I also use Exchange to schedule appointments and setup a synchronisation between Exchange and eSynergy so I can use either application to see all appointments. The synchronisation job is setup in the SQL job...

    Bbarella5 pointsBadges:
  • Combo box question when developing a SQL database in Visual Basic 6

    I am developing a SQL database using Visual Basic 6 with ADO and Microsoft Access, but in it, I have a combo box with two options - yes and no. I want the combo box, after yes or no is selected, to open another form where a user can enter other details. How would I do this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Navigation Pane

    In Access 2003, my database window showed me all my database objects. Now I have a navigation pane that I have to scroll through to locate things. Is there any way to display all the objects in my database at once?

    Medved5 pointsBadges:
  • Conditional processing in embedded SQL

    I'd like to conditionally control the host variable into which the data from an SQL select statement is retrieved. This is for flexibility, so that I can use the same code in my program more than once. Here is a code sample: C/EXEC SQL C+ If :ResultName = 'AgtMaster' C+ Then C+ Fetch Next From...

    Cwc4,290 pointsBadges:
  • User security based on table in database

    I am using Access 2003. I have a small (2 table) database. One table contains unit rework information. The second table contains User information(ID, FirstName, LastName, Security level). I built a form with a place for 3 users to 'sign off' - one for operators, one for supervisors & one for QA....

    Rbrown3805985 pointsBadges:
  • Complex Database Issue

    I'll try to be brief: I have excel files that are downloaded via ftp to a folder where I have my DB. each of the excel files is "roughly" the same headers, I want to import all of these files, filter out all but 3 columns and then filter out certain rows in each table (at minimum, 25 tables) can...

    Mreed725 pointsBadges:
  • Microsoft Access menus

    How do you setup menus using MS Access?

    Danljonessr10 pointsBadges:
  • Converting a varchar to a numberic in SQL query

    How can we convert a varchar field to Numberic in a SQL Query in db2 400?

    AS400 - Ask the Expert485 pointsBadges:
  • Granting and Revoking DB2 authority

    We've had several requests to grant 'temporary' SELECT authority on a table (meaning they want the user to have the authority for today, and not tomorrow). The DBAs don't want the housework of remembering to revoke the authority tomorrow, so we were wondering if anyone knows a way to grant...

    Nperk20 pointsBadges:
  • DB2 update query giving error STRING REPRESENTATION OF DATETIME VALUE HAS INVALID SYNTAX.

    The following sql query in DB2 is giving the exception. What can be the correct query for this in DB2? SQLQuery=update EMP set validityenddate='01-JAN-07' WHERE username='XYZ' Exception: msg=java.sql.SQLException: [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and...

    Saimadhu455 pointsBadges:
  • Database hang on AIX

    I'm experiencing a database hang and so far I haven't discovered the root cause of the problem. We are running DB2 v9 fixpak 3a on AIX 5.3. The instance is hanging and we can't kill the DB2 processes so the only way to restore services is rebooting the server. The following is the output from the...

    AS400 - Ask the Expert485 pointsBadges:
  • Database offline vs Database stopped vs Database network disconnected?

    How Database Offline is different from Database Stopped? How Database Offline is different from DB network disconnection? How Database Stopped is different from DB network disconnection? Appreciate your help.

    Saimadhu455 pointsBadges:
  • Oracle ERP single signon using Active Directory

    We are on Oracle 9i and will like to implement a solution to allow Oracle ERP users to signon using Microsoft Active Directory. Thanks Thanks

    Morounfolu15 pointsBadges:
  • Using Dlookup to populate form fields

    I have a simple database with one table(Issue log). What I want is a form that allows for creating a new "issue" within the table or updating the status of an existing issue. I want the form (Issue log) that will update an issues' status to auto-populate based on which issue number you enter....

    Dave4015 pointsBadges:
  • How to push the Database into deadlock state?

    Hi, We are doing Database FailOver testing (DBFO). As part of this, we want to check if primary db is in deadlock state then what happens? whether the transactions will go to back up db or not? How to get the primary db into deadlock state? Appreciate your help.

    Saimadhu455 pointsBadges:
  • How to import Microsoft Access to SQL Server 2005

    hi, while i am importing database MS-Access to sql server 2005 its could not importing its Showing like this: The operation could not be completed. Additional information: -> Not a valid password.(Microsoft JET Database Engine) What to do? can you give the solution. Thanks, Deepa

    Deepatss5 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