Hi all,
We are trying to access SQL Server using OLEDB via
our widearea network from San Francisco to LA. It does not work.
Does anybody know the proper settings/parameters in OLEDB to get this to work? Thanks.
Regards,
Troy
Add "set nocount on" right after the BEGIN statement in the stored procedure.
For full details, see:
http://support.crystaldecisions.com/library/kbase/articles/c2005342.asp
Troy
San Francisco, CA
This might sounds a dumb question to some people. I need to
know the table names of a SQL Server 2000 database inside a stored procedure.
Which system table (or SP) should I use? Thanks.
Troy
San Francisco
1. Use Locate For command is the two fields are not indexed.
2. use Seek() if the two fields are in the index.
3. Use SQL with Where Clause doing the qualifying.
Troy
San Francisco
Go to "Insert" on the menu, then click "Parameter field". Find you parameter there and drop it on the report design.
Troy
San Francisco
Thanks Ken, for your suggestion.
I just tried this in a formula that is used on the detail section of a CR version 7 report:
If {mytable.datetime1) < DateTime(1,1,1,0,0,0)then
// to stuff empty field with today's date
CurrentDate
else
{mytable.datetime1)
...
However, the empty fields...
In a CR formula, I try to test for an empty (not null)datetime field in a SQL Server table. I try the following syntax:
If {mytable.datetime1} = date (0,0,0) then...
and
If not (DayeOfWeek{mytable.datetime1} in 1 to 7 )then ...
None of these work. Does anyone knows the correct syntax...
Yuo need to put "IUSR_yourdomain" in a group that has at least read permission to the NT directory that contains the ASP page. You might want to create a new group for this purpose.
Troy
San Francisco
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.