Re: [Jython-users] zxJDBC won't connect to SQLServer ?

[Kent J. <ke...@td...>]

lyn...@th... wrote:
> Jython-users:
>  
> I was hoping someone could help out here...
>  
> (BTW, I fixed my problem with the missing zxJDBC in jython-2.2a1 by 
> downloading it (v2.1) from sourceforge and placing
> it into classpath and extdirs.)
>  
> I'm trying to port some java JDBC code to jython and zxJDBC... and 
> previous used the following driver and URL:
>     driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver"
>     url = "jdbc:microsoft:sqlserver://%s:1440" % (remotehost, )
>  
> However, I keep getting the following Exception:
>     DatabaseError: driver [com.microsoft.jdbc.sqlserver.SQLServerDriver] 
> not found
>  
> Can someone please shed light on this?
> Am I supposed to import something like com.microsoft.jdbc.sqlserver so 
> the correct DriverManager is found?

Try
         java.lang.Class.forName(driver)

and make sure the microsoft jar is in your classpath.

Kent