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...
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...
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...
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...
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
how to connect visual basic 6 and msaccess 2003 by using connection string Software/Hardware used: VISUAL STUDIO 2005 WITH MSACCESS 2003
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...
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...
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...
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...
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...
View Answer
| Nov 19 2009 6:30 PM GMT
Access Forms Database, Access 2007 forms, Microsoft Access 2007
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...
View Answer
| Nov 19 2009 6:30 PM GMTAccess Forms Database, Access 2007 forms, Microsoft Access 2007
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...
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...
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...
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...
inactive timeout different for one user
can I set a different inactive timeout (logoff) for one user? Software/Hardware used: i5
can I set a different inactive timeout (logoff) for one user? Software/Hardware used: i5
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...
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...
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
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
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. ...
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. ...
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...
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...
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,...
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,...
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
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
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...
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...
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(),...
Answer Question
| Nov 15 2009 7:34 AM GMT
Microsoft Access, Access reports, Microsoft Access subforms
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(),...
Answer Question
| Nov 15 2009 7:34 AM GMTMicrosoft Access, Access reports, Microsoft Access subforms
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...
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...
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...
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...
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...
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...
