Fix this SQL Problem

$30-250 AUD

Lezárt

Kiadva ekkor:

körülbelül 5 évvel ezelőtt

$30-250 AUD

Teljesítéskor fizetve

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.

Projektazonosító: 18869978

A projektről

30 ajánlat

Távolról teljesíthető projekt

Aktiválva: 5 évvel ezelőtt

Szeretne pénzt keresni?

E-mail cím

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet

Kapja meg fizetését a munkáért

Vázolja ajánlatát

Ingyen regisztrálhat és adhat árajánlatot munkákra

30 szabadúszó adott átlagosan $145 AUD összegű árajánlatot erre a munkára

@fastworkontime1

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 3 napon belül

5,0

(655 értékelés)

8,5

@dinotech

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 2 napon belül

4,8

(286 értékelés)

8,4

@gamdurbhullar

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 3 napon belül

4,9

(169 értékelés)

7,2

@ObjectCode1

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. regards

$177 AUD 3 napon belül

4,9

(18 értékelés)

5,9

@mdramindz

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. Regards, Ramin

$55 AUD 2 napon belül

4,9

(15 értékelés)

4,9

@creativemandy

Hi, I have read your given following issues and As Codeigniter Expert I can fix this issue without demonstrating and I want to check the issue in the website that encountered so please provide me a full access of your website so that i can tell the cause & way of fix this issue. Let me know when are you available to take this conversation to next level. Assure standard work within your cost & time. Waiting for your valuable response. Thanks

$200 AUD 3 napon belül

4,9

(13 értékelés)

5,1

@dilshadbukhari

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 achieve 100% Clients Satisfaction with High Quality on time. Currently, I am offering following services on FL; - Web Development in the following languages, Frameworks and CMS Bootstrap, Custom Responsive(Media Queries), Javascript, Jquery, Ajax, PHP, Codeigniter, Laravel, Opencart, Wordpress, ASP.NET - API Integration. (Social, Payment Gateways etc..) -Mobile apps development (Android) - Troubleshooting and bug fix

$155 AUD 3 napon belül

4,9

(28 értékelés)

4,8

@baxianupam

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 & front/back-end development using React, Angular, CSS, PHP, HTML, jQuery, JavaScript, CMS(WordPress, Laravel) Our Skills: ★PHP Framework : PHP/Mysql, CodeIgniter, Laravel and YII ★ Shopify, Woocommerce, E-commerce, Wordpress, Wix, Squarespace ★ Front End Using ReactJS, AngularJS, Node JS, Ruby on Rails. ...... ★ Laravel, PHP, Html5, Django, Css, Javascript, JQuery. ★ Magento, Bigcommerce, OS Commerce ★ SEO, Internet Marketing, Google Analytics, Digital Marketing, Google Adwords. ★ Mobile App: Android IOS. Why Choose Us: ★ Prepare Project Plan and Development. ★ Design revocations ★ Responsive design computable for web and phones ★ Error free & clean codes. ★ SEO Friendly. ★ Support: 24X7. ★ Deployment support for 3 months Free of cost (Bug fixing).

$70 AUD 1 napon belül

5,0

(10 értékelés)

4,1

@krupa2806

Dear sir/madam, I have 4 years of experience in mobile and web development & design with wide skill. I am skilled in mobile application development as well as web application development. Qualifications and experience include: ---------------------------------------------------------- -Mobile application development(Android , React Native) -Web development and web services -Managed and maintained php backend for dynamic database -Skilled in CSS/HTML, jQyery, Node.js, Angular.js, Linux and unix platform -Experience with all designing tool such as Microsoft project and Apache -Experienced in PHP framework such as Laravel, Codeigniter, Magento, Cakephp. Thank you for your time and consideration, I look forward to hearing from you. Sincerely, Krupali Mangukiya

$100 AUD 3 napon belül

4,8

(19 értékelés)

3,9

@techobrie

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 understand your job requirement thoroughly. I have a total of 15 years of experience in Web Designing and Development and had completed a number of projects with some great graphics and User Interface so far. I have all the required skills and experience you need for the above Job. I have strong command over: * WordPress, PHP, Wordpress themeing, Plugin Development * Android and IOS all kind of mobile apps development *Responsive theme Design * HTML5, CSS3 , Jquery, Bootsrtap, Git, * Widget Development * Other CMS: Magento, Joomla, Expression Engine, Drupal etc. * I’m honest & trustworthy, dependable & fast learner. * I’ve over 7 years experience in Wordpress Website designing/development. * I am available 40 hours a week for your job. You can be assured of a quality communication and the quality of the work provided from my end. I’m looking forward to hearing from you soon. Thank you for considering my cover letter.

$97 AUD 3 napon belül

3,5

(48 értékelés)

5,2

@jiteshparwal93

Hi, This problem is mostly due to one of following reasons: 1. Since your clientId is encrypted, but you aren't decrypting it in query. For this you need to decrypt it in query using SQL function. 2. There may be code page change between columns, which can be resolved using collate property. Let's connect and I can give solution to this problem in an hour.

$111 AUD 1 napon belül

5,0

(3 értékelés)

3,6

@baphpwordress

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 job post WE can solve your error . We are well versed in Codeigniter, Microsoft SQL Server, MySQL, PHP, SQL Please revert me on so that we can discuss in brief . thanks

$150 AUD 3 napon belül

4,4

(12 értékelés)

3,8

@DataOnMatrix

Hi, It seems that you are trying to perform CRUD on encrypted columns, right? In this case, the data must be manipulated using a parameterized query, and you cannot be done within SSMS. I have gone through the description I extensive have experience with Codeignitor, Microsoft SQL Server, MySQL, SQL and can resolve this issue successfully and ready to initiate right away. If you want to collaborate with me lets discuss it in more details over chat. Looking further to make a long-term business relationship Best, Sajal

$277 AUD 3 napon belül

5,0

(3 értékelés)

2,8

@graphichaa

Hello I'm technical manager in a hosting company , and I can do it for you easily but I need more details Kind Regards

$155 AUD 3 napon belül

4,8

(1 értékelés)

0,8

@bodarhetal22

I read through the job details extremely carefully and I am absolutely sure that I can do the project very well.

$155 AUD 3 napon belül

0,0

(0 értékelés)

0,0

@sunilmudunuri

I'm an experienced freelancer database and report design, development and optimization with 10 years of experience . I have used Erwin tool for data modelling and i am well-versed with Normalization's for doing DB design. Here is few technologies I have mastered since last 10 years and can deliver the best solutions if you get me hired. I am in Florida, US 1) Sql Server 2005/2008/2012 2) MYSQL, MS Access 3) Oracle (PL/SQL) 4) SSIS, SSRS , SSAS and Power BI 5) Data analytics using R-Programming and SAS

$155 AUD 3 napon belül

0,0

(0 értékelés)

0,0

@Mscram

good exp in DBA , HA solutions , TDE , always on , handled 100 gB database also have exp in past 5 years

$35 AUD 3 napon belül

0,0

(0 értékelés)

0,0

@acharyark

I have 12+ years of working experience with multiple technologies and databases including SQL Server, would love to help you achieve your goals. Please provide more information about the project. Thanks. Its a small issue,I can assist you for free of cost, need rating. ping me for discussion.

$30 AUD 3 napon belül