Question about NRS Computers & Internet

Open Question

The error message I am getting arises when I try to receive items into the store. The inventory levels are presently 0 as I have not received any items however if I do an item issue the value goes into the negative value!!!! The error message is: "Unexpected error: Error converting data type varchar to datetime. (Number: -2147213390, Context: Transaction Update, Source: Microsoft OLE DB Provider for SQL Server)"

Posted by on

Ad

2 Suggested Answers

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad
efs_perpends
  • 1996 Answers

SOURCE: Microsoft OLE DB Provider for ODBC Drivers error '80040e31'

There are several things that could cause this to appear....Try this link: http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/cccea79b-f7c8-4fd4-85b8-7182d92d8f91/
If that doesn't answer your query, please consult this list and apply the fix that most closely relates to your particular circumstance...
http://search.microsoft.com/results.aspx?mkt=en-US&setlang=en-US&q=Microsoft+OLE+DB+Provider+for+ODBC+Drivers+error+%2780040e31%2
I hope that helps to clear it up!

Posted on Mar 27, 2009

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

The odometer is not working on my 1999 navigator. It just says 0. What could be the problem?


Odometer The instrument cluster receives odometer rolling count status from the PCM-engine computer and stores the mileage in non-volatile memory (NVM). When the instrument cluster fails to receive the odometer rolling count status for more than two seconds, the odometer display will show dashes.

HEC Dealer Test Mode
To enter the HEC Dealer Test Mode, depress and hold the instrument cluster SELECT/RESET button and then turn the ignition switch to the RUN position. Continue pressing the SELECT/RESET button (5 seconds) until tESt is displayed in the odometer. The SELECT/RESET button must be released within 3 seconds of the odometer displaying tESt to begin the dealer test mode. Depress the SELECT/RESET button to advance through the following steps until dtc is displayed. Depressing the SELECT/RESET button will display any continuous DTCs stored before proceeding to the next step.

All segments illuminated Illuminates all odometer segments. If any odometer segment is inoperative, INSTALL a new instrument cluster; REFER to Instrument Cluster .
Odometer Display Description GAGE Activates gauge sweep of all gauges, then displays present gauge values. Also carries out the checksum tests on ROM and EE. If the gauge sweep is inoperative, INSTALL a new instrument cluster; REFER to Instrument Cluster . All segments illuminated Illuminates all odometer segments. If any odometer segment is inoperative, INSTALL a new instrument cluster; REFER to Instrument Cluster . bulb Illuminates all micro-controlled lamps and LEDs (low oil pressure/high coolant temperature, low fuel, service engine soon, brake, low range). INSTALL a new bulb or LED as necessary. r Returns to normal operation of all micro-controlled lamps and LEDs and displays hexadecimal value for ROM level (used when requesting assistance from the hotline). If alternating flashes of FAIL and ROM level are displayed, INSTALL a new instrument cluster; refer to Instrument Cluster . EE Displays hexadecimal value for EE level (used when requesting assistance from the hotline). If alternating flashes of FAIL and EE level are displayed, INSTALL a new instrument cluster; refer to Instrument Cluster . dt Displays hexadecimal coding of final manufacturing test date (used when requesting assistance from the hotline). dtc Displays continuous DTCs. Pressing the SELECT/RESET button will display any DTCs stored before proceeding to the next step. enG Displays the English speed in mph. Speedometer will indicate present speed within tolerances. Display will show 0 if input is not received, if input received is invalid for one second or more, or if speed is 0. m Displays the English speed data (mph) received from the PCM via SCP Network. Displays the metric speed in kph. Speedometer will indicate present speed within tolerances. Display will show 0 if input is not received, if input received is invalid for one second or more, or if speed is 0. tAc Displays the tachometer data received from the PCM via the SCP Network. Tachometer will indicate present speed within tolerances. Display will show 0 if input is not received, if input received is invalid for one second or more, or if engine rpm is 0. FUEL Displays the actual A/D fuel level. The fuel gauge will display a filtered fuel level value. This filter will keep the pointer from moving suddenly or erratically. If the value displayed is between 0 and 20, the circuit is shorted. GO to Pinpoint Test D .
  • 255=open send +/-0
  • 232=Full stop +/-10
  • 215=Full mark +/-10
  • 178=3/4 mark +/-8
  • 138=1/2 mark +/-7
  • 93=1/4 mark +/-5
  • 41=E mark +/-4
  • 54="LOW FUEL" (0-59)
  • 0-18=short (0-20 max.)
OIL Displays the code (0-255) for the oil pressure switch input to the HEC. Displays the oil pressure reading input to the HEC. Oil pressure gauge will indicate present oil pressure. Normal oil pressure (greater than 6 psi) will display a value between 000 and 176. A low oil pressure (less than 6 psi) or an inoperative engine oil pressure switch will display a value greater than 176. dEGC Display of engine temperature in Degrees C input from cylinder head temperature sensor. If the value displayed is -40C, the SCP message for engine temperature has not been received for more than 5 seconds. GO to Pinpoint Test E .
  • 49 C="C" mark.
  • 60 C=Normal band start.
  • 120 C=Normal band end.
  • 119 C=Temperature warning indicator ON.
  • "-40" C=No SCP Message for 5 sec.
br Displays the brake fluid level input to the HEC. bAtt Displays the code (0-255) battery voltage input to the HEC. Battery voltage gauge will indicate present battery voltage.
  • 93-102=6.9-9.1 volts (Low voltage)
  • 115-124=8.5-10.7 volts (Norm band start)
  • 215-225=15.8-18 volts (Norm band end)
  • 230-241=16.9-19.1 volts (High voltage)
rhEo Displays the present hexadecimal value for the instrument cluster backlighting pulse width modulated (PWM) input to the HEC (used when requesting assistance from the hotline). rhi
rhS
rho PWM input duty cycle.
SCP hexadecimal dimming step (used when requesting assistance from the hotline).
Output driver counts in hexadecimal format (used when requesting assistance from the hotline). Cr Displays the present RUN/START sense input. Display will show -h with the ignition switch in the START position and -L with the ignition switch in the RUN position. ALtF Displays 8-bit hexadecimal value for alternate fuel level. Display will show a value between 00 and FF if the message is received. PA-PE7 Not used. GAGE Repeats test display cycle.
Turn the ignition switch to the OFF position or press and hold the SELECT/RESET button for 3 or more seconds and release to exit HEC Dealer Test Mode. If no DTCs related to the concern are retrieved, proceed to the Symptom Chart to continue diagnostics.

Mar 12, 2018 | 1999 Lincoln Navigator

2 Answers

Can't send emails in Outlook Express


Save yourself alot of headaches and use a web-mail service like Gmail.

Oct 27, 2014 | Microsoft Outlook Express

1 Answer

Failed to load the print preview or failed to print.


You need to run the Wasp software under an Administrative account or Right click the program Icon and select run as administrator (only need to do this 1 time, not over and over again). Once the program loads, set the label printer again by clicking file at the top left and selecting Setup Label Printer. Select your label printer. Now try printing the labels again.

Jul 19, 2012 | Wasp Technologies Inventory Control...

1 Answer

Can you give sample source code of visual foxpro program using mySql as database flatform


Create a connection: lcStringCnxRemoto = "DRIVER={MySQL ODBC 3.51 Driver};" + ; "SERVER=200.1.1.1;" + ; "PORT=3333;" + ; "UID=booking;" + ; "PWD=booking;" + ; "DATABASE=booking;" + ; "OPTIONS=131329;" lcStringCnxLocal = "DRIVER={MySQL ODBC 3.51 Driver};" + ; "SERVER=localhost;" + ; "UID=root;" + ; "PWD=clave;" + ; "DATABASE=booking;" + ; "OPTIONS=131329;" SQLSETPROP(0,"DispLogin" , 3 ) lnHandle = SQLSTRINGCONNECT(lcStringCnxLocal)
Accesing data:
SQLSETPROP(0,"DispLogin" , 3 ) lnHandle = SQLSTRINGCONNECT(lcStringCnxLocal) IF lnHandle > 0 cmd = SQLEXEC(lnHandle,"select QuantityRooms from roomtype","cur_roomtype") IF cmd > 0 BROWSE ELSE AERROR(laErr) MESSAGEBOX("Can't connect to mySQL. Error: " + CHR(13) + laErr[2]) ENDIF USE IN cur_roomtype SQLDISCONNECT(lnHandle) ELSE AERROR(laErr) MESSAGEBOX("Can't connect to mySQL. Error: " + CHR(13) + laErr[2])
ENDIF
Creating complex sentences:
TEXT TO lcSQLcommand NOSHOW SELECT Inventory.inventoryid, Inventory.date, Inventory.roomtypeid, Inventory.sold, Roomtype.descrip, Roomtype.rooms FROM inventory Inventory INNER JOIN roomtype Roomtype ON Inventory.roomtypeid = Roomtype.roomTypeID ORDER BY Inventory.date DESC ENDTEXT cmd = SQLEXEC(lnHandle,lcSQLcommand)
Passing parameters to a query:
nValor = 12 cmd = SQLEXEC(lnHandle,"select QuantityRooms from roomtype where roomtypeid = ?nValor","cur_roomtype")
Calling a Stored Procedure:
SQLEXEC(lnHandle, "call myStoreProcedure(@param1)")
GOOD LUCK!

Mar 17, 2011 | Microsoft Visual FoxPro Professional...

1 Answer

Volume really low, even when turned right up


So the speakers and the individual amp channels work so that lets out the obvious big hardware items.

This is starting to sound like an obscure setting was set or changed by mistake.

It would be nice to figure out what that is/was in case it happens again but you may eventually have to resort to resetting the receiver to factory defaults and start over by holding the1/0 button for 5 seconds.

Mar 04, 2010 | Sony STR-DE875 Receiver

1 Answer

My hp4225 do not sent or receive fax messages, error 388*


hiii
well this error generally arises when there is too much of disturbance in the line.It may going away with time.And if it doesn't then u must retry the fax reception at a different time when telephone line conditions have improved. Call the telephone provider if line conditions fail to improve.

Sep 03, 2009 | HP OfficeJet 4255 All-In-One InkJet...

2 Answers

Can send but not receive faxes


Is that a USB connected Lexmark unit?

Apr 24, 2017 | Lexmark X6570 InkJet Printer

2 Answers

Mail sending problem in outlook express 2003


Tried to take backup of messages was not able to copy the dbx files
- Rename folders.dbx
- Was able to send/receive messages without any error
May not able to retreive some messages in sent items, deleted items folder

>lets create new identiy
http://support.microsoft.com/kb/209169

Dec 06, 2008 | Microsoft Office Outlook 2003 for PC

1 Answer

Fingerprint reader issue


after a number of soft resets the problem seems to go away.... for no apparent reason. However the problem then reappears for no apparent reason.

Sep 14, 2005 | HP iPAQ H5550 Pocket PC

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

121 people viewed this question

Ask a Question

Usually answered in minutes!

Top NRS Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18425 Answers

Alun Cox

Level 3 Expert

2678 Answers

David Payne
David Payne

Level 3 Expert

14162 Answers

Are you a NRS Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...