Connecting to Sql Server 2008

[ChakrabortyAnshu]

Hi,
Currently i am using netbeans 6.8 and Windows vista (operating system).
I was able to Connect to the SQL server using Service section (JDBC-ODBC Bridge) connecting to a DNS. and was able to get successful results to the queries fired.
But when i am trying to create a new Database project it is not allowing me to Connect to any of the table and throws error as "Connected Database contains only tables without primary keys."

Please help

[bskrbec]

I'm getting the same error message. Database is a SQL Server 2005 instance, and these tables are definitely indexed, so the message really doesn't make any sense. I'm connecting via ODBC/JDBC

Any insight as to why Netbeans thinks otherwise?

[ChakrabortyAnshu]

hey,

Still not been able to find any solution.
Currently using my connectivity through jtds-1.2.

This is good too. But it would be better if we could find some way out for Netbeans connectivity.

By the way Indexing is required for faster data access in a table.
But error is totally different.
it says most of the tables doesn't contain primay keys which is not at all true.

[ChakrabortyAnshu]

Hi brickshaw,

Thanks for your concern..

Guys,

I am sure more people must have gone through the same (may be in previous netbeans versions).

If anybody has solution to this please help.

[ChakrabortyAnshu]

Guys,

I used jtds-1.2.jar Driver for Connection..
It was better than conventional Connection.

You guys also try this out...
Its better but still doesn't meet to our satisfaction.

[ChakrabortyAnshu]

Guys any luck... . Did you try using JTDS jar .

[Andreas Ernst]

Am 27.04.2010 09:22, schrieb ChakrabortyAnshu:

[julsorio]

On 27 April 2010 12:18, Andreas Ernst <address-removed ([email]address-removed[/email])> wrote:

[ChakrabortyAnshu]

Hi Andreas,

If we implement jar files in the code it works. But i was trying something shown in below links using Microsoft SQL Server Database.

http://netbeans.org/kb/docs/java/gui-db.html

I tried the same method defined in the tutorial and was successful.
Unfortunately while implementing it into GUI using MICROSOFT SQL SERVER it is not allowing me to Connect to any of the table and throws error as "Connected Database contains only tables without primary keys."
which is not at all true.

[ChakrabortyAnshu]

Hey Julian,

I'll try this jar file and let you know.

[Andreas Ernst]

Am 28.04.2010 13:03, schrieb ChakrabortyAnshu:

[ChakrabortyAnshu]

All right.

Thank You Andreas