Visual Foxpro - ODBC from Business objects

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi,

I don't know if this is the correct group to post this.

I have the following enviroment :-

Server A - Windows 2000 Server SP4 - Running Business Objects
Enterprise 11
Server B - Windows 2000 Server SP4 - File server holding Visual Foxpro
data.

I have created an ODBC connection from the Business objects server to
the foxpro files on the file server. If I run a crystal report using
this connection all is fine. If I publish this report to the Business
Objects web server, it always fails.

I have set up auditing of the files on the file server to see if I have
a permissions problem.
- when the report runs via the web server, nothing is logged as to
accessing this file - i.e. it's not even attempting to connect to the
files. I can't find any options to specify any kind of network login
within the odbc connection using this driver.

Does anyone have any ideas?

.

Relevant Pages

  • Re: System DSN Odbc only works for admin accounts. Group policy?
    ... Found the fix, For the report server problem, the Temp file under ... Iwam_server must have its permissions set on the server so the users ... odbc connection I used a mapped drive letter. ... > The System DSN is acting the way I would expect a USER Dsn to act. ...
    (microsoft.public.backoffice.smallbiz2000)
  • Visual FoxPro connection to remote server
    ... I have created an ODBC connection from the Business objects server to ... If I publish this report to the Business ... Objects web server, it always fails. ...
    (microsoft.public.access.externaldata)
  • Re: ODBC connection to new server
    ... report to the server that wouldn't result in the current mess I'm in. ... If the report is thru ODBC connection then yes it does store the name ...
    (microsoft.public.vb.crystal)
  • Re: ODBC connection to new server
    ... If the report is thru ODBC connection then yes it does store the name ... server name for that report. ... Is there still something inside the report files that is pointing the ...
    (microsoft.public.vb.crystal)
  • ODBC Connection
    ... I got problem with ODBC connection, I have a product server and a stage ... Dim intTemp As Integer ... and create a instance of login from asp page, ...
    (microsoft.public.sqlserver.odbc)