geedub1961
asked on
Crystal Reports ODBC connection to FOX-PRO
I have setup many ODBC connections via crystal reports, but am baffled with FOX-PRO.
The app I am using should use Visual FoxPro 8 ODBC to function properly (per developer of software) They use freestanding tables in foxpro.
Can someone walk me through the proper steps to make the connection work.
Thanks in advance for your help.
The app I am using should use Visual FoxPro 8 ODBC to function properly (per developer of software) They use freestanding tables in foxpro.
Can someone walk me through the proper steps to make the connection work.
Thanks in advance for your help.
ASKER
I am using version 10.00
If the Crystal report was created using a File DSN, then connection to free standing tables should be possible even if the PC doesn't have that ODBC setup.
It sounds like you need to get some clarifications from the application developer rather than from this forum...
Cheers,
- Ido
It sounds like you need to get some clarifications from the application developer rather than from this forum...
Cheers,
- Ido
ASKER
This is about as far as I can get from the developer.
This is all I can get from the developer.
"You need Visual FoxPro 8 and you should be fine. It will have the ODBC that you need."
Do I need to create a file dsn? If so when I try, I get error messages at the end of the wizard.
This is all I can get from the developer.
"You need Visual FoxPro 8 and you should be fine. It will have the ODBC that you need."
Do I need to create a file dsn? If so when I try, I get error messages at the end of the wizard.
I believe using ADO rather than ODBC will be the simplest solution because the drivers are easily obtained and confusion over what is needed may be avoided. To use ADO:
1. Download and install Fox Pro OLE DB drivers from here: http://www.microsoft.com/downloads/details.aspx?FamilyId=0F43EB58-7A94-4AE1-A59E-965869CB3BC9&displaylang=en
2. Create a udl file somewhere, e.g. FoxProData.udl.
3. Double-Click on the UDL, in the 'Provider' tab select 'Microsoft Fox Pro OLE DB'.
4. Click 'Next' to move to the next tab and select the 'Free Table Directory' and 'General'.
5. Test your connection.
6. Open Crystal Reports. Select Connection Type as ADO\OLE DB. and browse to the UDL file.
7. Once you select the UDL file your tables appear.
1. Download and install Fox Pro OLE DB drivers from here: http://www.microsoft.com/downloads/details.aspx?FamilyId=0F43EB58-7A94-4AE1-A59E-965869CB3BC9&displaylang=en
2. Create a udl file somewhere, e.g. FoxProData.udl.
3. Double-Click on the UDL, in the 'Provider' tab select 'Microsoft Fox Pro OLE DB'.
4. Click 'Next' to move to the next tab and select the 'Free Table Directory' and 'General'.
5. Test your connection.
6. Open Crystal Reports. Select Connection Type as ADO\OLE DB. and browse to the UDL file.
7. Once you select the UDL file your tables appear.
ASKER
I am not familiar with UDL. Is this setup within windows? Or do I need foxpro to do this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for your answer. I was able to connect to a dbf file. The twist is that the files have extensions other than dbf. like .A1 and .A2 ect.
When i connect to the files with the a1 and a2 the connection is ok, but no fields show up. Any ideas on this,
BTW TommyTupa the UDL was great. I did not know it existed until you showed example.
When i connect to the files with the a1 and a2 the connection is ok, but no fields show up. Any ideas on this,
BTW TommyTupa the UDL was great. I did not know it existed until you showed example.
What happens if you change the extensions to .dbf. Obviously I would work on a copy of the file.
mlmcc
mlmcc
This may be useful
http://support.businessobjects.com/library/kbase/articles/c2007763.asp
mlmcc