SmartView - Connect to Shared Database

Summary

SmartView - Connect to Shared Database

Content

32-bit for Office; Version 11.1.2.5.710

Hello,

I am fairly new to Oracle Smart View and have been recently assigned to debug an issue with establishing a connection to our National Sales connection. Establishing a connection requires logging in with a username and password.

How do I properly establish a connection to National Sales and Zoom In on "All Customers" (Manual Input). My code so far is:

Microsoft Excel Objects

     This Workbook:

     'Opens form to access workbook    

          Private Sub Workbook_Open()

          U_login.Show

          End Sub

Forms

     U_login

          Private Sub CommandButton1_Click()

          U_ID = UID.Value