Re: Connection String for MS SQL

[Douglas Belcher <dougdbkv@xxxxxxxxx>]

Craig,

Sorry for not providing enough detail on the first post, I know what I was
talking about :)

I have added a plugin to WDSc called Quantum DB that allows me to execute
SQL statements against a number of different databases, i.e. DB2, Oracle, MS
SQL, etc.  I had these setup at a previous job but have not had the need to
do it at my current job until now.  What I needed to do was find the jar
file containing the jdbc driver to allow for the connection to the data base
and then provide the connection url to communicate with it.  I found the
driver and have not yet been able to figure out the parms on the connection
url to successfully connect.  I appreciate the site you sent me to but it
did not quite get me the results that I needed.  I was hoping that someone
had the plugin and the connection url so I could see where I was going wrong
and adapt it to my environment.

Thanks

Doug Belcher
St Louis, MO
314-766-4461

On Mon, May 2, 2011 at 2:45 PM, Craig Pelkie <craig@xxxxxxxxxx> wrote:

> I'm not exactly sure what you need, but this site is a good reference for
> many DB connection strings:
>
> http://www.connectionstrings.com
>
> Craig Pelkie
>
> > -----Original Message-----
> > From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-
> > bounces@xxxxxxxxxxxx] On Behalf Of Douglas Belcher
> > Sent: Monday, May 02, 2011 10:21 AM
> > To: WDSc for iSeries
> > Subject: [WDSCI-L] Connection String for MS SQL
>  >
> > Did a quick check in the archives and did not find this, but does anyone
> have a
> > connection string for connecting to an MS SQL database for Quantum DB?
> >
> > --
> > Doug Belcher
> > St Louis, MO
> > 314-766-4461
> > --
> > This is the Rational Developer for IBM i / Websphere Development Studio
> > Client for System i & iSeries  (WDSCI-L) mailing list To post a message
> email:
> > WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
> > or email: WDSCI-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives at
> > http://archive.midrange.com/wdsci-l.
>
> --
> This is the Rational Developer for IBM i / Websphere Development Studio
> Client for System i & iSeries  (WDSCI-L) mailing list
> To post a message email: WDSCI-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
> or email: WDSCI-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/wdsci-l.