Hi,
I think you will have to do one of two things:
1. this is the best way - find a way through the api to capture the sql
server server name; then develop a routine that builds the connection string
with this captured name.
2. change your connection to 'hard code' to the name of the client's sql
server.
1 is far more elegant; 2 is easier for the moment.
HTH,
Bernie Yaeger
[quoted text, click to view] "al" <grawsha2000@yahoo.com> wrote in message
news:66edfd3c.0401020801.7d81278d@posting.google.com...
> "Bernie Yaeger" <berniey@cherwellinc.com> wrote in message
news:<#hR0$XL0DHA.1740@TK2MSFTNGP09.phx.gbl>...
> > Hi Grawsha,
> >
> > No way that I know of. I do it in two ways:
> > 1. change the name of the sql server server to be the same as the one I
use
> > for development
> > 2. run through your code and change throughout as necessary
> >
> > The latter method sounds difficult, but it really doesn't take that
long;
> > I've done it on some big apps and it goes pretty smoothly.
> >
> > HTH,
> >
> > Bernie Yaeger
> >
> > "al" <grawsha2000@yahoo.com> wrote in message
> > news:66edfd3c.0312312127.11307110@posting.google.com...
> > > Hi,
> > >
> > > If I use (in development) connection object from design tools in
> > > ToolBox to get data from db to crystal reports, how can I make
> > > changes to server name and security options in runtime. That is, is
> > > there an option during "packaging and deployment" where I can make
> > > connection setting as per client machine,instead of being to
> > > develpment one??
> > >
> > > MTIA,
> > > Grawsha
>
>
> Ok, This is good. I used design tools to connect to database (in
> development) but when I moved the application to client and ran it,
> there was an error saying "needs valid server to connect to" or
> something close to this. How can I change the name of the server to
> match what is on client??(I do not want to do this in development
> time, as I really don't know what is the name the client has)
