Re: [Arrowheadasp-users] Does arrowhead support Microsoft SQL Server

[Terence H. <ha...@tr...>]

Dear Sylvain Mouret,

Sorry for the slow response, I have been on vacation. ArrowHead =20
supports JDBC access drivers, but only PostgreSQL and MySQL have been =20=

tested. For ADODB.Connection it is expecting the JDBC driver class =20
name. If you are on the Windows platform, you could use Microsoft's =20
JDBC driver by installing it and trying this string (or some variation =20=

thereof):

dbLogin.Open "DRIVER=3Dcom.microsoft.jdbc.sqlserver.SQLServerDriver; =20
URL=3Djdbc:microsoft:sqlserver://localhost:1433;Database=3Dstsa; =20
uid=3Dchungdak; pwd=3Dkunga"

If you are not on the Windows platform, and are trying to access MSSQL =20=

from Linux, here is something neat:

http://jtds.sourceforge.net/

Sincerely,
Terence Haddock

On Jun 2, 2005, at 10:56 AM, Sylvain MOURET wrote:

> I am under MacOS X and currently trying to use database of a Microsoft =
=20
> SQL Server.
> It used to be done correctly under a Windows machine but I want it =20
> under my mac.
>
> I'm using the following code :
>
> =A0=A0 =A0Set dbLogin =3D Server.CreateObject("ADODB.Connection")
> =A0 =A0 Set rsLogin =3D Server.CreateObject("ADODB.Recordset")
> =A0 =A0
>  =A0 =A0 dbLogin.Open "DRIVER=3D{SQL Server} ; SERVER=3D202.71.128.140 =
; =20
> uid=3Dchungdak ; pwd=3Dkunga ; database=3Dstsa"
>
> and I get the following error :
>
> java.lang.ClassNotFoundException: {SQL Server}=A0
> =A0 =A0 =A0 =A0 at java.lang.Class.forName0(Native Method)
> =A0 =A0 =A0 =A0 at java.lang.Class.forName(Class.java:141)
> =A0 =A0 =A0 =A0 at =
com.tripi.asp.ADODB.Connection.Open(Connection.java:233)
> =A0 =A0 =A0 =A0 at =
com.tripi.asp.ADODB.Connection.Open(Connection.java:266)
> =A0 =A0 =A0 =A0 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native =
Method)
> =A0 =A0 =A0 =A0 at =20
> =
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.ja=20=

> va:39)
> =A0 =A0 =A0 =A0 at =20
> =
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccesso=20=

> rImpl.java:25)
> =A0 =A0 =A0 =A0 at java.lang.reflect.Method.invoke(Method.java:324)
> =A0 =A0 =A0 =A0 at =20
> =
com.tripi.asp.JavaObjectNode$JavaFieldNode.executeMethod(JavaObjectNode=20=

> .java:574)
> =A0 =A0 =A0 =A0 at =20
> =
com.tripi.asp.JavaObjectNode$JavaFieldNode.execute(JavaObjectNode.java:=20=

> 353)
> =A0 =A0 =A0 =A0 at =
com.tripi.asp.GetIndexNode.execute(GetIndexNode.java:178)
> =A0 =A0 =A0 =A0 at com.tripi.asp.BlockNode.execute(BlockNode.java:155)
> =A0 =A0 =A0 =A0 at com.tripi.asp.AspThread.run(AspThread.java:79)
> =A0 =A0 =A0 =A0 at java.lang.Thread.run(Thread.java:552)
>
> Have I to configure something in Tomcat ?
> Does arrowhead support Microsoft SQL Server ?
> Thanks,
>
> Sylvain