We have some javascript on the onLoad event for Opportunities. It does a SQL
callout to the filteredAccount table to grab the latest Credit Hold
information. One of our users suddenly got a javascript error on the page
yesterday that has me baffled.

It was:

There was an error this field's customized event.
Field: crmForm
Event: onload
Error: Cannot open database "xxx_MSCRM" requested by the login. The login
failed.

Any ideas on how a user could suddenly develop issues with accessing a
database via javascript? The user has access to the filteredAccount table
that is called by the javascript and is able to otherwise function normally
in the rest of CRM.

Re: Error from Javascript by George

George
Sat Jun 30 01:16:34 CDT 2007

Hi Bacons,

> Any ideas on how a user could suddenly develop issues with accessing a
> database via javascript?

Err, for example if standard SQL login is used and the password has been
changed? Without seeing the code it's hard to tell. Care to share the code
for "SQL callout"? Otherwise I personally cannot figure out what does it
mean that "filteredAccount table ... is called by the javascript".

Overall, instead of direct SQL access (if that's what your code is doing)
I'd recommend using a well-established practice of calling web services to
obtain information from related entities.

Hope this helps.
--
George Doubinski
CRM Certified Professional - Developer


"Bacons" <Bacons@discussions.microsoft.com> wrote in message
news:DC324A08-17CF-4CDE-BCFF-4F6514CD03FD@microsoft.com...
> We have some javascript on the onLoad event for Opportunities. It does a
> SQL
> callout to the filteredAccount table to grab the latest Credit Hold
> information. One of our users suddenly got a javascript error on the page
> yesterday that has me baffled.
>
> It was:
>
> There was an error this field's customized event.
> Field: crmForm
> Event: onload
> Error: Cannot open database "xxx_MSCRM" requested by the login. The login
> failed.
>
> Any ideas on how a user could suddenly develop issues with accessing a
> database via javascript? The user has access to the filteredAccount table
> that is called by the javascript and is able to otherwise function
> normally
> in the rest of CRM.