Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsWhite Papers
Discussion GroupsFirst AidDatabasesJavaBeansGUIJava 3DVirtual MachineCORBASecurityToolsGeneral
Java DirectoryOpen Source ProjectsSample Book ChaptersUser GroupsWeb Resources
Related Topics
Databases.NETMore Topics ...

Java Forum / Databases / June 2009

Tip: Looking for answers? Try searching our database.

Problem with Netbeans IDE 6.5.1 Service DB connection

Thread view: 
jc - 22 Jun 2009 14:59 GMT
Hi.
I am having trouble getting the above IDE service tab, DB connection
to a SQL 2000 DB.
I am using XP and a MS downloaded driver;
                 Microsoft SQL Server 2000 Driver for JDBC

I seem to get the driver register in the IDE but on connecting to a DB
it fails to connect and provides no error message.  I have to cancel
the process (after a long wait).

However, I have been able to get DB connection outside of the IDE with
a simple Java application.  The relevant statements I use in this
application (and also try in the IDE without success) are;

Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver");
connection = DriverManager.getConnection( "jdbc:microsoft:sqlserver://
localhost:1433;DataBaseName=Shares;User=sa;Password=secret" );

This latter statement has the URL connection string I try to use.

Is there any one who can do this or indicate my issues please help?
Am I trying to use the MS driver out on context ?
Regards JC......
John B. Matthews - 22 Jun 2009 16:31 GMT
In article
<63e40b3f-afbc-48f8-853e-7e49ee59a718@j20g2000vbp.googlegroups.com>,

> I am having trouble getting the above IDE service tab, DB connection
> to a SQL 2000 DB. I am using XP and a MS downloaded driver;
[quoted text clipped - 16 lines]
> Is there any one who can do this or indicate my issues please help?
> Am I trying to use the MS driver out on context ?

I have no recent experience with MS SQL Server, but I've seen anomalies
arise from incorrectly resolving the name localhost. You might try a raw
IP address, 127.0.0.1.

Also, you might try a different connection URL syntax:

<http://msdn.microsoft.com/en-us/library/ms378428(SQL.90).aspx>

Signature

John B. Matthews
trashgod at gmail dot com
<http://sites.google.com/site/drjohnbmatthews>

Arne Vajhøj - 23 Jun 2009 01:59 GMT
> I am having trouble getting the above IDE service tab, DB connection
> to a SQL 2000 DB.
[quoted text clipped - 17 lines]
> Is there any one who can do this or indicate my issues please help?
> Am I trying to use the MS driver out on context ?

Check that SQLServer has TCP/IP enabled and that there are no firewall
blocking.

Arne


Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.