User Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Instantly extract effect sizes, F-ratios, and FDR-adjusted p-values from your models with the Calculate Effects Sizes extension, available now in the JMP Marketplace!
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
  • See how to use the JMP Marketplace – Free tools to expand JMP capabilities. Register. July 10, 2 pm US Eastern Time.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
RajveerSingh
RajveerSingh
Level I

Facing issue in accessing views in jmp tool

Created: Jun 7, 2022 08:28 AM  |  Last Modified: Jun 10, 2023 1:50 PM (1992 views)

I had connected jmp tool with database. Connection with database is successful and i am able to access tables inside jmp. But when i am trying to access views in jmp tool then i am getting error like "prepare statement need to be re-prepared". Could you please tell me the solution for this issue?

 

In my phpmyadmin i am able to access views correctly. There is might be some issue in jmp tool. 

Preview file
309 KB
0 Kudos
1 REPLY 1
jthi
Super User jthi
Super User

Re: Facing issue in accessing views in jmp tool

Jun 7, 2022 08:35 AM (1988 views)  |  Posted in reply to message from RajveerSingh 06-07-2022

 I think that error message is coming from MySQL drivers. Maybe some of these could help: How to get rid of MySQL error 'Prepared statement needs to be re-prepared' (stackoverflow.com) 

-Jarmo

Recommended Articles