August 29, 2005 at 7:45 am
Running MS SQL 2005
I tried executing the following query
SELECT emp_id, fst_nam_tx, lst_nam_tx, Employees.ina_fl, SecurityGroups.sry_grp_nam_tx, Employees.sry_grp_no, pnt_no FROM Employees INNER JOIN SecurityGroups ON Employees.sry_grp_no = SecurityGroups.sry_grp_no WHERE emp_id = 'USERID'
I receive the following error
Invalid Object Name 'Employees';
Datasource:
JDBC Driver: com.microsoft.sqlserver.jdbc.SQLServerDriverJDBC URL: jdbc:sqlserver://server:1433;DatabaseName=DBName;user=USERID;password=password;selectMethod=cursor;enable2phase=false
Ran fine on MS SQL 2000, is there something else i need to do differently with 2005?
August 29, 2005 at 8:00 am
Are you sure that the login you are executing this with defaults to the schema that owns Employees?
August 29, 2005 at 8:11 am
Yes im sure. The database in question is a test database. We have the production server up and running on the 2000 driver and it works fine. We just started using the 2005 driver and ran into this error.
August 29, 2005 at 8:53 am
But the production server is running SQL Server 2000 as well then I guess?
If you do not get a good answer from someone else who are using the JDBC 2005 beta driver I suggest you try asking at the SQL Server Data Access forum at MSDN.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply