Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MirandaJ
Starting Member
35 Posts |
 Posted - 2005-12-29 : 18:15:19
|
| I am trying to update one of the databases Jobs table Via an asp page because the amount of text in the field is too large to to be added via the DTS import wizard. I keep getting the following error. Microsoft OLE DB Provider for ODBC Drivers error '80040e37' [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Jobs'. The table Jobs definately exists in the database. I double checked the System DSN to make sure that it was pointing to this database. What do I need to look for to fix this?oops, Forgot to show the sql statement this is using, I am using ADO to insert the data vs using an Update Query because of the number of apostrophe's etc in the variables. SELECT description FROM Jobs WHERE JobID = 1Miranda |
|
|
MirandaJ
Starting Member
35 Posts |
Posted - 2005-12-29 : 18:38:16
|
| I Found the error and it is working nowMiranda |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-29 : 23:44:58
|
| It sounds jobs is not a table in that databaseMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Error updating a table