Search results for query: *

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

Do you have Access installed on the client machine? Troy San Francisco, CA

Thanks much for your time. All of them worked. Regards, Troy

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 &quot;IUSR_yourdomain&quot; 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