Can Grow crystal report option - does not grow.

Hi.

I am connecting my report file to the domino server. I have a string in the crystal report which is mapped to a text field. the "Can Grow" option is checked but still this string on the report is truncating the data after some 240+ characters.

Any of you have any idea? Your help would be highly appreciatedCheck whether the field has any junk data|||Hi Madhi.

Thanks for your reply. I have checked that there is no junk data in the field...its all simple text...but still the field does not display all of my data in the report. Any idea?.

thanks again for your help.|||Did you try to expand the filed?|||Yes. I expanded the field width. My field is available in the Details Section. I have increased the width but still the complete information does not show up and blank space is displayed from the point the information is truncated.

Can connect with IP number but not with machine name

Running MSDE2000A named instance on an XP Pro machine as part of a domain
(W2003 server) , connecting from a client: with a connection
'machinename\instancename' i get no connection ('server not found or accss
denied'); however with the same setup and a connection
'172.0.30.14\instancename' everything works as expected. I can use an alias
for the IP number and that works but an alias for the machine name does not.
With a DHCP server, the IP address isn't permanent so how do I configure the
connection in my application?
More info - Colleagues have suggested that this is a simple DNS problem. But
I can connect to the machine using the DNS names in other apps (e.g. 'my
network Places') - it's just SQL that won't connect.
"quilkin" wrote:

> Running MSDE2000A named instance on an XP Pro machine as part of a domain
> (W2003 server) , connecting from a client: with a connection
> 'machinename\instancename' i get no connection ('server not found or accss
> denied'); however with the same setup and a connection
> '172.0.30.14\instancename' everything works as expected. I can use an alias
> for the IP number and that works but an alias for the machine name does not.
> With a DHCP server, the IP address isn't permanent so how do I configure the
> connection in my application?

Can connect with IP number but not with machine name

Running MSDE2000A named instance on an XP Pro machine as part of a domain
(W2003 server) , connecting from a client: with a connection
'machinename\instancename' i get no connection ('server not found or accss
denied'); however with the same setup and a connection
'172.0.30.14\instancename' everything works as expected. I can use an alias
for the IP number and that works but an alias for the machine name does not.
With a DHCP server, the IP address isn't permanent so how do I configure the
connection in my application?More info - Colleagues have suggested that this is a simple DNS problem. But
I can connect to the machine using the DNS names in other apps (e.g. 'my
network Places') - it's just SQL that won't connect.
"quilkin" wrote:

> Running MSDE2000A named instance on an XP Pro machine as part of a domain
> (W2003 server) , connecting from a client: with a connection
> 'machinename\instancename' i get no connection ('server not found or accss
> denied'); however with the same setup and a connection
> '172.0.30.14\instancename' everything works as expected. I can use an alia
s
> for the IP number and that works but an alias for the machine name does no
t.
> With a DHCP server, the IP address isn't permanent so how do I configure t
he
> connection in my application?

Can connect with IP number but not with machine name

Running MSDE2000A named instance on an XP Pro machine as part of a domain
(W2003 server) , connecting from a client: with a connection
'machinename\instancename' i get no connection ('server not found or accss
denied'); however with the same setup and a connection
'172.0.30.14\instancename' everything works as expected. I can use an alias
for the IP number and that works but an alias for the machine name does not.
With a DHCP server, the IP address isn't permanent so how do I configure the
connection in my application?More info - Colleagues have suggested that this is a simple DNS problem. But
I can connect to the machine using the DNS names in other apps (e.g. 'my
network Places') - it's just SQL that won't connect.
"quilkin" wrote:
> Running MSDE2000A named instance on an XP Pro machine as part of a domain
> (W2003 server) , connecting from a client: with a connection
> 'machinename\instancename' i get no connection ('server not found or accss
> denied'); however with the same setup and a connection
> '172.0.30.14\instancename' everything works as expected. I can use an alias
> for the IP number and that works but an alias for the machine name does not.
> With a DHCP server, the IP address isn't permanent so how do I configure the
> connection in my application?

Can Classic ASP Interact with SQL Server 2005?

Forgive me if this is not the most appropriate group to pose this question.
I have a classic ASP app that is currently connecting to a SQL Server 2000
database using MDAC 2.8. Can a classic ASP application using MDAC 2.8
connect to and interact with SQL Server 2005? What issues might I encounter?
What known requirements are there to do this?
Thank you very much for any insight you can offer.
Ken Sturgeon
Most probably you dont need to change anything in your code to make this
work. At least I didn't have to change anything
Milan
P.S. Most probably you use ADO objects.
"Ken Sturgeon" <aksturgeon@.charter.net> wrote in message
news:O8Wn0j4FGHA.1028@.TK2MSFTNGP11.phx.gbl...
> Forgive me if this is not the most appropriate group to pose this
> question.
> I have a classic ASP app that is currently connecting to a SQL Server 2000
> database using MDAC 2.8. Can a classic ASP application using MDAC 2.8
> connect to and interact with SQL Server 2005? What issues might I
> encounter? What known requirements are there to do this?
> Thank you very much for any insight you can offer.
> Ken Sturgeon
>

Can Classic ASP Interact with SQL Server 2005?

Forgive me if this is not the most appropriate group to pose this question.
I have a classic ASP app that is currently connecting to a SQL Server 2000
database using MDAC 2.8. Can a classic ASP application using MDAC 2.8
connect to and interact with SQL Server 2005? What issues might I encounter?
What known requirements are there to do this?
Thank you very much for any insight you can offer.
Ken SturgeonMost probably you dont need to change anything in your code to make this
work. At least I didn't have to change anything
Milan
P.S. Most probably you use ADO objects.
"Ken Sturgeon" <aksturgeon@.charter.net> wrote in message
news:O8Wn0j4FGHA.1028@.TK2MSFTNGP11.phx.gbl...
> Forgive me if this is not the most appropriate group to pose this
> question.
> I have a classic ASP app that is currently connecting to a SQL Server 2000
> database using MDAC 2.8. Can a classic ASP application using MDAC 2.8
> connect to and interact with SQL Server 2005? What issues might I
> encounter? What known requirements are there to do this?
> Thank you very much for any insight you can offer.
> Ken Sturgeon
>

Can anyone help me with connecting to a database to search?

I'm trying to make this piece of code work, I get all of it except how I get the data from the database, what I wish to do is. On page load I wish to take the value of a querystring in the page URL called ProductID and search a database to see if it exists in a specifical table and column, if it exists I wish to make a button not visible. the code I am using is:

#############

protectedvoid Page_Load(object sender,EventArgs e)

{

// Get the querystring value

String inQueryString = Request.QueryString["ProductID"];

// Get the data from the database, using the above value

DataTable data = ??

The datasource I want to connect to is SqlDataSource1, and the table I want to search is "Reviews". I want to search in the column "ProductID" and search for the ProductID from the URL query string above.

// Did we find a product in the database?

if (data !=null &&

data.Rows.count > 0)

{

// Code to display the product's information

// We found a product, so we need to hide a button

Button5.Visible =false;

}

}

##########################

Please can somebody fill in the missing bit for me so i know how it should be, i've searched the quickstart tutorial on the menu above and I still don't understand it, as it doesn't show anything like what I want to do, and I have looked at numerous websites about the matter. If you don't have time that is okay, but If somebody does have the time to show me what I need, I would be very greatfull.

Regards

Daniel coates

anyone got any ideas? surely somebody must know what I need to do!

Regards

Dan