The only other thing I can think of off the top of my head is Crystal's very poor handling of prefix and postfix data in sub-reports. If you are using sub-reports make sure a field in the table in question is at least referenced on the main report.
Sorry I couldn't be more help. Pat... ----- Original Message ----- From: "Valère Palhoriès" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 21, 2004 6:50 PM Subject: Re: Problems adding table to Crystal Reports using ODBC Connection > Patrick, > > Yes I am. If I create a Linked Table from Access 2003 I can see the table. > Additionally, I drop the Crystal Query into SQLyog and execute it and it > works fine. Of course I modify the SQL Query slightly to be compliant with > SQLYog! > > -- Val > > > >From: "Patrick" <[EMAIL PROTECTED]> > >To: Valère Palhoriès <[EMAIL PROTECTED]> > >Subject: Re: Problems adding table to Crystal Reports using ODBC Connection > >Date: Wed, 21 Apr 2004 18:48:27 -0400 > > > >Are you able to see the table with any other ODBC products (like Access?). > > > >Pat... > > > >----- Original Message ----- > >From: "Valère Palhoriès" <[EMAIL PROTECTED]> > >To: <[EMAIL PROTECTED]> > >Sent: Wednesday, April 21, 2004 6:45 PM > >Subject: Re: Problems adding table to Crystal Reports using ODBC Connection > > > > > > > Patrick, > > > > > > Yes, I have tried the Verify Database in Crystal and it comes back with > > > Database is up to date. I've also tried to RESET the Query from the View > >SQL > > > Query and it's correct! > > > > > > I'm at a loss! > > > > > > -- Val > > > > > > > > > >From: "Patrick" <[EMAIL PROTECTED]> > > > >To: Valère Palhoriès <[EMAIL PROTECTED]>, > ><[EMAIL PROTECTED]> > > > >Subject: Re: Problems adding table to Crystal Reports using ODBC > >Connection > > > >Date: Wed, 21 Apr 2004 18:42:41 -0400 > > > > > > > >Have you tried 'Verify Database' in Crystal? > > > > > > > >Pat... > > > >Patrick Sherrill > > > >CocoNet Corporation > > > >SW Florida's 1st ISP > > > > > > > >----- Original Message ----- > > > >From: "Valère Palhoriès" <[EMAIL PROTECTED]> > > > >To: <[EMAIL PROTECTED]> > > > >Sent: Wednesday, April 21, 2004 5:26 PM > > > >Subject: Problems adding table to Crystal Reports using ODBC Connection > > > > > > > > > > > > > Hello, > > > > > > > > > > I have reports designed in Crystal Reports 8.5 that are connected to > > > >MySql > > > > > DB via an ODBC Connection. The reports run great and are accessed > > > >without > > > >a > > > > > problem through our VB application. > > > > > > > > > > We have recently added a table to our database that needs to be > >added > >in > > > > > addition to already existing tables on some of the reports. I Add > >the > > > >table, > > > > > update the SQL Query and insert the field on the report. When I try > >to > > > > > preview the report I get the following error message: > > > > > > > > > > ODBC error: [MySql][ODBC 3.51 Driver][mysqld-4.0.16-nt]Unknown table > > > > > 'tablename' in field list. > > > > > > > > > > I tried the same thing with several other reports and get the same > > > >results. > > > > > The last table I add always gives the same message. > > > > > > > > > > I've tried re-creating the report from scratch and it works fine > >when > >I > > > >do. > > > > > I tried to add another table onto the report I created from scratch > >and > > > >get > > > > > the same error message. > > > > > > > > > > Anyone know what's going on here? > > > > > > > > > > I'm trying to move towards the TTX concept but that will take me a > > > >couple > > > >of > > > > > weeks. In the mean time, I have to get this problem resolved! > > > > > > > > > > Any help or light you can shed on this matter would be so much > > > >appreciated. > > > > > > > > > > Thanks > > > > > > > > > > -- Val > > > > > > > > > > _________________________________________________________________ > > > > > Lose those love handles! MSN Fitness shows you two moves to slim > >your > > > >waist. > > > > > > > > > > >http://fitness.msn.com/articles/feeds/article.aspx?dept=exercise&article=et > >_pv_030104_lovehandles > > > > > > > > > > > > > > > -- > > > > > MySQL ODBC Mailing List > > > > > For list archives: http://lists.mysql.com/myodbc > > > > > To unsubscribe: > > > >http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > > > > > _________________________________________________________________ > > > MSN Toolbar provides one-click access to Hotmail from any Web page - > >FREE > > > download! http://toolbar.msn.com/go/onm00200413ave/direct/01/ > > > > > > > _________________________________________________________________ > Watch LIVE baseball games on your computer with MLB.TV, included with MSN > Premium! > http://join.msn.com/?page=features/mlb&pgmarket=en-us/go/onm00200439ave/direct/01/ > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
