import com.ms.wfc.data.*

Hello all,

I'm new to java, so please excuse my lack of knowledge if I use wrong terms, etc.

I am writing a java executable file that needs to connect to a SQL Server database that will be compiled / run on a windows machine.  I believe I want to use the package com.ms.wfc.data.* to do this, but my development environment (NetBeans IDE 3.6) does not find this package ("package com.ms.wfc.data.* does not exist" error occurs on the line: import com.ms.wfc.data.*;).  

What must I do to get this working?

Thank you very much in advance for your help.

Regards,
peh803
LVL 19
peh803Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
CEHJConnect With a Mentor Commented:
Personally, i haven't used any of those, but i'm sure some later comers to this question may have
0
 
CEHJCommented:
No - that's a Microsoft package, so NetBeans won't have it. You don't need platform-specific packages to connect to SQL Server. See

http://javaalmanac.com/egs/java.sql/ConnectSqlServer.html
0
 
peh803Author Commented:
Thank you for the quick response.  

The link you sent me uses jdbc (I'm sure you know that).  

Are you suggesting that I use jdbc to connect rather than the one I reference above because it is not possible to use com.ms.wfc.data?

Thanks,
peh803
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
CEHJCommented:
Yes. Use JDBC. The other stuff is platform-specific, which rather defeats one of the objects of Java ;-)
0
 
peh803Author Commented:
ah ha.  

Okay, so now I need to actually download the jdbc driver for sql server...

The resource you provided suggests 3 -- do you recommend any?

  NetDirect:  http://www.j-netdirect.com
  DataDirect: http://www.datadirect-technologies.com
  FreeTDS:    http://www.freetds.org

Thank you,
peh803
0
 
peh803Author Commented:
Yuck, these cost money.  

Am I going to run into this with any jdbc driver for SQL Server, do you think?
0
 
peh803Author Commented:
Hey, actually, freetds looks like it might be "free".  (duh)

Thanks for your help with this issue.  I may have future posts, and I hope you will participate.

Regards,
peh803
0
 
peh803Author Commented:
darn, from the first sentence on their website: "FreeTDS is a set of libraries for Unix and Linux ... "

I guess I can't use this free solution for my windows environment...

Oh well, thanks for your help anyways.

peh803
0
 
CEHJCommented:
:-)

Yep
0
 
peh803Author Commented:
Hey, I found a free jdbc driver for windows environments on microsoft.com (who would have ever guessed?).

Again, thanks for your help.

peh803
0
 
peh803Author Commented:
CRAP, this one's unix only, too.  I'll shut up now.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.