[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 570
  • Last Modified:

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
0
peh803
Asked:
peh803
  • 7
  • 4
1 Solution
 
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
 
CEHJCommented:
Yes. Use JDBC. The other stuff is platform-specific, which rather defeats one of the objects of Java ;-)
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
CEHJCommented:
Personally, i haven't used any of those, but i'm sure some later comers to this question may have
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 7
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now