access to a [cnetinfov3.2] table (table name with .)

• Sergio Campos

  SSC-Addicted

  Points: 459

  More actions

  June 28, 2005 at 4:51 am

  #167311

  Hi im trying to connect from a server to another table of another server that it has a . in the name. but alway i get this err:

  No se puede procesar el objeto '"cnetinfov3.2"."dbo"."mvoces"'. El proveedor OLE DB 'SQLOLEDB' indica que el objeto no tiene columnas.

  Traza de error de OLE DB [Non-interface error: OLE DB provider unable to process object, since the object has no columnsProviderName='SQLOLEDB', Query="cnetinfov3.2"."dbo"."mvoces"'].

  any help plz???

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  June 28, 2005 at 6:10 am

  #568877

  Create table [cnetinfov3.2]

  (

  a varchar(10) not null

  )

  Select * from dbo.[cnetinfov3.2]

  DROP TABLE [cnetinfov3.2]