Click here to Skip to main content
14,693,064 members
Home » Discussions » Database
   

Database

 
GeneralRe: Sybase query returns blank/empty for char fields Pin
Member 1354244117-Dec-17 2:33
MemberMember 1354244117-Dec-17 2:33 
The call for the Win 10 machine is below. This is the same as it is in the Win 7 machine. Sensitive information masked

Public Sub Doit()
    Dim rs As New ADODB.Recordset
    Dim cn As New ADODB.Connection
    Dim sSql As String
    Dim sConnStr As String
            
    sSql = "SELECT '123' FROM someTable"
    sConnStr = "Provider=ASEOLEDB.1;Password=[password];Persist Security Info=True;User ID=[user];Data Source=[ip_address]:[port];Initial Catalog=xyz"
    sConnStr = Replace(sConnStr, "[password]", "******")
    sConnStr = Replace(sConnStr, "[user]", "******")
    sConnStr = Replace(sConnStr, "[ip_address]", "*******")
    sConnStr = Replace(sConnStr, "[port]", "******")
	
    cn.Open sConnStr
    rs.Open sSql, cn
    
    Debug.Print rs.GetString
    
End Sub

GeneralRe: Sybase query returns blank/empty for char fields Pin
Member 1354244119-Dec-17 14:36
MemberMember 1354244119-Dec-17 14:36 
GeneralRe: Sybase query returns blank/empty for char fields Pin
Member 1354244121-Dec-17 15:09
MemberMember 1354244121-Dec-17 15:09 
QuestionNeed a demo or tutorial of a simple SQL Database with a 3 Layer modell Pin
Schudi12-Dec-17 4:27
MemberSchudi12-Dec-17 4:27 
AnswerRe: Need a demo or tutorial of a simple SQL Database with a 3 Layer modell Pin
Richard MacCutchan12-Dec-17 6:35
mveRichard MacCutchan12-Dec-17 6:35 
AnswerRe: Need a demo or tutorial of a simple SQL Database with a 3 Layer modell Pin
Nathan Minier12-Dec-17 6:50
professionalNathan Minier12-Dec-17 6:50 
GeneralRe: Need a demo or tutorial of a simple SQL Database with a 3 Layer modell Pin
Schudi12-Dec-17 7:22
MemberSchudi12-Dec-17 7:22 
GeneralRe: Need a demo or tutorial of a simple SQL Database with a 3 Layer modell Pin
Nathan Minier12-Dec-17 8:10
professionalNathan Minier12-Dec-17 8:10 
GeneralRe: Need a demo or tutorial of a simple SQL Database with a 3 Layer modell Pin
Richard MacCutchan12-Dec-17 9:01
mveRichard MacCutchan12-Dec-17 9:01 
GeneralRe: Need a demo or tutorial of a simple SQL Database with a 3 Layer modell Pin
Schudi12-Dec-17 9:13
MemberSchudi12-Dec-17 9:13 
QuestionCTE Sub-Sort Pin
Stan Lake11-Dec-17 12:52
professionalStan Lake11-Dec-17 12:52 
AnswerRe: CTE Sub-Sort Pin
Richard Deeming12-Dec-17 2:56
mveRichard Deeming12-Dec-17 2:56 
GeneralRe: CTE Sub-Sort Pin
Stan Lake12-Dec-17 3:35
professionalStan Lake12-Dec-17 3:35 
GeneralRe: CTE Sub-Sort Pin
Mycroft Holmes12-Dec-17 13:45
professionalMycroft Holmes12-Dec-17 13:45 
QuestionTable Design Suggestion Pin
Manish K. Agarwal7-Dec-17 20:42
MemberManish K. Agarwal7-Dec-17 20:42 
AnswerRe: Table Design Suggestion Pin
Nathan Minier8-Dec-17 2:33
professionalNathan Minier8-Dec-17 2:33 
GeneralRe: Table Design Suggestion Pin
Manish K. Agarwal10-Dec-17 18:46
MemberManish K. Agarwal10-Dec-17 18:46 
GeneralRe: Table Design Suggestion Pin
Nathan Minier11-Dec-17 2:38
professionalNathan Minier11-Dec-17 2:38 
AnswerRe: Table Design Suggestion Pin
Richard Deeming8-Dec-17 2:35
mveRichard Deeming8-Dec-17 2:35 
GeneralRe: Table Design Suggestion Pin
Manish K. Agarwal10-Dec-17 18:53
MemberManish K. Agarwal10-Dec-17 18:53 
AnswerRe: Table Design Suggestion Pin
Mycroft Holmes9-Dec-17 1:00
professionalMycroft Holmes9-Dec-17 1:00 
QuestionCan the Pivot operator be used with text columns? Pin
Richard Andrew x646-Dec-17 5:14
professionalRichard Andrew x646-Dec-17 5:14 
AnswerRe: Can the Pivot operator be used with text columns? Pin
Richard Deeming6-Dec-17 10:51
mveRichard Deeming6-Dec-17 10:51 
GeneralRe: Can the Pivot operator be used with text columns? Pin
Richard Andrew x646-Dec-17 13:16
professionalRichard Andrew x646-Dec-17 13:16 
AnswerRe: Can the Pivot operator be used with text columns? Pin
Jörgen Andersson6-Dec-17 11:05
professionalJörgen Andersson6-Dec-17 11:05 

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.