Database Questions and Answers
1 - 20 of 2112
<<PREVIOUS 1|2|3|4|5|6|7|8|9|10 NEXT>>

JDBC connection to DB2/400

Hi, We have application which runs on Java Server connects DB2/400 using JDBC connection. would like to know what is the maximumnumber of database connections supported on DB2/400 and how can I adjust this connection activity so that it is not impacting our application running on as/400 i.e. how to...

Answer Question   |  Nov 20 2009  11:32 AM GMT
JDBC, DB2/400, DB/400
asked by Rajsubhyd

  10 pts.

start career

sir, I have completed my MCA in 2004,but not working after studies because I was in abroad with my family.Recently return back to chennai looking for good opportunity.I would like to start my career in ORACLE DBA.Which course in that will help me to start my career.Also can u suggest me any way to...

Answer Question   |  Nov 20 2009  9:44 AM GMT
DBA training, DBA, Database administration
asked by Zap

  5 pts.

CONNECTION VB WITH ACCESS

how to connect visual basic 6 and msaccess 2003 by using connection string Software/Hardware used: VISUAL STUDIO 2005 WITH MSACCESS 2003

Answer Question   |  Nov 20 2009  7:56 AM GMT
VB 6.0, Visual Basic, Access 2003
asked by Yusuphsngoroge

  5 pts.

Msg 102, level 15, State 1, Line 14

Hi, I'm ttrying to create my db tables in a stored procedure and I keep getting the error that the syntax is incorrect around the 'ON' on the line "SET ANSI_NULLS ON". Could you please help me? I can't see what's wrong. Here's my code:  CREATE PROCEDURE InsertDBTables  AS  BEGIN  SET NOCOUNT...

View Answer   |  Nov 19 2009  6:54 PM GMT
SQL, Stored Procedures, CREATE TABLE statement
asked by MasterK

  15 pts.

The IT Blog Top 10: Nov. 19, 2009

10. The intermediate IBM i 6.1.1 version Mark Fontecchio takes a look at IBM i 6.1.1, and answers the question of how well it fills the gap for those waiting for i5/OS. 9. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover explains some important adminsitration techniques for...

Answer Question   |  Nov 19 2009  6:46 PM GMT
ITKE, AS/400, Channel
asked by Michael Morisy

  710 pts.

Access Tab Control Problem

I had a form that was working fine. I was able to open a form by clicking on the ID in the subform using code "[Forms]![Sales Home]![ConvoQuery subform].[Form]![ConversationID]=[ConversationID]" and it would open the form I wanted.  I have however changed the form to put my subforms into tabs. Now...

asked by Chazzster

  5 pts.

PHP and MS Access Database

I'm trying to access an access databse located in my LAN thru php. When I run the script, I get the below error in Apache's error log file: "[strong]PHP Fatal error: Uncaught exception 'com_exception' with message 'Source: Microsoft OLE DB Provider for ODBC Drivers Description: Operation was...

Answer Question   |  Nov 19 2009  5:22 AM GMT
PHP, Microsoft Access, Access Database
asked by TCF

  5 pts.

SQL

is it possible to have a where sql statement that is open ended. I have notice that there are time that parameter box pops up with some the Access pass-through queries that I have.  Is it possible  with SQL to be able to have a box pop up that would ask for a specific input to the...

View Answer   |  Nov 18 2009  4:40 PM GMT
SQL, Access Datasheet, Microsoft Access 2000
asked by CompEng

  590 pts.

inactive timeout different for one user

can I set a different inactive timeout (logoff) for one user? Software/Hardware used: i5

View Answer   |  Nov 18 2009  3:02 PM GMT
AS/400 user sessions, Timeout
asked by Oldpgmr

  70 pts.

To trap the item name of more than one item selected in list control

1)Is it possible to trap the item name of more than one item selected in the list control?Then how?I wish to trap the item name of more than one item selected in the list/combo control with/without the help of index numbers of the item selected. 2)And then use this item name to pick up data related...

View Answer   |  Nov 17 2009  7:40 PM GMT
Microsoft Access, Visual Basic 6.0, SQL
asked by MBAinsystems

  5 pts.

Datasheet view sorting question

Using the datasheet view, when sorting on a field with or without a dropdown menu, select a choice and then no data appears, even when there is data in the list.  This is a repeatable problem.  Has anyone else experienced this problem? Software/Hardware used: Sharepoint 2007

Answer Question   |  Nov 17 2009  4:16 PM GMT
Datasheet View, Sorting, SharePoint 2007
asked by Rozier

  5 pts.

foxpro 2.6 on windows 98

I am developing a software in foxpro 2.6. on windows 98 When i run the project after every 16 trasactions it gives an error as follows :-      " DO NESTING IS TOO DEEP " there is no logical or syntax error in the project. But still it gives this error. Anybody can tell me the solution.   ...

View Answer   |  Nov 17 2009  11:31 AM GMT
FoxPro 2.6, FoxPro, Windows 98
asked by Pramodtenkale

  15 pts.

Database being auto duplicate when exit.

hi you, i've created a database for my dept and place it on shared server. The problem is everytime user exit from the database, there will be a duplicate of database at the server. Example: my database file name is correspondence_log.accdb, when user finished used the database, there will be an...

Answer Question   |  Nov 17 2009  7:23 AM GMT
Access 2007, Access Database, Microsoft Access
asked by Nurul2981

  5 pts.

Composite foreign Key in SQL Server

I have a composite foreign key that has to be part of the primary key of the new table... but an error appears in SQL server... CREATE TABLE Se_paga_con (IDpel INT NOT NULL, IDvta INT NOT NULL, IDnota INT NOT NULL, CantidadPeliculas INT, PRIMARY KEY (IDpel,IDvta,IDnota), FOREIGN KEY (IDpel,...

asked by GabyCostilla

  5 pts.

how to migrate repository from SVN to VSS version control in Linux based server

Hi Experts, I would seek the help to know how to migrate from SVN to VSS for version control in Linux based machines Which is better out of two,already we have svn setup

Answer Question   |  Nov 16 2009  7:29 AM GMT
VSS, SVN, SVN to VSS Migration
asked by Inprise

  530 pts.

DECFLOAT - Internal Format

Hello, How to translate an internal DECFLOAT value into a visual format? DB2 Administration Guide: "Convert and return a DECFLOAT representation of a number or string representation of a number", (Appendix A. Writing exit routines). There is an example there: Internal...

View Answer   |  Nov 15 2009  2:47 PM GMT
DB2 9, z/OS, DB2
asked by Eligin

  10 pts.

Erro in Subform in Ms Access Reports

Hi All! I have a question that i have designed a report in ms access and I put a subform and linked it with the Party Group, I have put vb codes to use calculate some values if value on subform is null then VBA debug for error, I have used below all function but not solution is there: NZ(), Val(),...

asked by Rahmedarain2005

  10 pts.

Public folder database maintenance?

We have a large contact database (3000+ records) in a public folder(Exchange 2003).  It has a custom form with many user-defined fields.  Does Exchange to any automatic maintenance on these databases?  Is there a maintenance utility I should be running on it? This database contains vital...

asked by Btempleton

  45 pts.

The IT Blog Top 10: Nov. 12, 2009

10. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees offers up an indispensible guide for VBScripters. 9. Standard Server 2003 Migration to SBS 2008 Part 3 Roger Crawford’s third part of his series on Server 2003 migrations. 8. Success of 64-bit Internet...

Answer Question   |  Nov 12 2009  7:00 PM GMT
AS/400, Channel, CIO
asked by Michael Morisy

  710 pts.

Access 2007 IIF statement in query criteria

This is a query design looking at a checkbox on a form, if its checked, I would like to return only the database fields (ConfigData) that contain text. If it isn't checked, return all the fields whether they have text or not...Pretty basic filter I thought Seems like I'm getting close but can't...

View Answer   |  Nov 12 2009  5:04 AM GMT
IIF statement, Access 2007, Microsoft Access
asked by Scubacy

  25 pts.

1 - 20 of 2112
<<PREVIOUS 1|2|3|4|5|6|7|8|9|10 NEXT>>