C
Chris
I have a form that I've saved to my MOSS 2007 server. The form uses 4 data
connections back to 2 different SQL servers. And it works fine when I open
the form in my browser, but the form breaks when another user opens it. The
error says that there was an error connecting to the data source.
But I've converted the data connections to a data connection library on my
forms server (with username and password stored in the UDC file). I'm using a
read-only user to connect back to the SQL servers.
I read that the UDC files need to be approved before the connection can be
used, but I can't check the UDC file in because the Title property is not
specified and whenever I type something into the field it does not save.
Can anyone point me in the right direction?
Thanks,
Chris
connections back to 2 different SQL servers. And it works fine when I open
the form in my browser, but the form breaks when another user opens it. The
error says that there was an error connecting to the data source.
But I've converted the data connections to a data connection library on my
forms server (with username and password stored in the UDC file). I'm using a
read-only user to connect back to the SQL servers.
I read that the UDC files need to be approved before the connection can be
used, but I can't check the UDC file in because the Title property is not
specified and whenever I type something into the field it does not save.
Can anyone point me in the right direction?
Thanks,
Chris