hi guys,
I'm currently using Sql server 2000 for database,
I use the data adapter wizard for most of the connection in vb,
and it is connected to the machine name of my computer,
if i create a setup using for my project,
Is there a problem for my project to use in another machine
using that machine's database?
what can i do to work probably on other machine?
and how to include the database and install on anonther machine
using the setup created?

hey

you will always have to point your connection string to the right sql
server.
there are several ways to do this i would suggest that you set the value in
the load of your form, you can hard code it or set a value in your config
file (progname.exe.config) that way you can change it whithout recompiling.

hope it helps

eric

"Gene" <(E-Mail Removed)> wrote in message
news:uiRPd$U%(E-Mail Removed)...
> hi guys,
> I'm currently using Sql server 2000 for database,
> I use the data adapter wizard for most of the connection in vb,
> and it is connected to the machine name of my computer,
> if i create a setup using for my project,
> Is there a problem for my project to use in another machine
> using that machine's database?
> what can i do to work probably on other machine?
> and how to include the database and install on anonther machine
> using the setup created?
>
>

THX,
but would you mind telling me more on this?
like where is the config file?

"EricJ" <(E-Mail Removed)> ¼¶¼g©ó¶l¥ó·s»D
:4039b821$0$7032$(E-Mail Removed)...
> hey
>
> you will always have to point your connection string to the right sql
> server.
> there are several ways to do this i would suggest that you set the value
in
> the load of your form, you can hard code it or set a value in your config
> file (progname.exe.config) that way you can change it whithout
recompiling.
>
> hope it helps
>
> eric
>
> "Gene" <(E-Mail Removed)> wrote in message
> news:uiRPd$U%(E-Mail Removed)...
> > hi guys,
> > I'm currently using Sql server 2000 for database,
> > I use the data adapter wizard for most of the connection in vb,
> > and it is connected to the machine name of my computer,
> > if i create a setup using for my project,
> > Is there a problem for my project to use in another machine
> > using that machine's database?
> > what can i do to work probably on other machine?
> > and how to include the database and install on anonther machine
> > using the setup created?
> >
> >
>
>

i will have to be a bit vague bout that one (i'm working on web forms atm
and thats a bit different)

normally you can add a new item to the project and that shouold be an
application configuration file (it wil be in the templates) if you leave it
like that you will have to recompile to change the values if you put a .exe
behind the name it will take the values without recompiling.


the config file would be something like this. (in your app set the
connection string to SqlConnection1.ConnectionString)
<?xml version="1.0" encoding="utf-8"?>

<configuration>

<appSettings>

<!-- User application and configured property settings go here.-->

<!-- Example: <add key="settingName" value="settingValue"/> -->

<add key="SqlConnection1.ConnectionString" value="data
source=SERVERNAME;database=DBNAME;user id=***;password=*****" />

</appSettings>

</configuration>


"Gene" <(E-Mail Removed)> wrote in message
news:e2M0d5g%(E-Mail Removed)...
> THX,
> but would you mind telling me more on this?
> like where is the config file?
>
> "EricJ" <(E-Mail Removed)> ¼¶¼g©ó¶l¥ó·s»D
> :4039b821$0$7032$(E-Mail Removed)...
> > hey
> >
> > you will always have to point your connection string to the right sql
> > server.
> > there are several ways to do this i would suggest that you set the value
> in
> > the load of your form, you can hard code it or set a value in your
config
> > file (progname.exe.config) that way you can change it whithout
> recompiling.
> >
> > hope it helps
> >
> > eric
> >
> > "Gene" <(E-Mail Removed)> wrote in message
> > news:uiRPd$U%(E-Mail Removed)...
> > > hi guys,
> > > I'm currently using Sql server 2000 for database,
> > > I use the data adapter wizard for most of the connection in vb,
> > > and it is connected to the machine name of my computer,
> > > if i create a setup using for my project,
> > > Is there a problem for my project to use in another machine
> > > using that machine's database?
> > > what can i do to work probably on other machine?
> > > and how to include the database and install on anonther machine
> > > using the setup created?
> > >
> > >
> >
> >
>
>

small correction it should be appname.exe.config in your bin folder

"EricJ" <(E-Mail Removed)> wrote in message
news:4039ff6b$0$325$(E-Mail Removed)...
> i will have to be a bit vague bout that one (i'm working on web forms atm
> and thats a bit different)
>
> normally you can add a new item to the project and that shouold be an
> application configuration file (it wil be in the templates) if you leave
it
> like that you will have to recompile to change the values if you put a
..exe
> behind the name it will take the values without recompiling.
>
>
> the config file would be something like this. (in your app set the
> connection string to SqlConnection1.ConnectionString)
> <?xml version="1.0" encoding="utf-8"?>
>
> <configuration>
>
> <appSettings>
>
> <!-- User application and configured property settings go here.-->
>
> <!-- Example: <add key="settingName" value="settingValue"/> -->
>
> <add key="SqlConnection1.ConnectionString" value="data
> source=SERVERNAME;database=DBNAME;user id=***;password=*****" />
>
> </appSettings>
>
> </configuration>
>
>
> "Gene" <(E-Mail Removed)> wrote in message
> news:e2M0d5g%(E-Mail Removed)...
> > THX,
> > but would you mind telling me more on this?
> > like where is the config file?
> >
> > "EricJ" <(E-Mail Removed)> ¼¶¼g©ó¶l¥ó·s»D
> > :4039b821$0$7032$(E-Mail Removed)...
> > > hey
> > >
> > > you will always have to point your connection string to the right sql
> > > server.
> > > there are several ways to do this i would suggest that you set the
value
> > in
> > > the load of your form, you can hard code it or set a value in your
> config
> > > file (progname.exe.config) that way you can change it whithout
> > recompiling.
> > >
> > > hope it helps
> > >
> > > eric
> > >
> > > "Gene" <(E-Mail Removed)> wrote in message
> > > news:uiRPd$U%(E-Mail Removed)...
> > > > hi guys,
> > > > I'm currently using Sql server 2000 for database,
> > > > I use the data adapter wizard for most of the connection in vb,
> > > > and it is connected to the machine name of my computer,
> > > > if i create a setup using for my project,
> > > > Is there a problem for my project to use in another machine
> > > > using that machine's database?
> > > > what can i do to work probably on other machine?
> > > > and how to include the database and install on anonther machine
> > > > using the setup created?
> > > >
> > > >
> > >
> > >
> >
> >
>
>

THX,
but does it work on vb project rather than asp project?

"EricJ" <(E-Mail Removed)> ¼¶¼g©ó¶l¥ó·s»D
:403a06ce$0$322$(E-Mail Removed)...
> small correction it should be appname.exe.config in your bin folder
>
> "EricJ" <(E-Mail Removed)> wrote in message
> news:4039ff6b$0$325$(E-Mail Removed)...
> > i will have to be a bit vague bout that one (i'm working on web forms
atm
> > and thats a bit different)
> >
> > normally you can add a new item to the project and that shouold be an
> > application configuration file (it wil be in the templates) if you leave
> it
> > like that you will have to recompile to change the values if you put a
> .exe
> > behind the name it will take the values without recompiling.
> >
> >
> > the config file would be something like this. (in your app set the
> > connection string to SqlConnection1.ConnectionString)
> > <?xml version="1.0" encoding="utf-8"?>
> >
> > <configuration>
> >
> > <appSettings>
> >
> > <!-- User application and configured property settings go here.-->
> >
> > <!-- Example: <add key="settingName" value="settingValue"/> -->
> >
> > <add key="SqlConnection1.ConnectionString" value="data
> > source=SERVERNAME;database=DBNAME;user id=***;password=*****" />
> >
> > </appSettings>
> >
> > </configuration>
> >
> >
> > "Gene" <(E-Mail Removed)> wrote in message
> > news:e2M0d5g%(E-Mail Removed)...
> > > THX,
> > > but would you mind telling me more on this?
> > > like where is the config file?
> > >
> > > "EricJ" <(E-Mail Removed)> ¼¶¼g©ó¶l¥ó·s»D
> > > :4039b821$0$7032$(E-Mail Removed)...
> > > > hey
> > > >
> > > > you will always have to point your connection string to the right
sql
> > > > server.
> > > > there are several ways to do this i would suggest that you set the
> value
> > > in
> > > > the load of your form, you can hard code it or set a value in your
> > config
> > > > file (progname.exe.config) that way you can change it whithout
> > > recompiling.
> > > >
> > > > hope it helps
> > > >
> > > > eric
> > > >
> > > > "Gene" <(E-Mail Removed)> wrote in message
> > > > news:uiRPd$U%(E-Mail Removed)...
> > > > > hi guys,
> > > > > I'm currently using Sql server 2000 for database,
> > > > > I use the data adapter wizard for most of the connection in vb,
> > > > > and it is connected to the machine name of my computer,
> > > > > if i create a setup using for my project,
> > > > > Is there a problem for my project to use in another machine
> > > > > using that machine's database?
> > > > > what can i do to work probably on other machine?
> > > > > and how to include the database and install on anonther machine
> > > > > using the setup created?
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

yes we have it working on a few vb win form apps
in asp it is easyer (you dont have to do anithing special to the config
file)

"Gene" <(E-Mail Removed)> wrote in message
news:u8wS0Sj%(E-Mail Removed)...
> THX,
> but does it work on vb project rather than asp project?
>
> "EricJ" <(E-Mail Removed)> ¼¶¼g©ó¶l¥ó·s»D
> :403a06ce$0$322$(E-Mail Removed)...
> > small correction it should be appname.exe.config in your bin folder
> >
> > "EricJ" <(E-Mail Removed)> wrote in message
> > news:4039ff6b$0$325$(E-Mail Removed)...
> > > i will have to be a bit vague bout that one (i'm working on web forms
> atm
> > > and thats a bit different)
> > >
> > > normally you can add a new item to the project and that shouold be an
> > > application configuration file (it wil be in the templates) if you
leave
> > it
> > > like that you will have to recompile to change the values if you put a
> > .exe
> > > behind the name it will take the values without recompiling.
> > >
> > >
> > > the config file would be something like this. (in your app set the
> > > connection string to SqlConnection1.ConnectionString)
> > > <?xml version="1.0" encoding="utf-8"?>
> > >
> > > <configuration>
> > >
> > > <appSettings>
> > >
> > > <!-- User application and configured property settings go here.-->
> > >
> > > <!-- Example: <add key="settingName" value="settingValue"/> -->
> > >
> > > <add key="SqlConnection1.ConnectionString" value="data
> > > source=SERVERNAME;database=DBNAME;user id=***;password=*****" />
> > >
> > > </appSettings>
> > >
> > > </configuration>
> > >
> > >
> > > "Gene" <(E-Mail Removed)> wrote in message
> > > news:e2M0d5g%(E-Mail Removed)...
> > > > THX,
> > > > but would you mind telling me more on this?
> > > > like where is the config file?
> > > >
> > > > "EricJ" <(E-Mail Removed)> ¼¶¼g©ó¶l¥ó·s»D
> > > > :4039b821$0$7032$(E-Mail Removed)...
> > > > > hey
> > > > >
> > > > > you will always have to point your connection string to the right
> sql
> > > > > server.
> > > > > there are several ways to do this i would suggest that you set the
> > value
> > > > in
> > > > > the load of your form, you can hard code it or set a value in your
> > > config
> > > > > file (progname.exe.config) that way you can change it whithout
> > > > recompiling.
> > > > >
> > > > > hope it helps
> > > > >
> > > > > eric
> > > > >
> > > > > "Gene" <(E-Mail Removed)> wrote in message
> > > > > news:uiRPd$U%(E-Mail Removed)...
> > > > > > hi guys,
> > > > > > I'm currently using Sql server 2000 for database,
> > > > > > I use the data adapter wizard for most of the connection in vb,
> > > > > > and it is connected to the machine name of my computer,
> > > > > > if i create a setup using for my project,
> > > > > > Is there a problem for my project to use in another machine
> > > > > > using that machine's database?
> > > > > > what can i do to work probably on other machine?
> > > > > > and how to include the database and install on anonther machine
> > > > > > using the setup created?
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

THX!!!
I'll try it

"EricJ" <(E-Mail Removed)> ¼¶¼g©ó¶l¥ó·s»D
:403b09d1$0$324$(E-Mail Removed)...
> yes we have it working on a few vb win form apps
> in asp it is easyer (you dont have to do anithing special to the config
> file)
>
> "Gene" <(E-Mail Removed)> wrote in message
> news:u8wS0Sj%(E-Mail Removed)...
> > THX,
> > but does it work on vb project rather than asp project?
> >
> > "EricJ" <(E-Mail Removed)> ¼¶¼g©ó¶l¥ó·s»D
> > :403a06ce$0$322$(E-Mail Removed)...
> > > small correction it should be appname.exe.config in your bin folder
> > >
> > > "EricJ" <(E-Mail Removed)> wrote in message
> > > news:4039ff6b$0$325$(E-Mail Removed)...
> > > > i will have to be a bit vague bout that one (i'm working on web
forms
> > atm
> > > > and thats a bit different)
> > > >
> > > > normally you can add a new item to the project and that shouold be
an
> > > > application configuration file (it wil be in the templates) if you
> leave
> > > it
> > > > like that you will have to recompile to change the values if you put
a
> > > .exe
> > > > behind the name it will take the values without recompiling.
> > > >
> > > >
> > > > the config file would be something like this. (in your app set the
> > > > connection string to SqlConnection1.ConnectionString)
> > > > <?xml version="1.0" encoding="utf-8"?>
> > > >
> > > > <configuration>
> > > >
> > > > <appSettings>
> > > >
> > > > <!-- User application and configured property settings go here.-->
> > > >
> > > > <!-- Example: <add key="settingName" value="settingValue"/> -->
> > > >
> > > > <add key="SqlConnection1.ConnectionString" value="data
> > > > source=SERVERNAME;database=DBNAME;user id=***;password=*****" />
> > > >
> > > > </appSettings>
> > > >
> > > > </configuration>
> > > >
> > > >
> > > > "Gene" <(E-Mail Removed)> wrote in message
> > > > news:e2M0d5g%(E-Mail Removed)...
> > > > > THX,
> > > > > but would you mind telling me more on this?
> > > > > like where is the config file?
> > > > >
> > > > > "EricJ" <(E-Mail Removed)> ¼¶¼g©ó¶l¥ó·s»D
> > > > > :4039b821$0$7032$(E-Mail Removed)...
> > > > > > hey
> > > > > >
> > > > > > you will always have to point your connection string to the
right
> > sql
> > > > > > server.
> > > > > > there are several ways to do this i would suggest that you set
the
> > > value
> > > > > in
> > > > > > the load of your form, you can hard code it or set a value in
your
> > > > config
> > > > > > file (progname.exe.config) that way you can change it whithout
> > > > > recompiling.
> > > > > >
> > > > > > hope it helps
> > > > > >
> > > > > > eric
> > > > > >
> > > > > > "Gene" <(E-Mail Removed)> wrote in message
> > > > > > news:uiRPd$U%(E-Mail Removed)...
> > > > > > > hi guys,
> > > > > > > I'm currently using Sql server 2000 for database,
> > > > > > > I use the data adapter wizard for most of the connection in
vb,
> > > > > > > and it is connected to the machine name of my computer,
> > > > > > > if i create a setup using for my project,
> > > > > > > Is there a problem for my project to use in another machine
> > > > > > > using that machine's database?
> > > > > > > what can i do to work probably on other machine?
> > > > > > > and how to include the database and install on anonther
machine
> > > > > > > using the setup created?
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>