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...
- 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?