Help running a CmdEXEC from the SQL Server
Make sure the path to your script exists and that the account being used has the necessary privileges to access it. Also, the script itself might not be seen as an executable by the system. For example, if you want to run a vbscript, the step command should be: <pre><b>cscript </b>c:pathscript.vbs</pre> and not just: <pre>c:pathscript.vbs</pre> [...]
View Answer
| November 17, 2010 12:24 AM
CMD, SQL Server, VB script, Visual Basic Script
Make sure the path to your script exists and that the account being used has the necessary privileges to access it. Also, the script itself might not be seen as an executable by the system. For example, if you want to run a vbscript, the step command should be: <pre><b>cscript </b>c:pathscript.vbs</pre> and not just: <pre>c:pathscript.vbs</pre> [...]
View Answer
| November 17, 2010 12:24 AM
CMD, SQL Server, VB script, Visual Basic Script
Dcom error on Windows XP SP3
<a href=”http://www.updatexp.com/dcom-windows-xp.html”>Here is some information </a>you may find helpful.
View Answer
| November 16, 2010 6:12 PM
DCOM, Windows errors, Windows XP Error Messages, Windows XP SP3
<a href=”http://www.updatexp.com/dcom-windows-xp.html”>Here is some information </a>you may find helpful.
View Answer
| November 16, 2010 6:12 PM
DCOM, Windows errors, Windows XP Error Messages, Windows XP SP3
Find Due Date From X months in Access 2007
You could use the <a href=”http://www.techonthenet.com/access/functions/date/dateadd.php”>DateAdd Function </a> <pre>= DateAdd(“m”,[recurrence],[Date completed])</pre> If you want to update it with a SQL statement, it should be something like this: <pre>UPDATE your_table SET [due date] = DateAdd(“m”,[recurrence],[Date completed]) WHERE <conditions></pre>
View Answer
| November 16, 2010 5:59 PM
Access 2007, Access Database, Access Database Design, Access Database Format
You could use the <a href=”http://www.techonthenet.com/access/functions/date/dateadd.php”>DateAdd Function </a> <pre>= DateAdd(“m”,[recurrence],[Date completed])</pre> If you want to update it with a SQL statement, it should be something like this: <pre>UPDATE your_table SET [due date] = DateAdd(“m”,[recurrence],[Date completed]) WHERE <conditions></pre>
View Answer
| November 16, 2010 5:59 PM
Access 2007, Access Database, Access Database Design, Access Database Format
Using .net gridview control with AS/400
A few things to check… Look into the parameters for your ODBC connection. In particular, the Library List and Naming Convention. If naming convention is *SYS rather than *SQL and you are separating the library and file with a period, that could be a problem. Likewise, if the library list is not properly set (or [...]
View Answer
| November 15, 2010 8:09 PM
.NET 2.0, AS/400, AS/400 Parameters, GridView, GridView Control, SQL Query
A few things to check… Look into the parameters for your ODBC connection. In particular, the Library List and Naming Convention. If naming convention is *SYS rather than *SQL and you are separating the library and file with a period, that could be a problem. Likewise, if the library list is not properly set (or [...]
View Answer
| November 15, 2010 8:09 PM
.NET 2.0, AS/400, AS/400 Parameters, GridView, GridView Control, SQL Query
Error Message ORA-00903 in SQL table
ORA-00903 IS “invalid table name”. Maybe you are receiving an ORA-00904, which means “invalid column name”. If tourid is a defined attribute in a table called Tour, then you can only use it when querying that table.
View Answer
| November 15, 2010 5:19 PM
ORA-00903, SQL, SQL Plus, SQL tables
ORA-00903 IS “invalid table name”. Maybe you are receiving an ORA-00904, which means “invalid column name”. If tourid is a defined attribute in a table called Tour, then you can only use it when querying that table.
View Answer
| November 15, 2010 5:19 PM
ORA-00903, SQL, SQL Plus, SQL tables
VBA Excel dates
Try assigning the date this way: varDate = <b>”</b>13/10/2010<b>”</b> ———–
View Answer
| November 15, 2010 5:12 PM
Excel workbooks, VBA, Visual Basic, Visual Basic Error Messages
Try assigning the date this way: varDate = <b>”</b>13/10/2010<b>”</b> ———–
View Answer
| November 15, 2010 5:12 PM
Excel workbooks, VBA, Visual Basic, Visual Basic Error Messages
VBA Excel 2003 Copy and Paste
Record macros to get the proper copy and paste code Set variables to the names of the workbook Workbooks.Open Filename:=strWorkbk1 Range(“A4:AF” & intLastRow & “”).Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Workbooks.Open Filename:=strWorkbk2 Range(“A65536″).End(xlUp).Select – this will get the last cell in column A with data activecell.offset(1,0).select “paste code” here
View Answer
| November 15, 2010 3:58 PM
Excel 2003, Excel VBA, VBA, VBA EXCEL 2003
Record macros to get the proper copy and paste code Set variables to the names of the workbook Workbooks.Open Filename:=strWorkbk1 Range(“A4:AF” & intLastRow & “”).Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Workbooks.Open Filename:=strWorkbk2 Range(“A65536″).End(xlUp).Select – this will get the last cell in column A with data activecell.offset(1,0).select “paste code” here
View Answer
| November 15, 2010 3:58 PM
Excel 2003, Excel VBA, VBA, VBA EXCEL 2003
.mdf file backup in Visual Studio
When you published the application the database would have been attached to the SQL Server instance. Once the database file has been attached to the instance you’ll need to use the SQL Server’s BACKUP DATABASE command as the file is attached to the SQL Server process and can’t be touched while the SQL Server is [...]
View Answer
| November 15, 2010 1:10 PM
.MDF files, Backup, C# .NET, MDF, Visual Studio
When you published the application the database would have been attached to the SQL Server instance. Once the database file has been attached to the instance you’ll need to use the SQL Server’s BACKUP DATABASE command as the file is attached to the SQL Server process and can’t be touched while the SQL Server is [...]
View Answer
| November 15, 2010 1:10 PM
.MDF files, Backup, C# .NET, MDF, Visual Studio
SQL SERVER SAN Setup
Typically people will install the OS and the SQL Server binaries (the .exe files) on local disk and not SAN disk. SAN disks are a lot more expensive than local disks so you usually don’t want to waste SAN disk for the OS.
View Answer
| November 15, 2010 12:57 PM
SAN, SQL, SQL 2005, SQL Server, SQL Server 2005, SQL Server 2005 (32-bit)
Typically people will install the OS and the SQL Server binaries (the .exe files) on local disk and not SAN disk. SAN disks are a lot more expensive than local disks so you usually don’t want to waste SAN disk for the OS.
View Answer
| November 15, 2010 12:57 PM
SAN, SQL, SQL 2005, SQL Server, SQL Server 2005, SQL Server 2005 (32-bit)
How to update data for one column in MS SQL?
You are going to need to manually go in and edit each row manually. There isn’t a programmatic way to do this.
View Answer
| November 15, 2010 12:49 PM
SQL, SQL Database, SQL Server, SQL tables
You are going to need to manually go in and edit each row manually. There isn’t a programmatic way to do this.
View Answer
| November 15, 2010 12:49 PM
SQL, SQL Database, SQL Server, SQL tables
How to add an article in transactional replication in sql server 2005?
The easiest way to add an article would be to edit the publication within the SSMS and add the article there. This will cause the subscribers to become invalid and will require that you push a new snapshot from the publisher to the subscribers so that the new table is added. The only requirement to [...]
View Answer
| November 15, 2010 12:45 PM
DBA, SQL, SQL Server, SQL Server 2005, Transactional replication software
The easiest way to add an article would be to edit the publication within the SSMS and add the article there. This will cause the subscribers to become invalid and will require that you push a new snapshot from the publisher to the subscribers so that the new table is added. The only requirement to [...]
View Answer
| November 15, 2010 12:45 PM
DBA, SQL, SQL Server, SQL Server 2005, Transactional replication software
Cookies getting expired.
To handle cookies in Safari, u may proceed as given : To change cookie preferences in safari : 1. Click Safari > Preferences 2. Click Security. 3. In the Accept Cookies section, choose how you want Safari to handle cookies. Click the Help (question mark) button to see an explanation of the options. 4. If [...]
View Answer
| November 15, 2010 5:13 AM
ASP, Cookies, safari
To handle cookies in Safari, u may proceed as given : To change cookie preferences in safari : 1. Click Safari > Preferences 2. Click Security. 3. In the Accept Cookies section, choose how you want Safari to handle cookies. Click the Help (question mark) button to see an explanation of the options. 4. If [...]
View Answer
| November 15, 2010 5:13 AM
ASP, Cookies, safari
How can I tell if a file is ASCII or EBCDIC in iSeries?
As you start off with “I have to create a file to send” I would say the encoding of the file is entirely up to you. You could use ASCII, EBCDIC, Unicode, etc. If you’re creating the file on an i then EBCDIC will generally be the easiest for you (EBCDIC is the default if [...]
View Answer
| November 14, 2010 2:03 PM
ASCII, ASCII File, EBCDIC, File Types, iSeries, iSeries File Members
As you start off with “I have to create a file to send” I would say the encoding of the file is entirely up to you. You could use ASCII, EBCDIC, Unicode, etc. If you’re creating the file on an i then EBCDIC will generally be the easiest for you (EBCDIC is the default if [...]
View Answer
| November 14, 2010 2:03 PM
ASCII, ASCII File, EBCDIC, File Types, iSeries, iSeries File Members
Filename from SQL 2005 Query
Are you using sqlcmd to execute the query ? Assuming so, here’s a way to do it ( though I’m sure there must be a cleaner way to do it): <pre>sqlcmd -U username -P password -S SERVERINSTANCE -Q “SELECT TOP(1) week_ending_date FROM your_table” -o <b>date.txt</b> -h -1 set /p <b>var</b>= < <b>date.txt</b> set <b>file</b>=NPQ_Asst_<b>%var%</b>.csv sqlcmd [...]
View Answer
| November 12, 2010 7:15 PM
Batch files, SQL 2005, SQL Query, SQL Server, SQL Server 2005
Are you using sqlcmd to execute the query ? Assuming so, here’s a way to do it ( though I’m sure there must be a cleaner way to do it): <pre>sqlcmd -U username -P password -S SERVERINSTANCE -Q “SELECT TOP(1) week_ending_date FROM your_table” -o <b>date.txt</b> -h -1 set /p <b>var</b>= < <b>date.txt</b> set <b>file</b>=NPQ_Asst_<b>%var%</b>.csv sqlcmd [...]
View Answer
| November 12, 2010 7:15 PM
Batch files, SQL 2005, SQL Query, SQL Server, SQL Server 2005
Free IT Book: Microsoft Windows 7 Administrator’s Reference
Thanks, AndreaF for your answer to <a href=”http://itknowledgeexchange.techtarget.com/itanswers/javascript-error-through-a-vpn-connection/”>JavaScript Error through a VPN connection</a>! You have until Monday, November 15th to qualify! Thanks to all who have participated thus far. - Melanie
View Answer
| November 12, 2010 2:48 PM
Cisco, Cisco 3750, Cisco Firewall, Exchange 2003, Firewalls, Giveaways, IT Books, JavaScript, Javascript error, SQL 2008, SQL Database, VPN
Thanks, AndreaF for your answer to <a href=”http://itknowledgeexchange.techtarget.com/itanswers/javascript-error-through-a-vpn-connection/”>JavaScript Error through a VPN connection</a>! You have until Monday, November 15th to qualify! Thanks to all who have participated thus far. - Melanie
View Answer
| November 12, 2010 2:48 PM
Cisco, Cisco 3750, Cisco Firewall, Exchange 2003, Firewalls, Giveaways, IT Books, JavaScript, Javascript error, SQL 2008, SQL Database, VPN
SQL Agent in SQL environment?
“SQL Server Agent is a Microsoft Windows service that executes scheduled administrative tasks, which are called jobs.” <a href=”http://msdn.microsoft.com/en-us/library/ms189237.aspx”>Read more on msdn</a>
View Answer
| November 12, 2010 2:28 PM
Agents, SQL, SQL Server, SQL Server Agent
“SQL Server Agent is a Microsoft Windows service that executes scheduled administrative tasks, which are called jobs.” <a href=”http://msdn.microsoft.com/en-us/library/ms189237.aspx”>Read more on msdn</a>
View Answer
| November 12, 2010 2:28 PM
Agents, SQL, SQL Server, SQL Server Agent
Skills for Software Tester for 1 year Experience
It really depends on what you are looking for. If you are at an entry level position then you maybe expected to know little. But its still important to understand basic testing methodologies. You have to know testing basics for sure. So I would say brush up your skills on that. Pick a good testing [...]
View Answer
| November 12, 2010 2:27 PM
Software testers, Software testing, Software testing fundamentals, Software testing jobs
It really depends on what you are looking for. If you are at an entry level position then you maybe expected to know little. But its still important to understand basic testing methodologies. You have to know testing basics for sure. So I would say brush up your skills on that. Pick a good testing [...]
View Answer
| November 12, 2010 2:27 PM
Software testers, Software testing, Software testing fundamentals, Software testing jobs
Webmail linked to Yahoo Mail
There is a possible way try out this : If u use Fire Fox browser, then download WebMail Notifier for firefox. It is an Add-In which helps to notify u. But it is tested on FF only. Open FF > Tools > Add Ons and see whether this included or not. and restart the FF [...]
View Answer
| November 12, 2010 1:21 PM
Email management, Email management systems, Webmail, Yahoo, Yahoo Mail
There is a possible way try out this : If u use Fire Fox browser, then download WebMail Notifier for firefox. It is an Add-In which helps to notify u. But it is tested on FF only. Open FF > Tools > Add Ons and see whether this included or not. and restart the FF [...]
View Answer
| November 12, 2010 1:21 PM
Email management, Email management systems, Webmail, Yahoo, Yahoo Mail
Word 2003/2007 VBScript fails in 2010 (background printing) – help!
I have many close familiars, who use MS Word, but once I by chance observed a tool, which was interested for me. And to my great surprise the software resolved my old issues simply just like would help in this problem to my mind – <a href=”http://www.recoverytoolbox.com/word.html”>repair word</a>.
View Answer
| November 12, 2010 4:36 AM
PDF Files, RTF, Scripting, VBScript, Visual Basic Script
I have many close familiars, who use MS Word, but once I by chance observed a tool, which was interested for me. And to my great surprise the software resolved my old issues simply just like would help in this problem to my mind – <a href=”http://www.recoverytoolbox.com/word.html”>repair word</a>.
View Answer
| November 12, 2010 4:36 AM
PDF Files, RTF, Scripting, VBScript, Visual Basic Script
Create a combo box or dialog list to retrieve other combo box values
Assuming you have the values you want to fill in a view named “MyView1″, and the value you want to fill is in column number 2, what you will code is: @DbColumn(“”:”NoCache”;”":”";”MyView1″;2) Again make sure to select “Use Formula of Choices”
View Answer
| November 11, 2010 8:30 PM
ComboBox, Domino Designer, Lotus Notes 7.x
Assuming you have the values you want to fill in a view named “MyView1″, and the value you want to fill is in column number 2, what you will code is: @DbColumn(“”:”NoCache”;”":”";”MyView1″;2) Again make sure to select “Use Formula of Choices”
View Answer
| November 11, 2010 8:30 PM
ComboBox, Domino Designer, Lotus Notes 7.x
