Re: [Squirrel-sql-users] Connecting to MS SQL Server 2005 -LostCode Completion

[David G <jam...@gm...>]

Yes, I appended the user and password vars to the query string in the "URL"
box.  I see you are splitting up the string with the plus concatenation
operator.  Mine is just all one string.

This is what I tried...

jdbc:sqlserver://MY_DB:1433;databaseName=DB_NAME;user=USERNAME;password=MYPASS

... with my username and pw in the fields as well.

I also tried with and without the domain on my username. If I do have to put
in the domain, it is domain BACKSLASH username, right?



On Tue, Apr 28, 2009 at 12:11 PM, Savoy, Melinda <
Mel...@te...> wrote:

>  In the ALIAS dialog box:
>
>
>
> Name:      Whatever you call that connection
>
> Driver:     Microsoft MSSQL Server JDBC Driver
>
> URL:        jdbc:sqlserver:// SQLSVR:1433;" +
> "databaseName=DBNAME;user=uname;password=pw
>
> User Name:             uname
>
> Password:              pw
>
>
>
> Please note the user and password on the URL as well as the syntax used in
> the URL.  Not just what is in the User Name and Password fields
>
>
>
> I am assuming you appended the user info there.  Is that correct?
>
>
>
>
>
> *From:* David G [mailto:jam...@gm...]
> *Sent:* Tuesday, April 28, 2009 11:02 AM
> *To:* Savoy, Melinda
>
> *Subject:* Re: [Squirrel-sql-users] Connecting to MS SQL Server 2005
> -LostCode Completion
>
>
>
> Thanks, but no dice... yet.  I tried different variations with and without
> the domain, but nothing worked.
>
> I tried it with and without also putting my user info in the separate boxes
> for it.  Do you also put your username and pw in the boxes as well?
>
>  On Tue, Apr 28, 2009 at 11:17 AM, Savoy, Melinda <
> Mel...@te...> wrote:
>
> Append the following:  user=uname;password=pw
>
>
>
> Hope that helps
>
>
>
> *From:* Savoy, Melinda
> *Sent:* Tuesday, April 28, 2009 10:15 AM
> *To:* David G; squ...@li...
>
>
> *Subject:* Re: [Squirrel-sql-users] Connecting to MS SQL Server 2005
> -LostCode Completion
>
>
>
> I think you also need the username and password. That is what I had to do.
>
>
>
> *From:* David G [mailto:jam...@gm...]
> *Sent:* Tuesday, April 28, 2009 10:11 AM
> *To:* squ...@li...
> *Subject:* Re: [Squirrel-sql-users] Connecting to MS SQL Server 2005 -
> LostCode Completion
>
>
>
> Thanks Rob. I downloaded the JAR from Microsoft.
>
> Here's my connection string....
>
> jdbc:sqlserver://DB_SERVER_NAME:1433;database=MY_DATABASE
>
> I'm getting a "login failed" error.  I've tried just my username,
> domain\usernam, domain/username, but nothing. I can get in through MS SQL
> Management Studio, but I have to specify the database name, or it won't let
> me in.
>
> I know my server name and database name are right.
> I've tried it with and without the port number.
>
> Any clue anyone?
>
> On Mon, Apr 27, 2009 at 8:19 PM, Robert Manning <
> rob...@gm...> wrote:
>
> It's likely that the JDBC-ODBC bridge driver doesn't provide the
> column information needed to populate the code-completion.  You should
> get the latest JDBC driver (.jar file) that is available for your
> database from your database vendor, copy that driver into
> <SQUIRREL_HOME>/lib and update your alias to use the new driver
> definition.
> You will most likely need to change the JDBC URL to work with the JDBC
> driver.
>
> Rob
>
>
> On Mon, Apr 27, 2009 at 5:07 PM, David G <jam...@gm...> wrote:
> > I just installed Squirrel 3.0.1 and no longer have my columns appear in
> the
> > Ctrl-Space code completion any more.  I'm hoping someone can help.
> >
> > I had a hard drive crash, and I've had to reconstruct everything.  It
> just
> > worked the first time when I installed in on my old computer.
> >
> > The only DB driver I have when viewing through Squirrel is JDBC ODBC
> > bridge.  I don't know if that's the one I used last time or not.
> >
> > I don't really know what other info to provide, but will gladly upon
> > request.
> >
> > Thanks.
> >
> > David
> > Win XP Pro
> > Squirrel 3.0.1
> > MS Sql Server 2005
> >
> >
> >
>
> >
> ------------------------------------------------------------------------------
> > Crystal Reports &#45; New Free Runtime and 30 Day Trial
> > Check out the new simplified licensign option that enables unlimited
> > royalty&#45;free distribution of the report engine for externally facing
> > server and web deployment.
> > http://p.sf.net/sfu/businessobjects
> > _______________________________________________
> > Squirrel-sql-users mailing list
> > Squ...@li...
> > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> >
> >
>
>
>
>
> The information contained in this message and any attachments is intended
> only for the use of the individual or entity to which it is addressed, and
> may contain information that is PRIVILEGED, CONFIDENTIAL, and exempt from
> disclosure under applicable law. If you are not the intended recipient, you
> are prohibited from copying, distributing, or using the information. Please
> contact the sender immediately by return e-mail and delete the original
> message from your system.
>
>
> The information contained in this message and any attachments is intended
> only for the use of the individual or entity to which it is addressed, and
> may contain information that is PRIVILEGED, CONFIDENTIAL, and exempt from
> disclosure under applicable law. If you are not the intended recipient, you
> are prohibited from copying, distributing, or using the information. Please
> contact the sender immediately by return e-mail and delete the original
> message from your system.
>
>
>
> ------------------------------------------------------------------------------
> Register Now & Save for Velocity, the Web Performance & Operations
> Conference from O'Reilly Media. Velocity features a full day of
> expert-led, hands-on workshops and two days of sessions from industry
> leaders in dedicated Performance & Operations tracks. Use code vel09scf
> and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>
>
> The information contained in this message and any attachments is intended
> only for the use of the individual or entity to which it is addressed, and
> may contain information that is PRIVILEGED, CONFIDENTIAL, and exempt from
> disclosure under applicable law. If you are not the intended recipient, you
> are prohibited from copying, distributing, or using the information. Please
> contact the sender immediately by return e-mail and delete the original
> message from your system.
>