updating, deleting in access with asp.net using Visual basic
You would update or delete records almost the same way as executing the query to populate your grid, but you would use the ExecuteNonQuery method: <pre> query = “DELETE FROM advertiser WHERE <some_column> = <something>” UpdateOrDeleteCommand = New OleDbCommand(query, msaccessconnect) UpdateOrDeleteCommand.ExecuteNonQuery() </pre>
View Answer
| December 15, 2010 11:07 PM
Access 2003, ASP.NET, Visual Basic, Visual Basic .NET
You would update or delete records almost the same way as executing the query to populate your grid, but you would use the ExecuteNonQuery method: <pre> query = “DELETE FROM advertiser WHERE <some_column> = <something>” UpdateOrDeleteCommand = New OleDbCommand(query, msaccessconnect) UpdateOrDeleteCommand.ExecuteNonQuery() </pre>
View Answer
| December 15, 2010 11:07 PM
Access 2003, ASP.NET, Visual Basic, Visual Basic .NET
bmail to send mail to an exchange server
Make sure the system has permissions to relay through your Exchange server. Your Exchange Admin can check this for you.
View Answer
| December 15, 2010 9:28 PM
BMail, CMD, Exchange 2003, Socket error
Make sure the system has permissions to relay through your Exchange server. Your Exchange Admin can check this for you.
View Answer
| December 15, 2010 9:28 PM
BMail, CMD, Exchange 2003, Socket error
Software application to build database
Well it would really depend on how much data you are looking to store. If the data is small you can use Access for the front and back end. If it is slightly bigger you can use Access for the front end and SQL or MySQL for the back end. And finally if the scope [...]
View Answer
| December 14, 2010 12:28 AM
.NET, Access, Database, Database frontend, Java, Visual Basic, Web development, Web development tools
Well it would really depend on how much data you are looking to store. If the data is small you can use Access for the front and back end. If it is slightly bigger you can use Access for the front end and SQL or MySQL for the back end. And finally if the scope [...]
View Answer
| December 14, 2010 12:28 AM
.NET, Access, Database, Database frontend, Java, Visual Basic, Web development, Web development tools
Combining Access 2003 Queries for Dates Criteria
I think that you need UNION instead of JOIN. Ex. <pre>select * from ( select * from PleadingsLog union all select * from LitigationLog union all select * from DiscoveryLog ) as x where <date criteria></pre>
View Answer
| December 13, 2010 9:03 PM
Access 2003, Access 2003 date query, Access query, Access Tables, Windows XP Professional, Windows XP Professional SP3
I think that you need UNION instead of JOIN. Ex. <pre>select * from ( select * from PleadingsLog union all select * from LitigationLog union all select * from DiscoveryLog ) as x where <date criteria></pre>
View Answer
| December 13, 2010 9:03 PM
Access 2003, Access 2003 date query, Access query, Access Tables, Windows XP Professional, Windows XP Professional SP3
How to remove the double quotes in CSV file in iSeries
:: remove double quotes @echo off & setLocal EnableDelayedExpansion for /f “tokens=* delims= ” %%a in (thefile) do ( set str=%%a set str=!str:”=! >> newfile echo !str! ) Let me know if this works. Robert
View Answer
| December 13, 2010 5:05 PM
AS400 program, CLLE, CSV, CSV file format, iSeries, Shell commands
:: remove double quotes @echo off & setLocal EnableDelayedExpansion for /f “tokens=* delims= ” %%a in (thefile) do ( set str=%%a set str=!str:”=! >> newfile echo !str! ) Let me know if this works. Robert
View Answer
| December 13, 2010 5:05 PM
AS400 program, CLLE, CSV, CSV file format, iSeries, Shell commands
How to create data security in SQL server 2005 so that the code will not be opened
U can hide the implementation details of stored procedures from end users of the application using WITH ENCRYPTION option. ENCRYPTION indicates that SQL Server encrypts the syscomments table entry containing the text of the CREATE PROCEDURE statement. The WITH ENCRYPTION clause hides the text of a stored procedure from users. It is true that, trigger, [...]
View Answer
| December 13, 2010 11:51 AM
SQL Security, SQL Server 2005, SQL Server 2005 security, SQL Server security
U can hide the implementation details of stored procedures from end users of the application using WITH ENCRYPTION option. ENCRYPTION indicates that SQL Server encrypts the syscomments table entry containing the text of the CREATE PROCEDURE statement. The WITH ENCRYPTION clause hides the text of a stored procedure from users. It is true that, trigger, [...]
View Answer
| December 13, 2010 11:51 AM
SQL Security, SQL Server 2005, SQL Server 2005 security, SQL Server security
Starting a session in MySQL
Here the Q is not clear properly. More details r required. i.e. what os and what is the web and other related SW. If possible supply actual scenario, that helps to provide more correct answers. Though I am trying to provide some information, that may help u. Session is related with any web application. Session [...]
View Answer
| December 13, 2010 11:16 AM
MySQL, MySQL functions, MySQL query
Here the Q is not clear properly. More details r required. i.e. what os and what is the web and other related SW. If possible supply actual scenario, that helps to provide more correct answers. Though I am trying to provide some information, that may help u. Session is related with any web application. Session [...]
View Answer
| December 13, 2010 11:16 AM
MySQL, MySQL functions, MySQL query
Backup process for several IIS hosted website
More details r required…. for what version of IIS u r using and also What OS! Though here is the steps to backing up IIS hosted websites….. 1. Start >Programs > Administrative Tools > Internet Services Manager 2. Expand Server Name If u r using IIS 5, Click Action > Backup/Restore Configuration If u r [...]
View Answer
| December 13, 2010 5:27 AM
Backup and restore, IIS, IIS Server, MySQL, MySQL backup, Server Backup
More details r required…. for what version of IIS u r using and also What OS! Though here is the steps to backing up IIS hosted websites….. 1. Start >Programs > Administrative Tools > Internet Services Manager 2. Expand Server Name If u r using IIS 5, Click Action > Backup/Restore Configuration If u r [...]
View Answer
| December 13, 2010 5:27 AM
Backup and restore, IIS, IIS Server, MySQL, MySQL backup, Server Backup
Scope for sun solaris administrators
As far I know, there is an excellent future on Sun Solaris administrator. As a System Administrators, the tasks r to perform essential system administration procedures on the Sun Solaris OS & technical application support staff responsible for administering a networked server running on same OS. Sun offers certifications for the Solaris 8, 9 and [...]
View Answer
| December 10, 2010 7:38 AM
IT careers, Networking, Solaris, Sun Solaris
As far I know, there is an excellent future on Sun Solaris administrator. As a System Administrators, the tasks r to perform essential system administration procedures on the Sun Solaris OS & technical application support staff responsible for administering a networked server running on same OS. Sun offers certifications for the Solaris 8, 9 and [...]
View Answer
| December 10, 2010 7:38 AM
IT careers, Networking, Solaris, Sun Solaris
Excel and Access integration and auto-population
In my opinion, the best approach is for your users to enter their data into a single repository where you can access it. This eliminates them sending it to you and you merging it into your database. For example: Put your Access database on a network share visible to all of your users. (Or download [...]
View Answer
| December 7, 2010 6:41 PM
Acces, Access 2000, Access Database, excel, Excel 2010, Excel macros, Macros
In my opinion, the best approach is for your users to enter their data into a single repository where you can access it. This eliminates them sending it to you and you merging it into your database. For example: Put your Access database on a network share visible to all of your users. (Or download [...]
View Answer
| December 7, 2010 6:41 PM
Acces, Access 2000, Access Database, excel, Excel 2010, Excel macros, Macros
Choosing a correct combination with ABAP for job opportunities
It is difficult to say which combination suits u. Please take a calculation that helps u Create a sheet in Excel, and make rows like list of the decisions which u want to take consideration in order of priority for eg. Salary, Career Aim, Technology, Time dedicate urself. And under columns header write options which [...]
View Answer
| December 7, 2010 11:46 AM
ABAP, DC_ABAP, IT careers, SAP careers
It is difficult to say which combination suits u. Please take a calculation that helps u Create a sheet in Excel, and make rows like list of the decisions which u want to take consideration in order of priority for eg. Salary, Career Aim, Technology, Time dedicate urself. And under columns header write options which [...]
View Answer
| December 7, 2010 11:46 AM
ABAP, DC_ABAP, IT careers, SAP careers
Exclusive access to Access 2003 database
Here’s an article on Technet which describes this symptom, explains the reasons for the error and offers a workaround. Take a look to see if it helps. <a href=”http://support.microsoft.com/kb/839782″>You receive a “You do not have exclusive access to the database at this time… (Article ID: 839782)</a> I have also read that some external program that [...]
View Answer
| December 7, 2010 1:29 AM
Access 2003, Access Database, Access database permissions
Here’s an article on Technet which describes this symptom, explains the reasons for the error and offers a workaround. Take a look to see if it helps. <a href=”http://support.microsoft.com/kb/839782″>You receive a “You do not have exclusive access to the database at this time… (Article ID: 839782)</a> I have also read that some external program that [...]
View Answer
| December 7, 2010 1:29 AM
Access 2003, Access Database, Access database permissions
E-mail hacking
Well, the real question is why do you need to hack your email address? If it’s just to find the password that you used to configure outlook or a similar client, there are programs out there that can reveal the password (i.e. it “knows” what’s behind the *s), and there’s also network sniffers that can [...]
View Answer
| December 5, 2010 6:21 AM
Application security, Database, Encryption, Exchange, Instant Messaging, Secure Coding
Well, the real question is why do you need to hack your email address? If it’s just to find the password that you used to configure outlook or a similar client, there are programs out there that can reveal the password (i.e. it “knows” what’s behind the *s), and there’s also network sniffers that can [...]
View Answer
| December 5, 2010 6:21 AM
Application security, Database, Encryption, Exchange, Instant Messaging, Secure Coding
SQL 2008 job problem
First remove the call to xp_cmdshell. Change the job command type from TSQL to Operating System (CmdExec) and just put in the bcp call.
View Answer
| December 3, 2010 8:15 PM
SQL 2008, SQL job scheduler, SQL Jobs, SQL Server 2008, Windows Server 2003
First remove the call to xp_cmdshell. Change the job command type from TSQL to Operating System (CmdExec) and just put in the bcp call.
View Answer
| December 3, 2010 8:15 PM
SQL 2008, SQL job scheduler, SQL Jobs, SQL Server 2008, Windows Server 2003
Progressive Incident ID number in Access 2007
Both can be done, but you would probably prefer option ‘b’. In summary you could do it modifying your entry form to add a BeforeInsert event and put some code to get the last code for the current date to generate and assign the new code. But you might want to store the last incident [...]
View Answer
| December 3, 2010 2:14 AM
Access 2007, Access 2007 forms, Access 2007 functions, Access Functions
Both can be done, but you would probably prefer option ‘b’. In summary you could do it modifying your entry form to add a BeforeInsert event and put some code to get the last code for the current date to generate and assign the new code. But you might want to store the last incident [...]
View Answer
| December 3, 2010 2:14 AM
Access 2007, Access 2007 forms, Access 2007 functions, Access Functions
Create trigger using iSeries Navigator
CREATE TRIGGER AUMASTRIG AFTER UPDATE OF RATE ON MASTER REFERENCING OLD AS OLD_ROW FOR EACH ROW MODE DB2ROW BEGIN INSERT INTO HISTORY(FIELD1, FIELD2) VALUES(OLDROW.FIELD1, OLDROW.FIELD2); END;
View Answer
| December 2, 2010 4:05 PM
AS/400 triggers, iSeries Navigator, SQL, Triggers
CREATE TRIGGER AUMASTRIG AFTER UPDATE OF RATE ON MASTER REFERENCING OLD AS OLD_ROW FOR EACH ROW MODE DB2ROW BEGIN INSERT INTO HISTORY(FIELD1, FIELD2) VALUES(OLDROW.FIELD1, OLDROW.FIELD2); END;
View Answer
| December 2, 2010 4:05 PM
AS/400 triggers, iSeries Navigator, SQL, Triggers
Help regarding my SAP career
The guide is here and u have to look for this : http://itknowledgeexchange.techtarget.com/itanswers/about-sap-career/
View Answer
| December 2, 2010 12:39 PM
IT career planning, IT careers, SAP careers
The guide is here and u have to look for this : http://itknowledgeexchange.techtarget.com/itanswers/about-sap-career/
View Answer
| December 2, 2010 12:39 PM
IT career planning, IT careers, SAP careers
Free IT Book: Enterprise Web 2.0 Fundamentals
Hi, Just answered the question <a href=”http://itknowledgeexchange.techtarget.com/itanswers/mac-filtering-via-windows-2008-radius-server”><b>Mac filtering via Windows Server 2008 RADIUS</b></a> <a href=”http://itknowledgeexchange.techtarget.com/itanswers/mac-filtering-via-windows-2008-radius-server/#viewquestion”><b>here</b></a>. HTH Also answered the question <b>Routing problem with two Windows Server 2003</b> <a href=”http://itknowledgeexchange.techtarget.com/itanswers/routing-problem-3/#viewquestion”>here</a>. Luís
View Answer
| November 30, 2010 3:12 PM
Giveaways, HTTP, IT answers, IT Books, ITKE Contests, Radius Server, SAN, Sybase, Windows Server 2003, Windows Server 2008, Wireless router
Hi, Just answered the question <a href=”http://itknowledgeexchange.techtarget.com/itanswers/mac-filtering-via-windows-2008-radius-server”><b>Mac filtering via Windows Server 2008 RADIUS</b></a> <a href=”http://itknowledgeexchange.techtarget.com/itanswers/mac-filtering-via-windows-2008-radius-server/#viewquestion”><b>here</b></a>. HTH Also answered the question <b>Routing problem with two Windows Server 2003</b> <a href=”http://itknowledgeexchange.techtarget.com/itanswers/routing-problem-3/#viewquestion”>here</a>. Luís
View Answer
| November 30, 2010 3:12 PM
Giveaways, HTTP, IT answers, IT Books, ITKE Contests, Radius Server, SAN, Sybase, Windows Server 2003, Windows Server 2008, Wireless router
3rd party connectivity to SQL server through firewall
Configure the firewall so that their public IP has access through the firewall. Ensure that the login which they use to connect to the SQL Server instance has only the minimum permissions needed. As long as the firewall is configured so that only their public IP can access it, the risk is minimal, although anyone [...]
View Answer
| November 28, 2010 6:47 AM
DMZ, Firewalls, SQL, SQL connectivity, SQL Server
Configure the firewall so that their public IP has access through the firewall. Ensure that the login which they use to connect to the SQL Server instance has only the minimum permissions needed. As long as the firewall is configured so that only their public IP can access it, the risk is minimal, although anyone [...]
View Answer
| November 28, 2010 6:47 AM
DMZ, Firewalls, SQL, SQL connectivity, SQL Server
Crystal Reports database
<b><i> <li><pre><img src=”http://” alt=”" /><a href=”http://”></b></i></li></pre>
View Answer
| November 27, 2010 10:38 AM
Crystal Reports, Crystal Reports Database, Database applications, Database connectivity, Database programming
<b><i> <li><pre><img src=”http://” alt=”" /><a href=”http://”></b></i></li></pre>
View Answer
| November 27, 2010 10:38 AM
Crystal Reports, Crystal Reports Database, Database applications, Database connectivity, Database programming
