Click here to Skip to main content
15,916,280 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: OpenFileDialog - Specific Path Pin
A_Griffin29-Aug-17 8:07
A_Griffin29-Aug-17 8:07 
QuestionUsing Webclient.uploadfile files is never copied to website Pin
Member 1098357222-Aug-17 12:47
Member 1098357222-Aug-17 12:47 
Questionvb.net desktop app zoom feature Pin
dcof22-Aug-17 6:34
dcof22-Aug-17 6:34 
AnswerRe: vb.net desktop app zoom feature Pin
Eddy Vluggen22-Aug-17 8:15
professionalEddy Vluggen22-Aug-17 8:15 
GeneralRe: vb.net desktop app zoom feature Pin
dcof23-Aug-17 8:49
dcof23-Aug-17 8:49 
GeneralRe: vb.net desktop app zoom feature Pin
Eddy Vluggen23-Aug-17 9:57
professionalEddy Vluggen23-Aug-17 9:57 
SuggestionRe: vb.net desktop app zoom feature Pin
Richard MacCutchan23-Aug-17 21:17
mveRichard MacCutchan23-Aug-17 21:17 
QuestionHow to connect Excell 2017 to Oracle DB to get Data by using VBA code. Pin
hmanhha20-Aug-17 22:15
hmanhha20-Aug-17 22:15 
Hi All.
I Want to use VBA code to get data from Oracle DB The code is here but I fail

Const IPServer = "123.168.YY.XXX" ' Server hosting the Oracle db
Const DBNAME = "NMS" '"DatabaseName"
Const ORACLE_USER_NAME$ = "user"
Const ORACLE_PASSWORD$ = "pass"
Const port = "1521"
Sub ConnectTOOracle()
     
    Dim oRs As ADODB.Recordset
    Dim oCon As ADODB.Connection
    Set oCon = New ADODB.Connection
    
    Dim mtxData As Variant
    Dim strConOracle As String
    
    strConOracle = "Driver={Microsoft ODBC for Oracle}; CONNECTSTRING=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) "
    strConOracle = strConOracle & "(HOST=" & IPServer & ")(PORT=port))(CONNECT_DATA=(SERVICE_NAME=" & DBNAME
    strConOracle = strConOracle & "))); uid=" & ORACLE_USER_NAME & " ;pwd=" & ORACLE_PASSWORD & ";"
    
    
    
    
    oCon.Open strConOracle
    
    
    
    'Cleanup in the end
    Set oRs = Nothing
    Set oConOracle = Nothing
  
End Sub



Please help.
AnswerRe: How to connect Excell 2017 to Oracle DB to get Data by using VBA code. Pin
Richard MacCutchan21-Aug-17 0:39
mveRichard MacCutchan21-Aug-17 0:39 
GeneralRe: How to connect Excell 2017 to Oracle DB to get Data by using VBA code. Pin
hmanhha21-Aug-17 15:49
hmanhha21-Aug-17 15:49 
GeneralRe: How to connect Excell 2017 to Oracle DB to get Data by using VBA code. Pin
Mycroft Holmes21-Aug-17 19:59
professionalMycroft Holmes21-Aug-17 19:59 
QuestionMapWinGIS and Visual Basic Pin
Member 1336786618-Aug-17 15:20
Member 1336786618-Aug-17 15:20 
QuestionTrying to connect to SAP Pin
A_Griffin18-Aug-17 5:15
A_Griffin18-Aug-17 5:15 
AnswerRe: Trying to connect to SAP Pin
Dave Kreskowiak18-Aug-17 7:18
mveDave Kreskowiak18-Aug-17 7:18 
GeneralRe: Trying to connect to SAP Pin
A_Griffin18-Aug-17 8:08
A_Griffin18-Aug-17 8:08 
GeneralRe: Trying to connect to SAP Pin
Richard Deeming18-Aug-17 8:18
mveRichard Deeming18-Aug-17 8:18 
GeneralRe: Trying to connect to SAP Pin
A_Griffin18-Aug-17 8:31
A_Griffin18-Aug-17 8:31 
GeneralRe: Trying to connect to SAP Pin
Dave Kreskowiak20-Aug-17 7:38
mveDave Kreskowiak20-Aug-17 7:38 
GeneralRe: Trying to connect to SAP Pin
A_Griffin20-Aug-17 8:45
A_Griffin20-Aug-17 8:45 
Questionvb.net desktop increase display size of app Pin
dcof16-Aug-17 4:03
dcof16-Aug-17 4:03 
AnswerRe: vb.net desktop increase display size of app Pin
Eddy Vluggen16-Aug-17 5:06
professionalEddy Vluggen16-Aug-17 5:06 
AnswerRe: vb.net desktop increase display size of app Pin
Graham Irons16-Aug-17 21:09
Graham Irons16-Aug-17 21:09 
GeneralRe: vb.net desktop increase display size of app Pin
Mycroft Holmes16-Aug-17 21:34
professionalMycroft Holmes16-Aug-17 21:34 
GeneralRe: vb.net desktop increase display size of app Pin
Graham Irons16-Aug-17 21:43
Graham Irons16-Aug-17 21:43 
GeneralRe: vb.net desktop increase display size of app Pin
Mycroft Holmes16-Aug-17 21:56
professionalMycroft Holmes16-Aug-17 21:56 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.