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 |
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2005-10-05 : 21:26:10
|
Stanley writes "I am trying to import data from SQL tables. I can import records from the sample tables on SQL Server. But when I try to import from the production tables I get an error. The error reads:"[Microsoft][OBDC SQL Server Driver][SQL Server]Invalid object name'F08496'.(-1)I had our technical support staff check permissions to make sure I have permission to access tables and to use SELECT statement.Maybe you can offer some guidance or suggestions.Thank you for your time.Stanley Smith, HRS ManagerPersonnel DepartmentNavajo Nation" |
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-10-06 : 00:34:40
|
>>"[Microsoft][OBDC SQL Server Driver][SQL Server]Invalid object name'F08496'.(-1)Sounds that the object(table) F08496 does not exist in the Production serverMake sure you have it thereMadhivananFailing to plan is Planning to fail |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-10-06 : 04:12:57
|
How are you doing the import? F08496 sounds like data so maybe you have an embeddded quote somewhere and are executing an insert with the string?Is F08496 an object? What type of object?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
sargesmith
Starting Member
1 Post |
Posted - 2005-10-06 : 09:37:21
|
quote: Originally posted by nr How are you doing the import? F08496 sounds like data so maybe you have an embeddded quote somewhere and are executing an insert with the string?Is F08496 an object? What type of object?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy.
|
|
|
|
|
|