[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.scripting.vbscript

コーチ アウトレット

コーチ アウトレット

SvenC

12/25/2013 10:01:00 AM

&#24373;&#27663;&#12398;&#21521;&#12363;&#12356;&#20596;&#12395;&#12399;&#27515;&#21009;&#12434;&#35328;&#12356;&#28193;&#12375;&#12383;&#35009;&#21028;&#23448; <a href=http://www.dianahoelscher.com/>&#12514;&#12531;&#12463;&#12524;&#12540;&a... &#12480;&#12454;&#12531;</a> 3&#20154;&#12364;&#21271;&#26397;&#39854;&#22269;&#26071;&#12434;&#12496;&#12483;&#12463;&#12395;&#21427;&#12375;&#12356;&#34920; <a href=http://www.dianahoelscher.com/>&#12514;&#12531;&#12463;&#12524;&#12540;&a... &#12480;&#12454;&#12531;</a> &#24773;&#12391;&#24231;&#12387;&#12390;&#12356;&#12427;&#12290;3&#20154;&#12398;&#21069;&#12395;&#12399;&#26360;&#35352;&#23448;1&#20154;&#12364;&#24231;&#12426;&#35009;&#21028;&#20869;&#23481;&#12434; <a href=http://www.dianahoelscher.com/>http://www.dianahoelscher.com/... &#35352;&#37682;&#12375;&#12390;&#12356;&#12427;&#12290;&#21271;&#26397;&#39854;&#12391;40&#24180;&#20313;&#12426;&#12395;&#12431;&#12383;&#12387;&#12390; <a href=http://www.iprviamao.org/>&#12467;&#12540;&a... &#12496;&#12483;&#12464;</a> &#23455;&#21147;&#32773;&#12392;&#12375;&#12390;&#21531;&#33256;&#12375;&#12383;&#24373;&#27663;&#12399;&#12289;&#33853;&#12385;&#12406;&#12428;&#12383;&#23039;&#12392;&#12394;&#12387;&#12390;&#21009;&#22580;&#12398;&#38706;&#12392;&#28040;&#12360;&#12383;&#12290;&#24373;&#27663;&#12399;&#37329;&#26085;&#25104;&#32207;&#21512;&#22823;&#22312;&#23398;&#20013;&#12363;&#12425;&#20132;&#38555;&#12375;&#12390;&#12356;&#12383;&#25925;&#37329; <a href=http://www.iprviamao.org/>&#12467;&#12540;&a... &#36001;&#24067;</a> &#26085;&#25104;&#65288;&#12461;&#12512;&#12452;&#12523;&#12477;&#12531;&#65289;&#20027;&#24109;&#12398;&#38263; <a href=http://www.iprviamao.org/>http://www.iprviamao.org/... &#22899;&#12391;&#29694;&#20826;&#26360;&#35352;&#12398;&#37329;&#24950;&#21916;&#65288;&#12461;&#12512;&#12462;&#12519;&#12531;&#12498;&#65289;&#27663;&#12392;1972&#24180;&#12395;&#32080;&#23130;&#12290;&#26368;&#39640;&#25351; <a href=http://www.bigbendpersimmons.com/>&#12514;&#12531;&#12463;&#12524;&#12540;&a... &#12480;&#12454;&#12531;</a> &#23566;&#32773;&#12398;&#19968;&#26063;&#12395;&#21517;&#12434;&#36899;&#12397;&#12383;&#24373;&#27663;&#12399;&#12289;&#26397;&#39854; <a href=http://www.bigbendpersimmons.com/>&#12514;&#12531;&#12463;&#12524;&#12540;&a... &#12480;&#12454;&#12531;</a> &#21172;&#20685;&#20826;&#12391;&#20986;&#19990;&#34903;&#36947;&#12434;&#31361;&#12365;&#36914;&#12415;&#38738;&#24180;&#20107;&#26989;&#37096;&#38263;&#12420;&#32068;&#32340;&#25351; <a href=http://www.bigbendpersimmons.com/>http://www.bigbendpersimmons.com/... &#23566;&#37096;&#31532;1&#21103;&#37096;&#38263;&#12394;&#12393;&#12398;&#35201;&#32887;&#12434;&#27508;&#20219;&#12375;&#12383;&#12290;
&#12288;
&#12384;&#12364;&#12289;&#12362;&#12356;&#12398;&#37329;&#31532;1&#26360;&#35352;&#12395;&#12424;&#12387;&#12390;&#12300;&#22269;&#23478;&#36578;&#35206;&#38512;&#35584;&#32618;&#12301;&#12395;&#36861; <a href=http://www.longwoodthetachi.com/>&#12475;&#12452;&#12467;&a... &#33109;&#26178;&#35336;</a> &#12356;&#36796;&#12414;&#12428;&#12289;&#20170;&#26376;8&#26085;&#12395;&#20840;&#12390;&#12398;&#24441;&#32887;&#12363;&#12425;&#35299;&#20219; v&#12373;&#12428;&#12383;&#19978;&#12395;&#20826;&#12363; <a href=http://www.longwoodthetachi.com... &#33109;&#26178;&#35336;</a> &#12425;&#12418;&#38500;&#21517;&#12373;&#12428;&#12383;&#12290;&#12381;&#12428;&#12363;&#12425;4&#26085;&#24460;&#12398;&#20966;&#21009;&#12392;&#12394;&#12387;&#12383;&#12290;&#22524;&#29577;&#30476;&#24029;&#21475; <a href=http://www.longwoodthetachi.com/>http://www.longwoodthetachi.com/... &#24066;&#12398;&#28168;&#29983;&#20250;&#24029;&#21475;&#32207;&#21512;&#30149;&#38498;&#12391;&#65298;&#65296;&#65297;&#65297;&#24180;&#12289;&#30475;&#35703;&#24107;&#12425;&#12364;&#22899;&#24615;&#24739;&#32773;&#65288;&#24403;&#26178;&#65303;&#65297;&#27507;&#65289;&#12398;&#23481;&#20307;&#24613;&#22793;&#12434;&#30693;&#12425;&#12379;&#12427;&#12450;&#12521;&#12540;&#12512;&#12434;&#32862;&#12365;&#36867;&#12375;&#12289;&#24739;&#32773;&#12364;&#27515;&#20129;&#12375;&#12383;&#20107; <a href=http://www.solarpanelblueprint.com/>coach&#36001;&#24067;... &#25925;&#12395;&#38306;&#36899;&#12375;&#12390;&#12289;&#12450;&#12521;&#12540;&#12512;&#12408;&#12398;&#23550;&#24540;&#12364; <a href=http://www.solarpanelblueprint.com/>&#12467;&#12540;&a... &#12450;&#12454;&#12488;&#12524;&#12483;&#12488;</a> &#36933;&#12428;&#12383;&#12371;&#12392;&#12395;&#12424;&#12427;&#21516;&#27096;&#12398;&#21307;&#30274;&#20107;&#25925;&#12364;&#12289;&#65298;&#65296;&#65297;&#65296;&#24180;&#65297;&#26376;&#65374;&#65297;&#65299;&#24180;&#65302;&#26376;&#12395;&#23569;&#12394;&#12367;&#12392;&#12418;&#20840; <a href=http://www.solarpanelblueprint.com/>http://www.solarpanelblueprint.com/... &#22269;&#12391;&#65297;&#65303;&#20214;&#30330;&#29983;&#12375;&#12289;&#65303;&#20154;&#12364;&#27515;&#20129;&#12375;&#12390;&#12356;&#12383;&#12371;&#12392;&#12364;&#12289;&#20844;&#30410;&#36001;&#22243;&#27861;&#20154;&#12300;&#26085;&#26412;&#21307;&#30274;&#27231; <a href=http://www.ibabylon.n... &#12502;&#12540;&#12484;</a> &#33021;&#35413;&#20385;&#27231;&#27083;&#12301;&#12408;&#12398;&#22577;&#21578;&#12391;&#12431;&#12363;&#12387;&#12383;&#12290;&#21516;&#27231;&#27083;&#12399;&#21307;&#30274;&#20107;&#25925;&#24773; <a href=http://www.ibabylon.n... &#12450;&#12454;&#12488;&#12524;&#12483;&#12488;</a> &#22577;&#12398;&#22577;&#21578;&#12434;&#30149;&#38498;&#12363;&#12425;&#21463;&#12369;&#12289;&#20998;&#26512; <a href=http://www.ibabylon.net/>http://www.ibabylon.net/... &#12394;&#12393;&#12434;&#12375;&#12390;&#12356;&#12427;&#12290;&#21516;&#27231;&#27083;&#12395;&#12424;&#12427;&#12392;&#12289;&#65297;&#65303;&#20214;&#12398;&#20107;&#25925;&#21407;&#22240;&#12392;&#12375;&#12390;&#12399;&#12289;&#12300;&#20182;&#12398;&#24739;&#32773;&#12395;&#23550;&#24540;&#12375;&#12390;&#12356;&#12390; <a href=http://www.benutravel.com/>&#12475;&#12452;&#12467;&a... &#33109;&#26178;&#35336; &#20154;&#27671;</a> &#27671;&#20184;&#12367;&#12398;&#12364;&#36933;&#12428;&#12383;&#12301;&#12300;&#24120;&#26178;&#12450;&#12521;&#12540;&#12512;&#12364;&#40180;&#12427;&#12383; <a href=http://www.benutravel.com/>&#12475;&#12452;&#12467;&a... &#26178;&#35336; &#20154;&#27671;</a> &#12417;&#26412;&#20154;&#12398;&#24076;&#26395;&#12391;&#20999;&#12387;&#12390;&#12356;&#12383;&#12301;&#12300;&#35079;&#25968;&#12398;&#12450;&#12521;&#12540;&#12512;&#12364;&#38971;&#32321;&#12395;&#40180;&#12427;&#12383;&#12417;&#24931;&#12428;&#12364;&#29983; <a href=http://www.benutravel.com/>http://www.benutravel.com/... &#12376;&#12390;&#12356;&#12383;&#12301;&#12394;&#12393;&#12364;&#25369;&#12370;&#12425;&#12428;&#12390;&#12356;&#12383;&#12290;

William \(Bill\) Vaughn

6/16/2007 3:40:00 AM

Sure, use the SQL Server configuration manager applet. Click on "SQL Native
Client Configuration" and choose "Alias". Fill in the dialog with the Server
as the machine name\instance and an alias name.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"wrytat" <wrytat@discussions.microsoft.com> wrote in message
news:CE902646-8697-42D4-A28B-81AECC71E827@microsoft.com...
> May I ask how do you create a registered Alias?
>
> "William (Bill) Vaughn" wrote:
>
>> One approach that I discuss in my book is to obfuscate the
>> server/instance
>> with a registered Alias. This way you can change the targeted server at
>> will. Yes, it might be important to hide the credentials, but I often
>> create
>> an account on the server with very limited rights for use by a specific
>> application type.
>>
>> --
>> William (Bill) Vaughn
>> Author, Mentor, Consultant
>> Microsoft MVP
>> INETA Speaker
>> www.betav.com/blog/billva
>> www.betav.com
>> Please reply only to the newsgroup so that others can benefit.
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> __________________________________
>> Visit www.hitchhikerguides.net to get more information on my latest
>> books:
>> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) and
>> Hitchhiker's Guide to SQL Server 2005 Compact Edition
>>
>> -----------------------------------------------------------------------------------------------------------------------
>> "wrytat" <wrytat@discussions.microsoft.com> wrote in message
>> news:C6EE2F70-6786-41B6-8809-148A203B362E@microsoft.com...
>> > I'd like to ask for the correct way, or rather say the more advisable
>> > way
>> > to
>> > connect to a SQL Server in a Windows application written in .NET 1.1 or
>> > 2.0.
>> > When I develop my program, the database is located on my machine. But
>> > when
>> > it
>> > is published, the database that it use will be on our server. My
>> > practice
>> > is
>> > to write a class, storing the credentials and information needed to
>> > connect
>> > to the database. And create the DataAdapter by coding (instead of
>> > dragging
>> > the DataAdapter to the form from Tools) in the class. Which should be
>> > the
>> > common practice to be advised?
>>
>>
>>


wrytat

6/18/2007 4:30:00 AM

Hi, how do you get SQL Server configuration manager applet?

"William (Bill) Vaughn" wrote:

> Sure, use the SQL Server configuration manager applet. Click on "SQL Native
> Client Configuration" and choose "Alias". Fill in the dialog with the Server
> as the machine name\instance and an alias name.
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no rights.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> -----------------------------------------------------------------------------------------------------------------------
>
> "wrytat" <wrytat@discussions.microsoft.com> wrote in message
> news:CE902646-8697-42D4-A28B-81AECC71E827@microsoft.com...
> > May I ask how do you create a registered Alias?
> >
> > "William (Bill) Vaughn" wrote:
> >
> >> One approach that I discuss in my book is to obfuscate the
> >> server/instance
> >> with a registered Alias. This way you can change the targeted server at
> >> will. Yes, it might be important to hide the credentials, but I often
> >> create
> >> an account on the server with very limited rights for use by a specific
> >> application type.
> >>
> >> --
> >> William (Bill) Vaughn
> >> Author, Mentor, Consultant
> >> Microsoft MVP
> >> INETA Speaker
> >> www.betav.com/blog/billva
> >> www.betav.com
> >> Please reply only to the newsgroup so that others can benefit.
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >> __________________________________
> >> Visit www.hitchhikerguides.net to get more information on my latest
> >> books:
> >> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) and
> >> Hitchhiker's Guide to SQL Server 2005 Compact Edition
> >>
> >> -----------------------------------------------------------------------------------------------------------------------
> >> "wrytat" <wrytat@discussions.microsoft.com> wrote in message
> >> news:C6EE2F70-6786-41B6-8809-148A203B362E@microsoft.com...
> >> > I'd like to ask for the correct way, or rather say the more advisable
> >> > way
> >> > to
> >> > connect to a SQL Server in a Windows application written in .NET 1.1 or
> >> > 2.0.
> >> > When I develop my program, the database is located on my machine. But
> >> > when
> >> > it
> >> > is published, the database that it use will be on our server. My
> >> > practice
> >> > is
> >> > to write a class, storing the credentials and information needed to
> >> > connect
> >> > to the database. And create the DataAdapter by coding (instead of
> >> > dragging
> >> > the DataAdapter to the form from Tools) in the class. Which should be
> >> > the
> >> > common practice to be advised?
> >>
> >>
> >>
>
>
>

William \(Bill\) Vaughn

6/18/2007 3:55:00 PM

It's installed with SQL Server.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"wrytat" <wrytat@discussions.microsoft.com> wrote in message
news:7B2BC418-026B-4C37-B58F-C0F764FAD9D0@microsoft.com...
> Hi, how do you get SQL Server configuration manager applet?
>
> "William (Bill) Vaughn" wrote:
>
>> Sure, use the SQL Server configuration manager applet. Click on "SQL
>> Native
>> Client Configuration" and choose "Alias". Fill in the dialog with the
>> Server
>> as the machine name\instance and an alias name.
>>
>> --
>> ____________________________________
>> William (Bill) Vaughn
>> Author, Mentor, Consultant
>> Microsoft MVP
>> INETA Speaker
>> www.betav.com/blog/billva
>> www.betav.com
>> Please reply only to the newsgroup so that others can benefit.
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> __________________________________
>> Visit www.hitchhikerguides.net to get more information on my latest book:
>> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
>> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
>> -----------------------------------------------------------------------------------------------------------------------
>>
>> "wrytat" <wrytat@discussions.microsoft.com> wrote in message
>> news:CE902646-8697-42D4-A28B-81AECC71E827@microsoft.com...
>> > May I ask how do you create a registered Alias?
>> >
>> > "William (Bill) Vaughn" wrote:
>> >
>> >> One approach that I discuss in my book is to obfuscate the
>> >> server/instance
>> >> with a registered Alias. This way you can change the targeted server
>> >> at
>> >> will. Yes, it might be important to hide the credentials, but I often
>> >> create
>> >> an account on the server with very limited rights for use by a
>> >> specific
>> >> application type.
>> >>
>> >> --
>> >> William (Bill) Vaughn
>> >> Author, Mentor, Consultant
>> >> Microsoft MVP
>> >> INETA Speaker
>> >> www.betav.com/blog/billva
>> >> www.betav.com
>> >> Please reply only to the newsgroup so that others can benefit.
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >> __________________________________
>> >> Visit www.hitchhikerguides.net to get more information on my latest
>> >> books:
>> >> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) and
>> >> Hitchhiker's Guide to SQL Server 2005 Compact Edition
>> >>
>> >> -----------------------------------------------------------------------------------------------------------------------
>> >> "wrytat" <wrytat@discussions.microsoft.com> wrote in message
>> >> news:C6EE2F70-6786-41B6-8809-148A203B362E@microsoft.com...
>> >> > I'd like to ask for the correct way, or rather say the more
>> >> > advisable
>> >> > way
>> >> > to
>> >> > connect to a SQL Server in a Windows application written in .NET 1.1
>> >> > or
>> >> > 2.0.
>> >> > When I develop my program, the database is located on my machine.
>> >> > But
>> >> > when
>> >> > it
>> >> > is published, the database that it use will be on our server. My
>> >> > practice
>> >> > is
>> >> > to write a class, storing the credentials and information needed to
>> >> > connect
>> >> > to the database. And create the DataAdapter by coding (instead of
>> >> > dragging
>> >> > the DataAdapter to the form from Tools) in the class. Which should
>> >> > be
>> >> > the
>> >> > common practice to be advised?
>> >>
>> >>
>> >>
>>
>>
>>


wrytat

6/19/2007 12:29:00 AM

Sorry, I still can't find it. Is it at SQL Server Client Network Utility? Or
can I find it from Enterprise Manager?

"William (Bill) Vaughn" wrote:

> It's installed with SQL Server.
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no rights.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> -----------------------------------------------------------------------------------------------------------------------
>
> "wrytat" <wrytat@discussions.microsoft.com> wrote in message
> news:7B2BC418-026B-4C37-B58F-C0F764FAD9D0@microsoft.com...
> > Hi, how do you get SQL Server configuration manager applet?
> >
> > "William (Bill) Vaughn" wrote:
> >
> >> Sure, use the SQL Server configuration manager applet. Click on "SQL
> >> Native
> >> Client Configuration" and choose "Alias". Fill in the dialog with the
> >> Server
> >> as the machine name\instance and an alias name.
> >>
> >> --
> >> ____________________________________
> >> William (Bill) Vaughn
> >> Author, Mentor, Consultant
> >> Microsoft MVP
> >> INETA Speaker
> >> www.betav.com/blog/billva
> >> www.betav.com
> >> Please reply only to the newsgroup so that others can benefit.
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >> __________________________________
> >> Visit www.hitchhikerguides.net to get more information on my latest book:
> >> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> >> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> >> -----------------------------------------------------------------------------------------------------------------------
> >>
> >> "wrytat" <wrytat@discussions.microsoft.com> wrote in message
> >> news:CE902646-8697-42D4-A28B-81AECC71E827@microsoft.com...
> >> > May I ask how do you create a registered Alias?
> >> >
> >> > "William (Bill) Vaughn" wrote:
> >> >
> >> >> One approach that I discuss in my book is to obfuscate the
> >> >> server/instance
> >> >> with a registered Alias. This way you can change the targeted server
> >> >> at
> >> >> will. Yes, it might be important to hide the credentials, but I often
> >> >> create
> >> >> an account on the server with very limited rights for use by a
> >> >> specific
> >> >> application type.
> >> >>
> >> >> --
> >> >> William (Bill) Vaughn
> >> >> Author, Mentor, Consultant
> >> >> Microsoft MVP
> >> >> INETA Speaker
> >> >> www.betav.com/blog/billva
> >> >> www.betav.com
> >> >> Please reply only to the newsgroup so that others can benefit.
> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> >> rights.
> >> >> __________________________________
> >> >> Visit www.hitchhikerguides.net to get more information on my latest
> >> >> books:
> >> >> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) and
> >> >> Hitchhiker's Guide to SQL Server 2005 Compact Edition
> >> >>
> >> >> -----------------------------------------------------------------------------------------------------------------------
> >> >> "wrytat" <wrytat@discussions.microsoft.com> wrote in message
> >> >> news:C6EE2F70-6786-41B6-8809-148A203B362E@microsoft.com...
> >> >> > I'd like to ask for the correct way, or rather say the more
> >> >> > advisable
> >> >> > way
> >> >> > to
> >> >> > connect to a SQL Server in a Windows application written in .NET 1.1
> >> >> > or
> >> >> > 2.0.
> >> >> > When I develop my program, the database is located on my machine.
> >> >> > But
> >> >> > when
> >> >> > it
> >> >> > is published, the database that it use will be on our server. My
> >> >> > practice
> >> >> > is
> >> >> > to write a class, storing the credentials and information needed to
> >> >> > connect
> >> >> > to the database. And create the DataAdapter by coding (instead of
> >> >> > dragging
> >> >> > the DataAdapter to the form from Tools) in the class. Which should
> >> >> > be
> >> >> > the
> >> >> > common practice to be advised?
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

William \(Bill\) Vaughn

6/19/2007 3:55:00 PM

Ah, in SQL Server 2000, it's the SS Client Network Utility. I thought you
were running 2005.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"wrytat" <wrytat@discussions.microsoft.com> wrote in message
news:667123B3-BA67-493B-891A-4414F900580C@microsoft.com...
> Sorry, I still can't find it. Is it at SQL Server Client Network Utility?
> Or
> can I find it from Enterprise Manager?
>
> "William (Bill) Vaughn" wrote:
>
>> It's installed with SQL Server.
>>
>> --
>> ____________________________________
>> William (Bill) Vaughn
>> Author, Mentor, Consultant
>> Microsoft MVP
>> INETA Speaker
>> www.betav.com/blog/billva
>> www.betav.com
>> Please reply only to the newsgroup so that others can benefit.
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> __________________________________
>> Visit www.hitchhikerguides.net to get more information on my latest book:
>> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
>> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
>> -----------------------------------------------------------------------------------------------------------------------
>>
>> "wrytat" <wrytat@discussions.microsoft.com> wrote in message
>> news:7B2BC418-026B-4C37-B58F-C0F764FAD9D0@microsoft.com...
>> > Hi, how do you get SQL Server configuration manager applet?
>> >
>> > "William (Bill) Vaughn" wrote:
>> >
>> >> Sure, use the SQL Server configuration manager applet. Click on "SQL
>> >> Native
>> >> Client Configuration" and choose "Alias". Fill in the dialog with the
>> >> Server
>> >> as the machine name\instance and an alias name.
>> >>
>> >> --
>> >> ____________________________________
>> >> William (Bill) Vaughn
>> >> Author, Mentor, Consultant
>> >> Microsoft MVP
>> >> INETA Speaker
>> >> www.betav.com/blog/billva
>> >> www.betav.com
>> >> Please reply only to the newsgroup so that others can benefit.
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >> __________________________________
>> >> Visit www.hitchhikerguides.net to get more information on my latest
>> >> book:
>> >> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
>> >> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
>> >> -----------------------------------------------------------------------------------------------------------------------
>> >>
>> >> "wrytat" <wrytat@discussions.microsoft.com> wrote in message
>> >> news:CE902646-8697-42D4-A28B-81AECC71E827@microsoft.com...
>> >> > May I ask how do you create a registered Alias?
>> >> >
>> >> > "William (Bill) Vaughn" wrote:
>> >> >
>> >> >> One approach that I discuss in my book is to obfuscate the
>> >> >> server/instance
>> >> >> with a registered Alias. This way you can change the targeted
>> >> >> server
>> >> >> at
>> >> >> will. Yes, it might be important to hide the credentials, but I
>> >> >> often
>> >> >> create
>> >> >> an account on the server with very limited rights for use by a
>> >> >> specific
>> >> >> application type.
>> >> >>
>> >> >> --
>> >> >> William (Bill) Vaughn
>> >> >> Author, Mentor, Consultant
>> >> >> Microsoft MVP
>> >> >> INETA Speaker
>> >> >> www.betav.com/blog/billva
>> >> >> www.betav.com
>> >> >> Please reply only to the newsgroup so that others can benefit.
>> >> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> >> rights.
>> >> >> __________________________________
>> >> >> Visit www.hitchhikerguides.net to get more information on my latest
>> >> >> books:
>> >> >> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
>> >> >> and
>> >> >> Hitchhiker's Guide to SQL Server 2005 Compact Edition
>> >> >>
>> >> >> -----------------------------------------------------------------------------------------------------------------------
>> >> >> "wrytat" <wrytat@discussions.microsoft.com> wrote in message
>> >> >> news:C6EE2F70-6786-41B6-8809-148A203B362E@microsoft.com...
>> >> >> > I'd like to ask for the correct way, or rather say the more
>> >> >> > advisable
>> >> >> > way
>> >> >> > to
>> >> >> > connect to a SQL Server in a Windows application written in .NET
>> >> >> > 1.1
>> >> >> > or
>> >> >> > 2.0.
>> >> >> > When I develop my program, the database is located on my machine.
>> >> >> > But
>> >> >> > when
>> >> >> > it
>> >> >> > is published, the database that it use will be on our server. My
>> >> >> > practice
>> >> >> > is
>> >> >> > to write a class, storing the credentials and information needed
>> >> >> > to
>> >> >> > connect
>> >> >> > to the database. And create the DataAdapter by coding (instead of
>> >> >> > dragging
>> >> >> > the DataAdapter to the form from Tools) in the class. Which
>> >> >> > should
>> >> >> > be
>> >> >> > the
>> >> >> > common practice to be advised?
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>


wrytat

6/20/2007 3:39:00 AM

Ok, I have added the alias at Client Network Utility, and registered at the
Enterprise Manager. However, when I go to Visual Studio 2005, my project, I
look at the Server Explorer, the database that I registered did not appear,
no matter how many times I refresh... Were what I did correct?

"William (Bill) Vaughn" wrote:

> Ah, in SQL Server 2000, it's the SS Client Network Utility. I thought you
> were running 2005.
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no rights.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> -----------------------------------------------------------------------------------------------------------------------
>
> "wrytat" <wrytat@discussions.microsoft.com> wrote in message
> news:667123B3-BA67-493B-891A-4414F900580C@microsoft.com...
> > Sorry, I still can't find it. Is it at SQL Server Client Network Utility?
> > Or
> > can I find it from Enterprise Manager?
> >
> > "William (Bill) Vaughn" wrote:
> >
> >> It's installed with SQL Server.
> >>
> >> --
> >> ____________________________________
> >> William (Bill) Vaughn
> >> Author, Mentor, Consultant
> >> Microsoft MVP
> >> INETA Speaker
> >> www.betav.com/blog/billva
> >> www.betav.com
> >> Please reply only to the newsgroup so that others can benefit.
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >> __________________________________
> >> Visit www.hitchhikerguides.net to get more information on my latest book:
> >> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> >> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> >> -----------------------------------------------------------------------------------------------------------------------
> >>
> >> "wrytat" <wrytat@discussions.microsoft.com> wrote in message
> >> news:7B2BC418-026B-4C37-B58F-C0F764FAD9D0@microsoft.com...
> >> > Hi, how do you get SQL Server configuration manager applet?
> >> >
> >> > "William (Bill) Vaughn" wrote:
> >> >
> >> >> Sure, use the SQL Server configuration manager applet. Click on "SQL
> >> >> Native
> >> >> Client Configuration" and choose "Alias". Fill in the dialog with the
> >> >> Server
> >> >> as the machine name\instance and an alias name.
> >> >>
> >> >> --
> >> >> ____________________________________
> >> >> William (Bill) Vaughn
> >> >> Author, Mentor, Consultant
> >> >> Microsoft MVP
> >> >> INETA Speaker
> >> >> www.betav.com/blog/billva
> >> >> www.betav.com
> >> >> Please reply only to the newsgroup so that others can benefit.
> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> >> rights.
> >> >> __________________________________
> >> >> Visit www.hitchhikerguides.net to get more information on my latest
> >> >> book:
> >> >> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> >> >> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> >> >> -----------------------------------------------------------------------------------------------------------------------
> >> >>
> >> >> "wrytat" <wrytat@discussions.microsoft.com> wrote in message
> >> >> news:CE902646-8697-42D4-A28B-81AECC71E827@microsoft.com...
> >> >> > May I ask how do you create a registered Alias?
> >> >> >
> >> >> > "William (Bill) Vaughn" wrote:
> >> >> >
> >> >> >> One approach that I discuss in my book is to obfuscate the
> >> >> >> server/instance
> >> >> >> with a registered Alias. This way you can change the targeted
> >> >> >> server
> >> >> >> at
> >> >> >> will. Yes, it might be important to hide the credentials, but I
> >> >> >> often
> >> >> >> create
> >> >> >> an account on the server with very limited rights for use by a
> >> >> >> specific
> >> >> >> application type.
> >> >> >>
> >> >> >> --
> >> >> >> William (Bill) Vaughn
> >> >> >> Author, Mentor, Consultant
> >> >> >> Microsoft MVP
> >> >> >> INETA Speaker
> >> >> >> www.betav.com/blog/billva
> >> >> >> www.betav.com
> >> >> >> Please reply only to the newsgroup so that others can benefit.
> >> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> >> >> rights.
> >> >> >> __________________________________
> >> >> >> Visit www.hitchhikerguides.net to get more information on my latest
> >> >> >> books:
> >> >> >> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> >> >> >> and
> >> >> >> Hitchhiker's Guide to SQL Server 2005 Compact Edition
> >> >> >>
> >> >> >> -----------------------------------------------------------------------------------------------------------------------
> >> >> >> "wrytat" <wrytat@discussions.microsoft.com> wrote in message
> >> >> >> news:C6EE2F70-6786-41B6-8809-148A203B362E@microsoft.com...
> >> >> >> > I'd like to ask for the correct way, or rather say the more
> >> >> >> > advisable
> >> >> >> > way
> >> >> >> > to
> >> >> >> > connect to a SQL Server in a Windows application written in .NET
> >> >> >> > 1.1
> >> >> >> > or
> >> >> >> > 2.0.
> >> >> >> > When I develop my program, the database is located on my machine.
> >> >> >> > But
> >> >> >> > when
> >> >> >> > it
> >> >> >> > is published, the database that it use will be on our server. My
> >> >> >> > practice
> >> >> >> > is
> >> >> >> > to write a class, storing the credentials and information needed
> >> >> >> > to
> >> >> >> > connect
> >> >> >> > to the database. And create the DataAdapter by coding (instead of
> >> >> >> > dragging
> >> >> >> > the DataAdapter to the form from Tools) in the class. Which
> >> >> >> > should
> >> >> >> > be
> >> >> >> > the
> >> >> >> > common practice to be advised?
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

William \(Bill\) Vaughn

6/20/2007 3:49:00 PM

It won't appear on its own. To use the alias, you need to create a Database Connection in the server explorer and set "Server" to the alias instead of the machine\instance designation.




--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"wrytat" <wrytat@discussions.microsoft.com> wrote in message news:9A90F3AA-7610-41AE-BF2A-F6D20C699F24@microsoft.com...
> Ok, I have added the alias at Client Network Utility, and registered at the
> Enterprise Manager. However, when I go to Visual Studio 2005, my project, I
> look at the Server Explorer, the database that I registered did not appear,
> no matter how many times I refresh... Were what I did correct?
>
> "William (Bill) Vaughn" wrote:
>
>> Ah, in SQL Server 2000, it's the SS Client Network Utility. I thought you
>> were running 2005.
>>
>> --
>> ____________________________________
>> William (Bill) Vaughn
>> Author, Mentor, Consultant
>> Microsoft MVP
>> INETA Speaker
>> www.betav.com/blog/billva
>> www.betav.com
>> Please reply only to the newsgroup so that others can benefit.
>> This posting is provided "AS IS" with no warranties, and confers no rights.
>> __________________________________
>> Visit www.hitchhikerguides.net to get more information on my latest book:
>> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
>> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
>> -----------------------------------------------------------------------------------------------------------------------
>>
>> "wrytat" <wrytat@discussions.microsoft.com> wrote in message
>> news:667123B3-BA67-493B-891A-4414F900580C@microsoft.com...
>> > Sorry, I still can't find it. Is it at SQL Server Client Network Utility?
>> > Or
>> > can I find it from Enterprise Manager?
>> >
>> > "William (Bill) Vaughn" wrote:
>> >
>> >> It's installed with SQL Server.
>> >>
>> >> --
>> >> ____________________________________
>> >> William (Bill) Vaughn
>> >> Author, Mentor, Consultant
>> >> Microsoft MVP
>> >> INETA Speaker
>> >> www.betav.com/blog/billva
>> >> www.betav.com
>> >> Please reply only to the newsgroup so that others can benefit.
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >> __________________________________
>> >> Visit www.hitchhikerguides.net to get more information on my latest book:
>> >> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
>> >> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
>> >> -----------------------------------------------------------------------------------------------------------------------
>> >>
>> >> "wrytat" <wrytat@discussions.microsoft.com> wrote in message
>> >> news:7B2BC418-026B-4C37-B58F-C0F764FAD9D0@microsoft.com...
>> >> > Hi, how do you get SQL Server configuration manager applet?
>> >> >
>> >> > "William (Bill) Vaughn" wrote:
>> >> >
>> >> >> Sure, use the SQL Server configuration manager applet. Click on "SQL
>> >> >> Native
>> >> >> Client Configuration" and choose "Alias". Fill in the dialog with the
>> >> >> Server
>> >> >> as the machine name\instance and an alias name.
>> >> >>
>> >> >> --
>> >> >> ____________________________________
>> >> >> William (Bill) Vaughn
>> >> >> Author, Mentor, Consultant
>> >> >> Microsoft MVP
>> >> >> INETA Speaker
>> >> >> www.betav.com/blog/billva
>> >> >> www.betav.com
>> >> >> Please reply only to the newsgroup so that others can benefit.
>> >> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> >> rights.
>> >> >> __________________________________
>> >> >> Visit www.hitchhikerguides.net to get more information on my latest
>> >> >> book:
>> >> >> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
>> >> >> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
>> >> >> -----------------------------------------------------------------------------------------------------------------------
>> >> >>
>> >> >> "wrytat" <wrytat@discussions.microsoft.com> wrote in message
>> >> >> news:CE902646-8697-42D4-A28B-81AECC71E827@microsoft.com...
>> >> >> > May I ask how do you create a registered Alias?
>> >> >> >
>> >> >> > "William (Bill) Vaughn" wrote:
>> >> >> >
>> >> >> >> One approach that I discuss in my book is to obfuscate the
>> >> >> >> server/instance
>> >> >> >> with a registered Alias. This way you can change the targeted
>> >> >> >> server
>> >> >> >> at
>> >> >> >> will. Yes, it might be important to hide the credentials, but I
>> >> >> >> often
>> >> >> >> create
>> >> >> >> an account on the server with very limited rights for use by a
>> >> >> >> specific
>> >> >> >> application type.
>> >> >> >>
>> >> >> >> --
>> >> >> >> William (Bill) Vaughn
>> >> >> >> Author, Mentor, Consultant
>> >> >> >> Microsoft MVP
>> >> >> >> INETA Speaker
>> >> >> >> www.betav.com/blog/billva
>> >> >> >> www.betav.com
>> >> >> >> Please reply only to the newsgroup so that others can benefit.
>> >> >> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> >> >> rights.
>> >> >> >> __________________________________
>> >> >> >> Visit www.hitchhikerguides.net to get more information on my latest
>> >> >> >> books:
>> >> >> >> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
>> >> >> >> and
>> >> >> >> Hitchhiker's Guide to SQL Server 2005 Compact Edition
>> >> >> >>
>> >> >> >> -----------------------------------------------------------------------------------------------------------------------
>> >> >> >> "wrytat" <wrytat@discussions.microsoft.com> wrote in message
>> >> >> >> news:C6EE2F70-6786-41B6-8809-148A203B362E@microsoft.com...
>> >> >> >> > I'd like to ask for the correct way, or rather say the more
>> >> >> >> > advisable
>> >> >> >> > way
>> >> >> >> > to
>> >> >> >> > connect to a SQL Server in a Windows application written in .NET
>> >> >> >> > 1.1
>> >> >> >> > or
>> >> >> >> > 2.0.
>> >> >> >> > When I develop my program, the database is located on my machine.
>> >> >> >> > But
>> >> >> >> > when
>> >> >> >> > it
>> >> >> >> > is published, the database that it use will be on our server. My
>> >> >> >> > practice
>> >> >> >> > is
>> >> >> >> > to write a class, storing the credentials and information needed
>> >> >> >> > to
>> >> >> >> > connect
>> >> >> >> > to the database. And create the DataAdapter by coding (instead of
>> >> >> >> > dragging
>> >> >> >> > the DataAdapter to the form from Tools) in the class. Which
>> >> >> >> > should
>> >> >> >> > be
>> >> >> >> > the
>> >> >> >> > common practice to be advised?
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>

Servizio di avviso nuovi messaggi
Ricevi direttamente nella tua mail i nuovi messaggi per
コーチ アウトレット

Inserendo la tua e-mail nella casella sotto, riceverai un avviso tramite posta elettronica ogni volta che il motore di ricerca troverà un nuovo messaggio per te

Il servizio è completamente GRATUITO!