BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 05-29-2007, 09:15 AM   #1 (permalink)
Knows Where the Search Button Is
 
Lokean's Avatar
 
Join Date: Feb 2006
Location: Atlanta
Model: 8100
Carrier: Tmobile
Posts: 36
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default SQL Native Error 107

Please Login to Remove!

I recently logged into my BES server to change a users phone to a new one. The user was able to run through enterprise activation by connecting over his usb and using his key store password. Emails are delivered just fine, but the user cannot reply to them, although he could send out a new email to the same person. When I checked the manager log I found the following errors:

[20000] (05/29 09:55:07.084):{0x1EC0} [ODBCRecord::DoSetValue] SQL error: [0x80040E14 The column prefix 'a' does not match with a table name or alias name used in the query.] Source: [Microsoft OLE DB Provider for SQL Server] SQL State: [42000] NativeError: [107]

[20000] (05/29 09:55:07.084):{0x1EC0} [ODBCRecord::DoSetValue] SQL error: [0x80040E14 The column prefix 'a' does not match with a table name or alias name used in the query.] Source: [Microsoft OLE DB Provider for SQL Server] SQL State: [42000] NativeError: [107]

[20000] (05/29 09:55:07.084):{0x1EC0} [ODBCRecord::DoSetValue] COM Error 0x80040E14 - IDispatch error #3092 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "The column prefix 'a' does not match with a table name or alias name used in the query."

Then I noticed that even though everyone else's bb's were working fine the user screen shows them as all being last updated in April.

Anyone have any ideas?
Offline  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

(1PCS) M95640-WMN6T IC EEPROM 64KBIT 10MHZ 8SOIC 95640 M95640
$3.42
(1PCS) M95640-WMN6T IC EEPROM 64KBIT 10MHZ 8SOIC 95640 M95640 picture(5PCS) M34C02-WDW6T IC EEPROM 2KBIT 400KHZ 8TSSOP 34C02 M34C02
$7.43
(5PCS) M34C02-WDW6T IC EEPROM 2KBIT 400KHZ 8TSSOP 34C02 M34C02 picture(5PCS) M24C64-WBN6P IC EEPROM 64KBIT 400KHZ 8DIP 24C64 M24C64
$9.0
(5PCS) M24C64-WBN6P IC EEPROM 64KBIT 400KHZ 8DIP 24C64 M24C64 picture(5PCS) M24C16-WBN6P IC EEPROM 16KBIT 400KHZ 8DIP 24C16 M24C16
$6.4
(5PCS) M24C16-WBN6P IC EEPROM 16KBIT 400KHZ 8DIP 24C16 M24C16 picture(5PCS) M24C32-WMN6P IC EEPROM 32KBIT 400KHZ 8SOIC 24C32 M24C32
$9.3
(5PCS) M24C32-WMN6P IC EEPROM 32KBIT 400KHZ 8SOIC 24C32 M24C32 picture






Copyright 2004-2016 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.