Can not browse tables - MS SQL 2000

[fiedler]

Hi There.
I can not browse tables. MS SQL 2000.

I have created tables using the CREATE TABLES function from the browser, but I get errors (I can also create columns):

[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Line 2: Incorrect syntax near ')'.

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Line 2: Incorrect syntax near ')'.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSExecuteRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeUpdate(Unknown Source)
at com.advenio.jdbclib.threads.SQLUpdateThread.executeStatement(SQLUpdateThread.java:154)
at com.advenio.jdbclib.threads.SQLUpdateThread.threadRunLogic(SQLUpdateThread.java:66)
at com.advenio.jdbclib.threads.AbstractThread.run(AbstractThread.java:43)

Any help would be great.

[michaeldupuis]

Hi there,

I'm still trying to get a MS SQL Server account and database back so that I can test it. Hopefully soon I'll resolve any remaining SQL Server issues.

-- Michael

[michaeldupuis]

I finally have a MS SQL Server database to test with again. Can you describe your problem in more detail? In general things seem to work, but I may be misunderstanding your problem. I was able to create a simple table using the table creation tool in the browser. If that was the problem, can you tell me what settings you used in the table creation tool?

If you are having a problem just viewing a table, can you send me the script for the table so that I can create it for testing?

Thanks,

-- Michael