I have a shared .dbc for a 1-tier VFP app used by dozens of people. I am now tasked with using the Brio report tool to get information out of the .dbc. The .dbc is on server \\gershwin.
Brio uses ODBC to read/present info. Brio is installed on server \\gemini. The %temp% path variable is set to d:\wintemp on \\gemini. I have a System DSN on \\gemini that points to \\gershwin\gendata\gendata.dbc.
When I point Brio to use my ODBC data source, the VFPODBC driver says
SQLGetTypeInfo: rc =-1, SQLSTATE:S1000,Error Msg: [Microsoft][ODBC Visual FoxPro Driver]Cannot open file d:\wintemp\52uk00d.tmp.
When I look at the \\gershwin\gendata directory, I see the .tmp file.
I think the ODBC driver sees the DBC, creates a temp cursor in that location, then tries to convert that to a table and add it to the .dbc, but it forgets to go across the network.
What is the workaround for this?
Help?!