ODBC error ...

[rdrunner40]

Hi,

I have a verison of OFFice XP Small Business SP3 running on a Windows XP Pro SP2 PC and are not being able to get a ODBC Connection with the Visual Fox Pro 8 table that contains the data.

We aretrying to do Mail merge and it will not create the link between the Word Doc and the table ....

Any ideas gratefully received ....

regards

Murray

 

[SkipVought]

Hi,

Did you ADD and CONFIGURE the FoxPro ODBC driver in the Control Panel?

Skip,
[sub]
[red]Be Advised![/red]
Alcohol and Calculus do not mix!
If you DRINK, don't DERIVE![/sub]

 

[rdrunner40]

Hi,

As far as i am aware when i install Visual Fox Pro the relevant driver is installed .... or is it ????

If not where do i find the ODBC driver that will help solve this problem

regards

Murray

 

[SkipVought]

In the Control Panel/Administrative Tools/Data Sources (ODBC)

Skip,
[sub]
[red]Be Advised![/red]
Alcohol and Calculus do not mix!
If you DRINK, don't DERIVE![/sub]

 

[rdrunner40]

Hi on the PC in question the driver is installed and is as below

6.00.8428.00 dated 23/4/99

Is this the most current ???

If not then where do i get a up todate version .....

really driving me up the wall

regards

Murray

 

[SkipVought]

Is it configures as a

User DSN

System DSN

File DSN

???

Skip,
[sub]
[red]Be Advised![/red]
Alcohol and Calculus do not mix!
If you DRINK, don't DERIVE![/sub]

 

[rdrunner40]

Hi

It is confiqured as a USer and also a System DSN ....

regards

Murray

 

[SkipVought]

How far into the Connection Process (from Word) can the user get?

Can you see the TABLES in the Fox Pro database?

Can you see data from the selected table in the Query Grid in MS Query?

Is there a criteria that is filtering ALL data?

Skip,
[sub]
[red]Be Advised![/red]
Alcohol and Calculus do not mix!
If you DRINK, don't DERIVE![/sub]

 

[rdrunner40]

I cannot connect to the Foxpro table at all and cannot see the table or the fields.....

There is no criteria filtering the table.

MS Query is not installed on any pc's at our site.

regards

Murray

 

[SkipVought]

MS Query is built-in for Word/Excel.

When you START...

Tools/Mail Merge.../Get Data/OPEN DATA SOURCE/[MS QUERY]...

Skip,
[sub]
[red]Be Advised![/red]
Alcohol and Calculus do not mix!
If you DRINK, don't DERIVE![/sub]

 

[SkipVought]

CAVEAT:

...unless it was NOT installed during setup.

Skip,
[sub]
[red]Be Advised![/red]
Alcohol and Calculus do not mix!
If you DRINK, don't DERIVE![/sub]

 

[rdrunner40]

Hi

I am going home

Will come back to you tommorrow with more of this ....

Thank you for your help

Murray

 

[rdrunner40]

Hi

I have tried all versions of the ODBC Software and we have identical versions of the ODBC now installed and they match another pc in the company where ODBC works succesfully.

Am at a loss as to what to try.

Is it possibly a issue with SP2 and Office XP small business ?????

Any more help is appreciated

regards

Murray

 

[SkipVought]

Did you get to MS Query in Get Data?

Skip,
[sub]
[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine![/sub]