Greg,
Thanks! The Pass-Through worked. If I create the Pass-Through and rename it to PUB_ORDERDTL it looks like my Access programs will work without modification.
Oddly, I'm even able to connect to the Customer table via a Pass-Through which I thought would be impossible because Access wouldn't be able to handle the number of indexes.
Our plant manager is extremely computer literate and writes his own queries in Excel. I'll probably still need to keep working on the ODBC connection so that he can do his thing but Greg's advice will allow me to push forward in using Access to create EDI files to push into Service Connect. Thanks again Greg.
Incidentally, I have the 2 WordAround2 reg entries but they didn't fix the problem in my case.
I have installed a Progress hotfix but need to wait for a server reboot to see if that helps.
John Wapner
Bracalente Mfg.
Thanks! The Pass-Through worked. If I create the Pass-Through and rename it to PUB_ORDERDTL it looks like my Access programs will work without modification.
Oddly, I'm even able to connect to the Customer table via a Pass-Through which I thought would be impossible because Access wouldn't be able to handle the number of indexes.
Our plant manager is extremely computer literate and writes his own queries in Excel. I'll probably still need to keep working on the ODBC connection so that he can do his thing but Greg's advice will allow me to push forward in using Access to create EDI files to push into Service Connect. Thanks again Greg.
Incidentally, I have the 2 WordAround2 reg entries but they didn't fix the problem in my case.
I have installed a Progress hotfix but need to wait for a server reboot to see if that helps.
John Wapner
Bracalente Mfg.
--- In vantage@yahoogroups.com, Greg Renfro <greg.renfro@...> wrote:
>
> One correction, I meant to say title bar when referring to the path and password saving, not address bar. Sorry for any confusion.
>
> Greg Renfro
> IT Manager
> Apex Engineering International, LLC.
> 316-262-1494 x139
> ________________________________
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Greg Renfro
> Sent: Thursday, April 16, 2009 2:39 PM
> To: 'vantage@yahoogroups.com'
> Subject: RE: [Vantage] Re: ODBC / problem connecting certain tables
>
>
>
>
>
> I was referring to the passthrough query in Access. Create a new query in Access. Do not add any tables and choose Close, then right click in the window where your tables would normally be. Next choose SQL Specific from the pull down and choose Pass-Through. Then you would plug in the SQL code to execute against the table in question. Also you then can right click the address bar and set the ODBC path and password and save it in your query.
>
> Here is some example code:
>
> Select JobHead.ReqDueDate, JobHead.DueDate, JobHead.Company, JobHead.JobNum, JobHead.PartNum, JobHead.PartDescription, JobHead.JobClosed, JobHead.JobReleased, JobComplete from PUB.JobHead
>
> This will pull the listed fields from the Job Header table.
>
> Greg Renfro
> IT Manager
> Apex Engineering International, LLC.
> 316-262-1494 x139
> ________________________________
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of wapnerj
> Sent: Thursday, April 16, 2009 2:18 PM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: ODBC / problem connecting certain tables
>
> Hi Greg,
>
> I neglected to mention that we're running on Progress. In Vantage 6.1 there was something that I presume was similar - a server-based query that returned all the records from the table. You connected to that "view" rather than the actual table via ODBC. However, tech support said that's not available in OpenEdge.
>
> Is the above what you meant by a SQL view?
>
> I gather that the overall concensus of people is not to use SQL with Vantage, but does SQL (instead of Progress) resolve these ODBC connection issues?
>
> John Wapner
> Bracalente Mfg.
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>, Greg Renfro <greg.renfro@> wrote:
> >
> > Try using a SQL passthrough query. This has worked for me in most situations.
> >
> >
> > Greg Renfro
> > IT Manager
> > Apex Engineering International, LLC.
> > 316-262-1494 x139
> > ________________________________
> > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of wapnerj
> > Sent: Thursday, April 16, 2009 1:33 PM
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] ODBC / problem connecting certain tables
> >
> >
> >
> >
> >
> > I'm working on setting up the ODBC connection on a test 8.03 server. I've gotten to the point that I can open some tables such as ORDERREL in Access 2007 but ORDERDTL causes Access to lockup and restart.
> >
> > Using the Data Dictionary utility I've set the width of comment fields from 2000 characters to 254 but still can't open the table. It does not seem to have an excessive number of indexes.
> >
> > The PARTBIN table returns a grid with #DELETED in every cell in Access.
> >
> > Other tables open correctly in Access.
> >
> > It sounds like other people have gotten ODBC working with 8.03 - any help would be appreciated.
> >
> > John Wapner
> > Bracalente Mfg.
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
> [Non-text portions of this message have been removed]
>
>
>
> [Non-text portions of this message have been removed]
>