connection with sqlserver driver

[gemini_richard]

I'm trying to connect mondrian to an sqlserver database usinh an sqlserver jdbc driver, but it's throws me an NO SUITABLE DRIVER ERROR.
My connectionstring follows:
"Provider=mondrian;" +
"Jdbc=jdbc:microsoft:sqlserver://developer:1433;SelectMethod=Cursor;DatabaseName=vbr;User=sa;Password=;" +
"Catalog=file:\\C:\\Virtuallis\\src\\proximus\\vbi\\Orcamento01.mondrian;" +
"JdbcDriver=com.microsoft.jdbc.sqlserver.SQLServerDriver";
Thanks to who can help me...

[sgwood]

Looks like your driver jar is not on the class path or the driver name is wrong. See
http://support.microsoft.com/default.aspx?scid=kb;en-us;313100
Sherman

[gemini_richard]

I have checked out the driver name and connection string. I have also checked that the arguments in the mondrian's connection string are separated by comma, and the arguments of sqlserver's connection string too. Don't can be this the problem?

[sgwood]

Have you got the 3 driver jars in your classpath?
Sherman

[gemini_richard]

of course... I use the same driver on the my other objects....

[sgwood]

Looking at the connectString again, I think I see the problem. The JDBC URL has semi-colons in it, of course, and those are significant to Mondrian, which uses them to break up the string. Try putting the JDBC URL in quotes, like:
Jdbc="MS SQL jdbc URL";
Sherman