Member Avatar for alogue
alogue 0 Newbie Poster

Hello...

In VB6 I was able to write a SELECT statement to query from a table named "tcm_planned_coil@l3." However, in VB.NET, the "@l3" interferes and the query will not execute. Does anyone know how I can get this to work?

Below I have simplified the query...any help is greatly appreciated!

<code>
Dim DataSet1 As DataSet = New DataSet("DataSet1")

Dim Querystring As String = "select id from tcm_planned_coil@l3"

Dim OracleConnect As OracleConnection = New OracleConnection("I SPECIFY CONNECTION STRING")

Dim da As OracleDataAdapter = New OracleDataAdapter(Querystring, OracleConnect)

'Open Connection to Oracle
OracleConnect.Open()

'Fill the DataAdapter
da.Fill(DataSet1, "Angie")

'Close the Connection to Oracle
OracleConnect.Close()

</code>

  • 1 Contributor
  • 0 Replies
  • 71 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.