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.