ERROR: cross-database references are not implemented

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • nfnick
    New Member
    • Mar 2009
    • 1

    ERROR: cross-database references are not implemented

    HI!... I'm working in Visual Basic 2005 with PostgreSql via the oficial ODBC driver. When i try to insert a new row I get this error message:

    ERROR: cross-database references are not implemented Here is the code...


    Code:
    Dim sel As String
    sel = "SELECT * FROM ""SCHEMA1"".""CUSTOMERS"" "
    
    Dim ds As New DataSet
    Dim da As New Odbc.OdbcDataAdapter(sel, sConnectionString)
    da.FillSchema(ds, SchemaType.Source, """SCHEMA1"".""CUSTOMERS""")
    
    Dim dr As DataRow = ds.Tables("""SCHEMA1"".""CUSTOMERS""").NewRow()
    
    dr("id_customer") = "00062"
    dr("n_doc") = "9999-99999999"
    dr("age") = "29"
    dr("gender") = "MALE"
    
    ds.Tables("""SCHEMA1"".""CUSTOMERS""").Rows.Add(dr )
    
    Dim CmdBuilder As New OdbcCommandBuilder(da)
    
    Try
    da.Update(ds, """SCHEMA1"".""CUSTOMERS""") 'IN THIS LINE I GET THE ERROR MESSAGE
    Catch ex As Exception
    MsgBox(ex.Message)
    End Try

    Why I get this error message and how can solve it?
    Last edited by eWish; Mar 22 '09, 04:42 PM. Reason: Please use code tags
Working...