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

MSSQL connection string question

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail
From	The Dubious Khelair <khelair@contract.gateway.2wire.net>
Newsgroups	comp.lang.basic.visual.database
Subject	MSSQL connection string question
Date	Mon, 5 Sep 2011 18:24:04 +0000 (UTC)
Organization	A noiseless patient Spider
Lines	39
Message-ID	<j43443$csq$1@dont-email.me> (permalink)
Injection-Date	Mon, 5 Sep 2011 18:24:04 +0000 (UTC)
Injection-Info	mx04.eternal-september.org; posting-host="yP0Egf9Tb1duSFKXytcO3g"; logging-data="13210"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+KO5BAoI6XW8tqPjuL6wZitHTsq3LBD7E="
Summary	Derivation of MSSQL connection string
Keywords	MSSQL,ADODB,connection,string
User-Agent	tin/1.8.3-20070201 ("Scotasay") (UNIX) (OpenBSD/4.9 (i386))
Cancel-Lock	sha1:XQ+Tpyo67dTf/oD7cNljGP7AFrE=
Xref	x330-a1.tempe.blueboxinc.net comp.lang.basic.visual.database:3

Show key headers only | View raw

	I have what is going to be [in my estimation] an almost
embarrassingly easy question for y'all.  I've done 99% of my coding and
scripting in a UNIX environment and have only recently started in the
windows environment with a trivial class on Visual Basic and a book on
Visual C++.
	I managed to snag an internship, despite my limited experience
in the windows environment, writing an ASP application for a web-survey
with a MSSQL back end.  This wasn't too terribly tough for me, primarily
because I've done a lot of work with JSP in the past and everything just
kind of fell into place when I looked at it.
	Now I'm working on a client application, not web based, just
straight VB, and there's one thing that is really holding me back.  I
only have the development environment that I need when I'm working on
site, and I try to put in more hours from home on it.  My lack of a
database is obviously holding me back quite a bit here.  I have created
a new table in an MSSQL database that I've set up (first time using that
software) with the exact same structure as the one I use at work, but
I'm unable to connect to it, primarily because I don't know how the
connection string is derived from the information that I have, and
because I don't know how to pull up these credentials anywhere on my
system.  (Yeah, I'm a lot more at home in UNIX)
	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.  <unknown3> is that the name of the database or the table?
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>?
	Sorry for such a trivial question, but I appreciate very much
any pointers that you might be able to give.  Once this portion is figured
out I should be able to proceed on my application much faster, with a
database clone that I can use for testing at home.
	Thanks in advance.

					Khelair

Back to comp.lang.basic.visual.database | Next — 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