The port number 1433?database=DemoDB is not valid.

Andy Knipp

This DD had been working. Now I am getting this error when I try to run:

DBD: Area VPath:/default/main/DotCom/WORKAREA/Content
DBD: Setting up TDbSchemaAgent.
DBD: Loading com.microsoft.sqlserver.jdbc.SQLServerDriver
DBD: url : jdbc:sqlserver://DBSERVER:1433?database=DemoDB
DBD: login : sa
DBD: login timeout=3
DBD: Connecting to the database...
DBD: Try connecting using jdbc:sqlserver://DBSERVER:1433?database=DemoDB...
DBD: SQL failure
DBD: ERROR:ERROR: Could not connect to [jdbc:sqlserver://DBSERVER:1433?database=DemoDB]
DBD:
DBD: *******************************************************
DBD: SQLException occured in JdbcCheckup:MakeConnection()
DBD: Exception Message: The port number 1433?database=DemoDB is not valid.
DBD: Vendor Error Code: 0
DBD: SQL state: null
DBD: *******************************************************

My database.cfg has not changed.

I have run SQL manager on DBSERVER and DemoDB is a valid DB and is running.

I have checked the event subssytem logs and no errors are apparent, so I suspect the drivers are correct. How do I check the port ? I cannot see that changing but I am not certain what else to look at. On Unix I had ODBC test, what can I use here to check the port/db/etc ?

I am running Win2003 OD/DD 6.2 SQLSVR 2005

Tips/Pointers/RTFMs appreciated.

Andy