Trying to create reasonable dynamic connection so any authorized person can use the feature without having to do a separate step to confirm thier creds.
Tables are already linked and vivible in the Navigation Pane
I want to connect in code though before running a query
Code is:
Public Function TestConnectionString() As String
Dim cnOracle As New ADODB.Connection
Dim rsOracle As New ADODB.Recordset
Dim cnString As String
cnString = OracleConnectionString
rsOracle.Open cnString, "SELECT * FROM already_liked_table_name"
End Function
Private Function OracleConnectionString()
OracleConnectionString = "Oracle11g2;DSN=dsnname; uid=username; pwd=password"
End Function
With or without curly braces {} around Oracle11g2 I get
Error #-2147467259
[Microsoft][ODBC Driver Manager] Data source name too long
Anybody?