Re: sqlserver JDBC driver problem.



Donkey Hot wrote:
Matthew Shelton <crash700@xxxxxxxxx> wrote in
news:1MKdnaBglODfg9vanZ2dnUVZ_hCdnZ2d@xxxxxxxxxxx:

I had spent days trying to fix the class path in netbeans. I'm using
sqlserver express 2005 on winXP with netbeans 5.5, with the Microsoft
JDBC type 4 driver.

I did the entire routine, sqljdbc folder in class path sqljdbc_auth.dll
copied, and still coming up with nothing.


Strange type 4 driver, if it needs a dll... Type 4 should be pure java.

One good jdbc type 4 driver is open source jTDS. It's said to be fastest
jdbc driver for SQLServer, and worked fine for me, also in Netbeans/tomcat.

One jar is all it is. http://jtds.sourceforge.net/


Thanks for the tip, I was a little concerned with deployment, having to
ship a .dll that isnt my own code, at least I can make a static link
with this, considering there will be a Swing interface as well as a
website with the same functionality.
begin:vcard
fn:Matthew Shelton
n:Shelton;Matthew
adr;dom:;;;Philadelphia;PA
email;internet:crash700@xxxxxxxxx
x-mozilla-html:FALSE
version:2.1
end:vcard



Relevant Pages

  • Re: sqlserver JDBC driver problem.
    ... sqlserver express 2005 on winXP with netbeans 5.5, ... Strange type 4 driver, ... One good jdbc type 4 driver is open source jTDS. ... jdbc driver for SQLServer, and worked fine for me, also in Netbeans/tomcat. ...
    (comp.lang.java.databases)
  • RE: DAO, Transactions, SQLServer
    ... Have you considered using ADO insterad of DAO? ... > I have a problem with DAO, Transactions and SQLServer. ... > are opened (by the driver I believe) and I suspect that the driver sends the ... I also tried to disable the ODBC connection pool but this is ...
    (microsoft.public.vb.database)
  • Re: DAO, Transactions, SQLServer
    ... "SerGioGio" escribió en el mensaje ... > I have a problem with DAO, Transactions and SQLServer. ... > are opened (by the driver I believe) and I suspect that the driver sends ... > UPDATE statement to connection 1 for instance and the SELECT query to ... ...
    (microsoft.public.vb.database)
  • RE: DAO, Transactions, SQLServer
    ... Have you considered using ADO insterad of DAO? ... > I have a problem with DAO, Transactions and SQLServer. ... > are opened (by the driver I believe) and I suspect that the driver sends the ... I also tried to disable the ODBC connection pool but this is ...
    (microsoft.public.sqlserver.connect)
  • Re: DAO, Transactions, SQLServer
    ... "SerGioGio" escribió en el mensaje ... > I have a problem with DAO, Transactions and SQLServer. ... > are opened (by the driver I believe) and I suspect that the driver sends ... > UPDATE statement to connection 1 for instance and the SELECT query to ... ...
    (microsoft.public.sqlserver.connect)