3.2.5 MS-SQL Problems on Fedora

[eet_kreef]

Hi

I've installed our application (which works perfectly on windows) onto a JBoss (3.2.5) instance running or Fedora Core 3. The application runs right up to the point where it has to store data in the database, at which point I get the error:

[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid object name 'ErrorLog'.

I've installed the service pack 3 MS-SQL JDBC drivers as downloaded from the MS site.

Any suggestions will be welcome.

[anders.hedstrom]

Try to ues the jTDS driver instead of Microsofts. You can download it from this location:
http://jtds.sourceforge.net/

//Anders =)

[eet_kreef]

Tried it, still no joy.

[eet_kreef]

Right, the problem becomes even stranger.

I have created a JSP page which looks up the datasource and connection. Using this connection I insert and query the database.

This works fine.

Running the same code inside the application again returns the "Invalid object name" exception.

How in the world is this possible?

[adrian.brock]

http://wiki.jboss.org/wiki/Wiki.jsp?page=JBossHelp
Wrong forum, unless you can show something other than an MSSQL error message.