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.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Importing SQL Tables

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 Manager
Personnel Department
Navajo 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 server
Make sure you have it there

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

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.
Go to Top of Page

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.

Go to Top of Page
   

- Advertisement -