Good Day:
I am having problems connecting to SQL databases with JMP. I
have done it successfully in the past, and I suspect that the issue may have to
do with the databases having grown in size or complexity.
Our DBs are generated by a semiconductor processing tool. Currently,
the process tool generates one table per day (with a name that corresponds to
the date) and also one table per wafer processed (with a names based on
sequence of the wafers processed). The table for each wafer means that
hundreds of tables can be added in a single day, and over months or years, this
can grow to tens of thousands or even 100,000 tables.
I think my DB connection issue is caused by this (absurdly)
large number of tables. When JMP connects to my SQL DBs, it automatically
loads all the tables in the DB. When the number of tables grows as large
as tens of thousands, JMP chokes and stalls. We have noticed that when we
delete one of these large DBs and start over, JMP connects successfully.
I am working with our SW group to greatly reduce the number
of tables produced in our database (by limiting it to one per day only) but in
the meantime, I am looking for a way to fetch only those tables whose name meets
a given criterion. Is there a way to do this? Is it possible to not
have any tables loaded when connecting the the DB and still execute a SQL query
which provides a specific table name to be queried?
Would welcome any suggestions or input. Some technical
details of the software and drivers we are using are listed below.
Best regards,
Bob Clark-Phelps
1) JMP Version: 8.0.1
2) Operating System:
Windows XP Professional Version 2002 Service Pack 2
3) Release of SQL DB:
2008 SQL Server
4) Release of SQL ODBC
Driver: 2008.85.1117.00 from Microsoft
__________________________
Bob Clark-Phelps, Ph.D.
Product Development Manager
TEL
Epion Inc.
37 Manning Road
Billerica, MA 01821
Company Phone: 978.436.2300
Direct Line: 978.436.2480
FAX: 978.436.2301
Email: robert.clark-phelps@us.tel.com
