More details here http://msdn2.microsoft.com/en-us/library/ms378428.aspx
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4059397#4059397
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4059397
__
Try this -
Assuming the database server is dbsqlserver and the instance name is devenv,
port is 1433 and database name is userscdb then the url should look like:
jdbc:microsoft:sqlserver://dbsqlserver;devenv:1433;databaseName=userscdb
Note the semi-colon between dbsqlserver and devenv.
View th
Please suggest why is the database being ignored.
Regards,
Ruchika
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4058311#4058311
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4058311
___
Thanks jaikiran.
I tried changing "DatabaseName" to "databaseName".
But this does not work either. :(
Rather even if i give the name of the database which is not existing like say
"userscdbXYZ", it does not give any error or warning, as though it is simply
ignoring the database name.
I am rea
Not sure if this is the problem, but as far as i know, the parameters to the
database url are case sensitive.
jdbc:microsoft:sqlserver://dbsqlserver\\devenv:1433;DatabaseName=userscdb
Change this to:
jdbc:microsoft:sqlserver://dbsqlserver\\devenv:1433;databaseName=userscdb
Note the change in c
looks like some typo errors in submitting my query.
Below is snapshot from my mssql-ds.xml file
SCMSSQLDS
jdbc:microsoft:sqlserver://dbsqlserver\\devenv:1433;DatabaseName=userscdb
com.microsoft.jdbc.sqlserver.SQLServerDriver
kkuser
kkuser
View the original post :
http://www.jboss.com/index
