Runtime Error 2147217900 (80040e14) – Syntex Error (Missing Operator) in query expression
A single quote is missing before the concatenation of cboCompany.Text: “select * from bill where bill.customer_name = <b>’</b>” & cboCompany.Text & “‘”, Cn, adOpenStatic, adLockReadOnly

View Answer   |  May 26, 2009  1:39 PM
Error 80040e14, Microsoft Access, Syntax errors, VB 6, Visual Basic 6, Visual Basic runtime errors

skills
Hi, How are you, Hi friend nothing to worry. anybody face this problem first time join in this field. so, First you can take the seniours friendship and every day share your problems and working styles Group discretions. one thing you can join good networking institution and then every day prepare some liitle bit english [...]

View Answer   |  May 23, 2009  2:06 PM
IT careers

Active Directory restore problem
Hello PCJunkie, Thanks for the immediate reply. The machine2 is identical machine with same hardware configuration. Thanks. <b>Dkk When you built the other DC did you assign the same Administrator password to this new DC as the old one?</b> I am not familiar with the tool MarvinSterling has posted here. You can always give it [...]

View Answer   |  May 23, 2009  6:01 AM
Active Directory, Backup, Domain Controller, Exchange 2003, Volume Shadow Copy Service, VSS Backup, Windows Server 2003

Making two records into one
How about something like this: <pre>SELECT empl_num, SUM((CASE WHEN pay_type = 1 THEN rate ELSE 0 END)) AS reg_Rate, SUM((CASE WHEN pay_type = 3 THEN rate ELSE 0 END)) AS ovr_Rate FROM tblPayrollFlashJobDetail WHERE unitnum = 8 AND salesdate BETWEEN ’01/01/09′ AND ’01/10/09′ AND empl_num = 257 GROUP BY empl_num ORDER BY empl_num</pre> But, why [...]

View Answer   |  May 22, 2009  8:49 PM
CASE statement, SQL Records

Retrieving Records based on Record Selection from another table
In the combo box for the item, put in the Row Source propery a query like this: Select item, description from items where category = forms![orderentry]![category] Also, in the Got Focus event of the item, do: me![item].requery This will cause the combo box to requery if the category has changed If you move the database [...]

View Answer   |  May 22, 2009  2:16 PM
Access Database, Microsoft Access, SQL Database

MSDTC Error with database/Windows Server 2003
Check the folowing registry keys on the server. HKEY_LOCAL_MACHINESoftwareMicrosoftRpcInternet Ports…………………………………..REG_MULTI_SZ…………3000-4000 and 134 PortsInternetAvailable………..REG_SZ……………………..Y UseInternetPorts……………….REG_SZ………………………N You can go to this article for help <a href=”http://msdn.microsoft.com/en-us/library/ms809327.aspx”>MSDN Article</a>

View Answer   |  May 20, 2009  9:24 PM
Database connectivity, Microsoft Distributed Transaction Coordinator, MSDTC, MSDTC error, Windows Server 2003

SQL or VBA code to loop through two columns of data
Use VBA recordset sorted by product code, then loop through this recordset making string needed.

View Answer   |  May 20, 2009  8:26 PM
Microsoft Access, VBA

Access 2007 removing completed data
Dear MeBrainHurts: What you are needing can be made “automatic” if the third visit data has a field called something like “toarchives” and you click on yes (default would be “no”). The query that the form is based on will of course need to include the “toarchives” field and the criteria should be “like no”. [...]

View Answer   |  May 19, 2009  2:48 PM
Access 2007, Microsoft Access

Changing Database Collation
you may use simple alter statement: ALTER DATABASE MyDatabase COLLATE <desired collation> Try it after taking a backup

View Answer   |  May 19, 2009  9:39 AM
Collation, Database collation, SQL Server 2000

How a S/W in c# working in N/W accesses access database from other computer not having access
The application should still work. You may need to configure the ODBC driver and/or functions, but your application will not use Microsoft Access to read the file, it will use the ODBC connection functions that you use in your program.

View Answer   |  May 19, 2009  6:44 AM
Access Database, C#, Microsoft Access, Network connectivity

DB2/400 field to match an Oracle VARCHAR?
Hi, The equivalent VARCHAR for DDS is Keyword VARLEN. DB2/400 uses a 2 bytes prefix to store the real length of data and if you are using a 255 bytes VARCHAR you will define <pre> A KEY 255A <b>VARLEN</b> </pre> It will use 2 additional bytes to store the data on disk. I hope it [...]

View Answer   |  May 18, 2009  11:17 PM
AS/400 interoperability, DB2 connectivity, DB2/400, DDS, Oracle development, Oracle interoperability, Oracle VARCHAR, VARCHAR

Database connectivity ASP.NET using C#
Try this code in your Page_Load function. Create a datagrid with ID myDataGrid. <pre>string connectionString = "Data Source=(local);Initial Catalog=DBName;User ID=User;Password=Password"; SqlConnection myConnection = new SqlConnection(connectionString); SqlDataReader reader = null; SqlCommand myCommand = new SqlCommand("GetData",myConnection); myCommand.CommandType = CommandType.StoredProcedure; try { myConnection.Open(); reader = myCommand.ExecuteReader(); myDataGrid.DataSource = reader; myDataGrid.DataBind(); } catch(Exception ex) { // Catches and logs [...]

View Answer   |  May 8, 2013  9:34 PM
ASP.NET, C, Database connectivity, Web development

Paragraph marks in an ASP blog page.
I solved my own problem. I found that asp recognizes chr(13) as the result of the Enter key and it can be used without quotes. My final line came down to outstr = Replace(Instr, strfind, strreplace) with strfind= chr(13) and strreplace = “<br />”, The blog output now accepts paragraph breaks made be the Enter [...]

View Answer   |  May 18, 2009  6:28 PM
ASP, Microsoft Access

AS400 RPG – last three digits of microseconds always zero!
Hi, It’s a RPGILE limitation and it’s always zero. Do you really need this 3 digits? I think you can get it with APIs or C functions. Regards, Wilson ——————————– <pre> C/exec sql C+ set :test = current_timestamp C/end-exec </pre> or in /FREE <pre> exec sql set :test = current_timestamp; </pre> will set the program [...]

View Answer   |  May 18, 2009  3:25 PM
AS/400, ILE RPG, RPG, Timestamp

Execute command in SQL
At first look, a comma is missing before ‘Amt’: set @cmd= N’insert into TmpDues ( PatNo, BillDate, ReceiptNo, PayMode<b>,</b>Amt) But I think it would be easier if you tell us what error message you are getting. Try printing the contents of @Cmd before executing it, so you can have a look at the actual SQL [...]

View Answer   |  May 16, 2009  3:39 AM
SQL, SQL error messages, SQL queries

Errors creating database with SQL Server 2008 I&M Training Manual
You’ll need to create the folder C:Test for this script to work.

View Answer   |  May 16, 2009  3:38 AM
CREATE DATABASE statement, SQL Server 2008, SQL Server 2008 error messages, SQL Server 2008 training, SQL Server administration

SQL Studio Express scheduled backup
SQL Server Express Edition doesn’t include a scheduling agent. There is an<a href=”http://standalonesqlagent.codeplex.com/”> open source project</a> which fills this cap.

View Answer   |  May 16, 2009  3:36 AM
Backup Scheduler, SQL, SQL Backup, SQL job scheduler

Flat file to PF conversion
Use Cpyf with fmtOpt *NOCHK Phil ///////////////////// Assuming that the flat file is 1. In a library on your AS/400 2. Fixed length fields then 1. Create and compile the DDS which represents the data as fields if first 30 are address, next 20 are city, next 10 are zip create those fields at this [...]

View Answer   |  May 15, 2009  7:00 PM
DB2 Physical File, DB2/400, DB2/400 primary files, Flat files, Physical File

How to get delete history from schema
You could do this with database triggers. The syntax will be different depending on the database you are using, which you didn’t specify. —————————-

View Answer   |  May 14, 2009  3:15 PM
Database programming, Database schema

Free Chapter – Tuning database applications for performance
Enjoy the chapter and be sure to check out the related database development resources listed at the bottom of the download page. Voice your feedback on this chapter or let us know of other books you’d like to see featured on the IT Bookworm Blog by leaving a comment. Thanks.

View Answer   |  May 14, 2009  12:27 PM
Data access, Database applications, Database performance, Database scalability, Free Chapters, John Goodson, Prentice Hall, Robert A. Steward