Help

Dear Sir,
My name is Sureshkanan working as programmer cum network
administrator. I hav been using VB 6 & Ms Sql server 7
(now 2000) for
the programs. I have so many problem to be solved. If u
don't mind,
please help me in this regard.
Problem 1.
I hav a varchar field in sql server, which can hold 750
characters.
When I try to show the field in the crystal report 8.5,
the field is
truncated @. 255th character. It is showing first 254
character of the
content.
Problem 2
I installed a program which I developed onto several
machines using
administrator password. I checked the installed program,
that works
fine. In one computer the program is working when I logon
as
administrator but it is not working in other users. The
following
error is displayed when I clicked on the program.
The error.
The application failed to initialize property
(0xc0000022). Click on
ok to terminate the application.
All my clients are in Windows 2000 professional plat form.
Please advice me how can I over come above problemsSureshkanan wrote:
> Dear Sir,
> My name is Sureshkanan working as programmer cum network
> administrator. I hav been using VB 6 & Ms Sql server 7
> (now 2000) for
> the programs. I have so many problem to be solved. If u
> don't mind,
> please help me in this regard.
> Problem 1.
> I hav a varchar field in sql server, which can hold 750
> characters.
> When I try to show the field in the crystal report 8.5,
> the field is
> truncated @. 255th character. It is showing first 254
> character of the
> content.
This sounds like a Crystal issue. You may want ask Business Objects for
help on this.

> Problem 2
> I installed a program which I developed onto several
> machines using
> administrator password. I checked the installed program,
> that works
> fine. In one computer the program is working when I logon
> as
> administrator but it is not working in other users. The
> following
> error is displayed when I clicked on the program.
> The error.
> The application failed to initialize property
> (0xc0000022). Click on
> ok to terminate the application.
> All my clients are in Windows 2000 professional plat form.
> Please advice me how can I over come above problems
Sounds like a rights issue. Are you sure this is a SQL Server problem?
David Gugick
Imceda Software
www.imceda.com|||Problem 1 does sound like a crystal problem.
I have seen this scenario before in Access on form or report fields when the
control is bound to a memo type field and the data length is greater than
255. The solution was to remove any formatting on the control. Dont know
whether this applies to Crystal but you can try it
As David said i think you need to expand on exactly what you are doing.
Does your program actually connect to SQL server or does it not get that far
?
Andy
"Sureshkanan" wrote:

> Dear Sir,
> My name is Sureshkanan working as programmer cum network
> administrator. I hav been using VB 6 & Ms Sql server 7
> (now 2000) for
> the programs. I have so many problem to be solved. If u
> don't mind,
> please help me in this regard.
> Problem 1.
> I hav a varchar field in sql server, which can hold 750
> characters.
> When I try to show the field in the crystal report 8.5,
> the field is
> truncated @. 255th character. It is showing first 254
> character of the
> content.
> Problem 2
> I installed a program which I developed onto several
> machines using
> administrator password. I checked the installed program,
> that works
> fine. In one computer the program is working when I logon
> as
> administrator but it is not working in other users. The
> following
> error is displayed when I clicked on the program.
> The error.
> The application failed to initialize property
> (0xc0000022). Click on
> ok to terminate the application.
> All my clients are in Windows 2000 professional plat form.
> Please advice me how can I over come above problems
>|||In Version 10 of Crystal the problem of data length limitation in solved.
Try in Version 10 of Crystal Report
Hth
"Andy B" <AndyB@.discussions.microsoft.com> wrote in message
news:96926578-5B5A-487F-B73B-61D0FDB1FE11@.microsoft.com...
> Problem 1 does sound like a crystal problem.
> I have seen this scenario before in Access on form or report fields when
the
> control is bound to a memo type field and the data length is greater than
> 255. The solution was to remove any formatting on the control. Dont know
> whether this applies to Crystal but you can try it
> As David said i think you need to expand on exactly what you are doing.
> Does your program actually connect to SQL server or does it not get that
far?
> Andy
> "Sureshkanan" wrote:
>