Crytsal Reports 11 cannot connect to Visual Foxpro Database table

[#1]

I hope someone can help me here. I have read through the other posts here, but can't seem to fiind the answer I need.

We use Crystal Reports to pull information from our Sage databases to create and distribute reports. Currently this is working fine on the original server. However, we decided to move the installation of Crystal Reports from one server to another.

In setting up the new server, I keep getting the message "The database table (table name) cannot be found. Proceed to remove this table from the report?" It displays this message for all the different tables in which data is trying to be accessed. Once I click No to all of these notifications, the correct info is poplulated in the report just fine. I need to get this corrected. It does not do this on the original installation.

Also if I open Database Expert and single click too expand the "Current Connections" folder, I get a message that pops up saying "Database Connector Error: 'HY010:[Microsoft][ODBC Visual Foxpro Driver] Function sequence error'". When I click OK to that, I get another similar error that reads "Database Connector Error: 'IM001:[Microsoft][ODBC Driver Manager] Driver does not support this function'"

Please let me know of any ideas that you may have as to what may be causing this issue. I have tried reinstalling the ODBC drivers, Runtime files, and Crystal. I appreciate any help.

[former_member11696 · Accepted solution]

Hi Chris,

Sage has their own ODBC driver so for support you need to contact them. We don't have it here to test with so we can' t help you to debug the issue.

If you can connect using one of our sample reports using our Xtreme.mdb ( Access ) then all is working from CR's side.

Thank you

Don

[Former Member · Accepted solution]

I tried what you mentioned but it did not work. I believe it has to do with a "SQLNumResultCols" in SQL. The reason I say this is because I did a trace on both the server that is working and the server that is not and this is the first key that displayed an error in the SQL.LOG file. Here is this section of the SQL.LOG file for the server that isnt working...

dde 2e94-28b0 EXIT SQLNumResultCols with return code -1 (SQL_ERROR)

HSTMT 03442998

SWORD * 0x0012F3F4

DIAG [HY010] [Microsoft][ODBC Visual FoxPro Driver]Function sequence error (0)

And here is this section of the SQL.LOG file for the server that is working...

dde eb8-c94 EXIT SQLNumResultCols with return code 0 (SQL_SUCCESS)

HSTMT 03542508

SWORD * 0x0012F3F4 (5)

I believe if I can figure out what is causing this, I will be able to resolve this issue, but I am not a programmer and I am having a very hard time with this. Any help is appreciated.

[former_member11696]

Contact Sage for support with their ODBC driver. Due to Licensing We can not and will not help you work around their database security or configuration.

[Former Member]

I have the answer to my issue now. It was not a driver as you mentioned.

The error was occuring because of the System attribute assinged to the C:\Temp folder on my server.

Once I ran this command... ATTRIB -S c:\temp

The connection began working like a charm.

The link to the support doc that helped me figure this out is below.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q308215

I hope this helps out any others that may be having the same issue I spent off and on 2 weeks figuring out.

Edited by: Chris V on Mar 25, 2010 8:34 PM