Groups | Search | Server Info | Keyboard shortcuts | Login | Register

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

MSSQL connection string question

Show all headers | 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