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:
connection-urljdbc:microsoft:sqlserver://dbsqlserver;devenv:1433;databaseName=userscdb/connection-url
Note the semi-colon between
More details here http://msdn2.microsoft.com/en-us/library/ms378428.aspx
View the original post :
http://www.jboss.com/index.html?module=bbop=viewtopicp=4059397#4059397
Reply to the post :
http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4059397
Please suggest why is the database being ignored.
Regards,
Ruchika
View the original post :
http://www.jboss.com/index.html?module=bbop=viewtopicp=4058311#4058311
Reply to the post :
http://www.jboss.com/index.html?module=bbop=postingmode=replyp=4058311
looks like some typo errors in submitting my query.
Below is snapshot from my mssql-ds.xml file
jndi-nameSCMSSQLDS/jndi-name
connection-urljdbc:microsoft:sqlserver://dbsqlserver\\devenv:1433;DatabaseName=userscdb/connection-url
Not sure if this is the problem, but as far as i know, the parameters to the
database url are case sensitive.
connection-urljdbc:microsoft:sqlserver://dbsqlserver\\devenv:1433;DatabaseName=userscdb/connection-url
Change this to:
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 really
