Common SQL connection help

Can someone share with me code for the following task please?
1) User clicks a button(button1), to bring up a file location window for the
user to select the SQL Server 2000 and Pub database on the network(not
onhis/her current machine so the user needs to create the correct path).
2)That user selction will then create the SQL connection.
3) ListBox1 on Form1 will then show the authors in the Pubs database.

Thank you for any help with this, I think once I get past this point I will
break thru this wall I have hit for connecting to a SQL server that is not my
workstation.

Mike

Bernie
Wed Jan 26 15:30:29 CST 2005

Hi Mike,

The answer's really pretty simple: put the app on a shared network drive;
then structure the connectionstring calling the server by name (eg,
ASCCOSVR), etc.

I do this with all of the apps I build for clients on servers; the
workstations connect to the server without any difficulty.

HTH,

Bernie Yaeger

"fsu_mike" <fsumike@discussions.microsoft.com> wrote in message
news:7B2DE70A-46F4-4FA9-89B9-0896712A3E77@microsoft.com...
> Can someone share with me code for the following task please?
> 1) User clicks a button(button1), to bring up a file location window for
> the
> user to select the SQL Server 2000 and Pub database on the network(not
> onhis/her current machine so the user needs to create the correct path).
> 2)That user selction will then create the SQL connection.
> 3) ListBox1 on Form1 will then show the authors in the Pubs database.
>
> Thank you for any help with this, I think once I get past this point I
> will
> break thru this wall I have hit for connecting to a SQL server that is not
> my
> workstation.
>
> Mike

W
Wed Jan 26 16:24:17 CST 2005

What do you mean about file location. Do you need to see all of the Sql
Servers running on the network - or do you need to point to the mdf file?

--
W.G. Ryan, MVP

www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"fsu_mike" <fsumike@discussions.microsoft.com> wrote in message
news:7B2DE70A-46F4-4FA9-89B9-0896712A3E77@microsoft.com...
> Can someone share with me code for the following task please?
> 1) User clicks a button(button1), to bring up a file location window for
the
> user to select the SQL Server 2000 and Pub database on the network(not
> onhis/her current machine so the user needs to create the correct path).
> 2)That user selction will then create the SQL connection.
> 3) ListBox1 on Form1 will then show the authors in the Pubs database.
>
> Thank you for any help with this, I think once I get past this point I
will
> break thru this wall I have hit for connecting to a SQL server that is not
my
> workstation.
>
> Mike

fsumike
Thu Jan 27 07:31:02 CST 2005

I want the user to be prompted with a directory window to select the server
on the network, I have more than one SQL server. With this example I am
using the Pubs database, and the authors table. So the user can run the
program once to select Server1, and the next time they can select Server2,
but then use the Pubs database no matter which server they select. The
listbox1 will display authors.

Thanks

"W.G. Ryan eMVP" wrote:

> What do you mean about file location. Do you need to see all of the Sql
> Servers running on the network - or do you need to point to the mdf file?
>
> --
> W.G. Ryan, MVP
>
> www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
> "fsu_mike" <fsumike@discussions.microsoft.com> wrote in message
> news:7B2DE70A-46F4-4FA9-89B9-0896712A3E77@microsoft.com...
> > Can someone share with me code for the following task please?
> > 1) User clicks a button(button1), to bring up a file location window for
> the
> > user to select the SQL Server 2000 and Pub database on the network(not
> > onhis/her current machine so the user needs to create the correct path).
> > 2)That user selction will then create the SQL connection.
> > 3) ListBox1 on Form1 will then show the authors in the Pubs database.
> >
> > Thank you for any help with this, I think once I get past this point I
> will
> > break thru this wall I have hit for connecting to a SQL server that is not
> my
> > workstation.
> >
> > Mike
>
>
>

W
Thu Jan 27 09:24:05 CST 2005

http://www.codeproject.com/cs/database/LocatingSql.asp
http://www.csharphelp.com/archives2/archive342.html

--
W.G. Ryan, MVP

www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"fsu_mike" <fsumike@discussions.microsoft.com> wrote in message
news:C3D1942C-74B8-449E-A592-2B092C659FFD@microsoft.com...
> I want the user to be prompted with a directory window to select the
server
> on the network, I have more than one SQL server. With this example I am
> using the Pubs database, and the authors table. So the user can run the
> program once to select Server1, and the next time they can select Server2,
> but then use the Pubs database no matter which server they select. The
> listbox1 will display authors.
>
> Thanks
>
> "W.G. Ryan eMVP" wrote:
>
> > What do you mean about file location. Do you need to see all of the
Sql
> > Servers running on the network - or do you need to point to the mdf
file?
> >
> > --
> > W.G. Ryan, MVP
> >
> > www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
> > "fsu_mike" <fsumike@discussions.microsoft.com> wrote in message
> > news:7B2DE70A-46F4-4FA9-89B9-0896712A3E77@microsoft.com...
> > > Can someone share with me code for the following task please?
> > > 1) User clicks a button(button1), to bring up a file location window
for
> > the
> > > user to select the SQL Server 2000 and Pub database on the network(not
> > > onhis/her current machine so the user needs to create the correct
path).
> > > 2)That user selction will then create the SQL connection.
> > > 3) ListBox1 on Form1 will then show the authors in the Pubs database.
> > >
> > > Thank you for any help with this, I think once I get past this point I
> > will
> > > break thru this wall I have hit for connecting to a SQL server that is
not
> > my
> > > workstation.
> > >
> > > Mike
> >
> >
> >

fsumike
Thu Jan 27 11:19:02 CST 2005

Thanks, but I don't want to use ODBC, want to use the SQLconnection process.

"W.G. Ryan eMVP" wrote:

> http://www.codeproject.com/cs/database/LocatingSql.asp
> http://www.csharphelp.com/archives2/archive342.html
>
> --
> W.G. Ryan, MVP
>
> www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
> "fsu_mike" <fsumike@discussions.microsoft.com> wrote in message
> news:C3D1942C-74B8-449E-A592-2B092C659FFD@microsoft.com...
> > I want the user to be prompted with a directory window to select the
> server
> > on the network, I have more than one SQL server. With this example I am
> > using the Pubs database, and the authors table. So the user can run the
> > program once to select Server1, and the next time they can select Server2,
> > but then use the Pubs database no matter which server they select. The
> > listbox1 will display authors.
> >
> > Thanks
> >
> > "W.G. Ryan eMVP" wrote:
> >
> > > What do you mean about file location. Do you need to see all of the
> Sql
> > > Servers running on the network - or do you need to point to the mdf
> file?
> > >
> > > --
> > > W.G. Ryan, MVP
> > >
> > > www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
> > > "fsu_mike" <fsumike@discussions.microsoft.com> wrote in message
> > > news:7B2DE70A-46F4-4FA9-89B9-0896712A3E77@microsoft.com...
> > > > Can someone share with me code for the following task please?
> > > > 1) User clicks a button(button1), to bring up a file location window
> for
> > > the
> > > > user to select the SQL Server 2000 and Pub database on the network(not
> > > > onhis/her current machine so the user needs to create the correct
> path).
> > > > 2)That user selction will then create the SQL connection.
> > > > 3) ListBox1 on Form1 will then show the authors in the Pubs database.
> > > >
> > > > Thank you for any help with this, I think once I get past this point I
> > > will
> > > > break thru this wall I have hit for connecting to a SQL server that is
> not
> > > my
> > > > workstation.
> > > >
> > > > Mike
> > >
> > >
> > >
>
>
>