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...
Why I get this error message and how can solve it?
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?