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 <MelindaSavoy@texashealth.org> 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:jamdavidg@gmail.com]
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 <MelindaSavoy@texashealth.org> 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; squirrel-sql-users@lists.sourceforge.net


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:jamdavidg@gmail.com]
Sent: Tuesday, April 28, 2009 10:11 AM
To: squirrel-sql-users@lists.sourceforge.net
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 <robert.m.manning@gmail.com> 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 <jamdavidg@gmail.com> 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
> Squirrel-sql-users@lists.sourceforge.net
> 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
Squirrel-sql-users@lists.sourceforge.net
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.