Fix this SQL Problem

The following error is being encountered when an update query is executed.


Error Number: 22005

[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Operand type clash: varchar is incompatible with varchar(8000) encrypted with (encryption_type = 'DETERMINISTIC', encryption_algorithm_name = 'AEAD_AES_256_CBC_HMAC_SHA_256', column_encryption_key_name = 'CEK_Auto1', column_encryption_key_database_name = 'Surf_927') collation_name = 'Latin1_General_BIN2'

UPDATE tblData SET [CREDIT CARD NO] = '5353' WHERE ClientID = '31341'


The problem is related to how the query is written and using an Always Encrypted Certificate.

The environment is:

IIS 8 webserver

SQL Express 14

Windows Server 2012 R2

Codeigniter 2.2.6

An ALWAYS ENCRYPTED certificate is being used on the column 'CREDIT CARD NO' and this is what is causing the problem.

The certificate is installed and configured correctly as decryption on a SELECT is fine.

Codeigniter framework is used in the PHP project and ACTIVE Record is used.

I have an idea of what needs to be done to resolve this, but I cannot do it personally. So to be selected for this you will need to explain to me what is causing the problem - this way I know you can fix the problem. Hint: its to do with Parametized

Please no cut and paste of links to your work or just saying you can fix this without demonstrating you have the knowledge.

Beceriler: Codeigniter, Microsoft SQL Server, MySQL, PHP, SQL

Daha fazlasını gör: sql error 18456, sql server error code, sql error meaning, hackerrank sql solutions, sql error code 1, sql server 2016 error codes, sql server error state list, sql error, excellent knowledge windows, fix pagination problem, good knowledge windows, fix apache problem linux, fix sql express, fix ie7 problem home page, imports exceldata sql database vbnet windows base, sql server report windows application, php fix sql xss function, fix card problem paypal, sql server 2005 windows application, fix wimpy problem flash upgrade

İşveren Hakkında:
( 58 değerlendirme ) Gold Coast, Australia

Proje NO: #18869978

Bu iş için 36 freelancer ortalamada $152 teklif veriyor


Hello there, I have gone through with your requirement and I can fix it with perfection. ##Let me know the site URL ? Kindly check PMB Thanks Afsana

$155 AUD in 3 gün içinde
(554 Değerlendirme)

Hello there, Greeting of the day. I can explain this in chat window. Please allow me i will let you know what is the solution of this error please come in chat window Thanks Regards

$200 AUD in 2 gün içinde
(258 Değerlendirme)

Hello sir,, i am ready to work on your project , lets discuss the work in more detail on chat , we have experience and expertise in php and all its frameworks, mysql angularjs, nodejs, html, bootstrap please check the Daha Fazla

$188 AUD in 3 gün içinde
(66 Değerlendirme)

Hi, I am wordpress,PHP programmer having 5 years of experience. I am very good in wordpress,php,mysql,joomla. Recently done these projects [login to view URL]

$88 AUD in 3 gün içinde
(399 Değerlendirme)

Hello sir I hope you are doing well. After reading your offer, this looks like a perfect fit for my skill sets so May I discuss with you for further details about this project?

$155 AUD in 3 gün içinde
(122 Değerlendirme)

Hello. How are you today? I just read your job description and it really attracts me. Your required skills are completely matched with my major skills. I am a MVC expert and I have done so many websites by using CodeI Daha Fazla

$200 AUD in 2 gün içinde
(72 Değerlendirme)

Hello Friend, I have read your project requirements. We are familiar with all required technologies and we have expertise resource to start with your project. We have 4+ year experience in design and development Daha Fazla

$150 AUD in 2 gün içinde
(162 Değerlendirme)

Hi there, Greetings from TechPlus! I've reviewed requirements & ready to Fix this SQL Problem. 5+ Years Expertise in : CMS (Wordpress, Magento, Shopify, OpenCart, Joomla, Drupal, Prestashop) PHP Frameworks ( Daha Fazla

$200 AUD in 3 gün içinde
(81 Değerlendirme)

Hi, I have read your post, and I'll provide a solution for your website. I am having 8+ experience in website design and development with the latest technology. [login to view URL] [login to view URL] h Daha Fazla

$150 AUD in 3 gün içinde
(50 Değerlendirme)

Dear Hiring Manager, I have gone through your job requirements carefully. Your job posting has caught my attention requiring the skills of Codeigniter development and I am keenly considering your job post. I am v Daha Fazla

$150 AUD in 3 gün içinde
(33 Değerlendirme)

Hi Thanks for you good job posting. I read your description carefully and understood. As an web expert. i have strong skills and experiences in web development for 7 years. So i can do your project perfectly and al Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(41 Değerlendirme)

Hello client. I read carefully your proposal. I am a professional web and full stack developer. * No Upfront-Amount needed to Begin your Project * Ready to Start as Immediate, Unlimited Revisions & Proper Testing Daha Fazla

$200 AUD in 3 gün içinde
(4 Değerlendirme)

You can see some website what i just finished: [login to view URL] admin NzZY#h4G!M0BmBFvDHhtx15Z_vrSy [login to view URL] admin IRT!(27ZQA8v3MTbG09A5MeSNF [login to view URL] Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(33 Değerlendirme)

Hello! My name is ZhiXue. I am a database expert! I have rich experience on working mysql. I am interested in you project. If you hire me, I am gonna do my best for your project. I hope you have a dialog with me Daha Fazla

$155 AUD in 3 gün içinde
(11 Değerlendirme)

Hello, Please message me so we can discuss more on it. Please view the profile to see more works of mine. Let's discuss so I can provide you more details about me. Waiting for Your Reply soon. Reg Daha Fazla

$55 AUD in 2 gün içinde
(10 Değerlendirme)

Michael Leboeuf said, “A satisfied customer is the best business strategy of all”. We very well follow it. Our main goal is to provide you 100% service and extra 50% one. Our specialist is focus on web design & fro Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% AUD
(7 Değerlendirme)

Hi, To check the issue you are having in your SQL database , I need to have a code access of your database. SO that I can check n solve. Let me know the details. I am available here for further discuss. reg Daha Fazla

$177 AUD in 3 gün içinde
(8 Değerlendirme)

Greetings!!! I am working in different platforms. (.NET Development, PHP (Core php, Codeigniter, Laravel, Opencart, WordPress), Android Development, Graphic Designing, Front-End Responsive Design) My Vision : To ach Daha Fazla

$155 AUD in 3 gün içinde
(19 Değerlendirme)

Hello sir, we read project description carefully we can do this project..High Quality + Fast Speed = Excellent Result + Business Success, this is my working style. I have gone through your Job post and I can understa Daha Fazla

$97 AUD in 3 gün içinde
(39 Değerlendirme)

Respected Sir/Ma'am, Good day !! I would like to introduce my self , hello I am Gautam and i have a team of 10+ developers those are best in their domain . I will make all the functions which you describe on your jo Daha Fazla

$150 AUD in 3 gün içinde
(9 Değerlendirme)