Groups | Search | Server Info | Login | Register

Groups > comp.lang.basic.visual.database > #5

Re: MSSQL connection string question

Show all headers | View raw

On Mon, 5 Sep 2011 18:24:04 +0000 (UTC), The Dubious Khelair
<khelair@contract.gateway.2wire.net> wrote:
  
>	So basically this is what I'm asking: if I have a connection
>string, say: 
>"PROVIDER=SQLOLEDB; SERVER=<unknown1>\<unknown2>; DATABASE=<unknown3>; " &
>            "UID=<where1>; PWD=<where2>;"
>then where do I find the pieces (on my system) between the <>s?  I've
>got a feeling that <unknown1> is the machine name that I see in the
>filesystem browser under 'network' in explorer.  <unknown2> I'm not sure
>where to get.  

Unknown2 is the instance name on the server.    You could have many
different completely different installations of various versions,
service pack and pactches of SQL server on the same server.   Now you
might only have one instance and/or there is a default instance.    

><unknown3> is that the name of the database or the table?

That'll be the database name not the table name.   A database being a
container for tables, indexes, views, stored procedures, etc, etc,
etc.

>Where in MSSQL do I find the name of the database if it isn't just the
>table?  Also where in MSSQL can I set or find out the UID & PWD in
><where1&2>?

Not sure but you need the SQL Server client tools or whatever exactly
they're called for the version of SQL Server.    Once you have those
installed you will be able to interact directly with the SQL Server.
Basically it's a nice GUI wrapper which executes SQL Server commands
for you.   So that when you tell it to create a table it's actually
executing the DDL to create the table.

That will also allow you poke about in the database and see what is
there already.  You can also create queries in there and test them out
easily.  Then either create views or stored procedures and use them in
your app.

Also your system administrator should give you some or really all of
those details.  

>	Sorry for such a trivial question, but I appreciate very much
>any pointers that you might be able to give.  

Not a trivial question.  I know exactly where you are coming from when
it comes to new platforms.

Also you can download a free copy of SQL Server Express and install it
on your own Windows system to play with it.  You can also use SQL
Server Express in a commercial app although it has some restrictions.
I've read reliable reports of up to 100 users using it.

Tony
-- 
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files 
  updated see http://www.autofeupdater.com/

Back to comp.lang.basic.visual.database | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

MSSQL connection string question The Dubious Khelair <khelair@contract.gateway.2wire.net> - 2011-09-05 18:24 +0000
  Re: MSSQL connection string question The Dubious Khelair <khelair@contract.gateway.2wire.net> - 2011-09-05 18:27 +0000
  Re: MSSQL connection string question Tony Toews <ttoews@telusplanet.net> - 2011-09-05 20:47 -0600
    Re: MSSQL connection string question The Dubious Khelair <khelair@contract.gateway.2wire.net> - 2011-09-06 16:00 +0000

csiph-web