Click here to Skip to main content
16,016,580 members
Home / Discussions / Database
   

Database

 
AnswerRe: Overwrite from DB as windows Services Pin
Victor Nijegorodov17-Dec-17 20:54
Victor Nijegorodov17-Dec-17 20:54 
QuestionBuying of referrals Pin
Member 1357942916-Dec-17 0:13
Member 1357942916-Dec-17 0:13 
AnswerRe: Buying of referrals Pin
Richard MacCutchan16-Dec-17 0:49
mveRichard MacCutchan16-Dec-17 0:49 
GeneralRe: Buying of referrals Pin
Member 1357942916-Dec-17 2:41
Member 1357942916-Dec-17 2:41 
GeneralRe: Buying of referrals Pin
OriginalGriff16-Dec-17 2:43
mveOriginalGriff16-Dec-17 2:43 
QuestionSybase query returns blank/empty for char fields Pin
Member 1354244115-Dec-17 6:56
Member 1354244115-Dec-17 6:56 
AnswerRe: Sybase query returns blank/empty for char fields Pin
jschell16-Dec-17 9:06
jschell16-Dec-17 9:06 
GeneralRe: Sybase query returns blank/empty for char fields Pin
Member 1354244117-Dec-17 1:33
Member 1354244117-Dec-17 1: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

VB
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 13:36
Member 1354244119-Dec-17 13:36 
GeneralRe: Sybase query returns blank/empty for char fields Pin
Member 1354244121-Dec-17 14:09
Member 1354244121-Dec-17 14:09 
QuestionNeed a demo or tutorial of a simple SQL Database with a 3 Layer modell Pin
Schudi12-Dec-17 3:27
Schudi12-Dec-17 3:27 
AnswerRe: Need a demo or tutorial of a simple SQL Database with a 3 Layer modell Pin
Richard MacCutchan12-Dec-17 5:35
mveRichard MacCutchan12-Dec-17 5:35 
AnswerRe: Need a demo or tutorial of a simple SQL Database with a 3 Layer modell Pin
Nathan Minier12-Dec-17 5:50
professionalNathan Minier12-Dec-17 5:50 
GeneralRe: Need a demo or tutorial of a simple SQL Database with a 3 Layer modell Pin
Schudi12-Dec-17 6:22
Schudi12-Dec-17 6:22 
GeneralRe: Need a demo or tutorial of a simple SQL Database with a 3 Layer modell Pin
Nathan Minier12-Dec-17 7:10
professionalNathan Minier12-Dec-17 7:10 
GeneralRe: Need a demo or tutorial of a simple SQL Database with a 3 Layer modell Pin
Richard MacCutchan12-Dec-17 8:01
mveRichard MacCutchan12-Dec-17 8:01 
GeneralRe: Need a demo or tutorial of a simple SQL Database with a 3 Layer modell Pin
Schudi12-Dec-17 8:13
Schudi12-Dec-17 8:13 
QuestionCTE Sub-Sort Pin
Stan Lake11-Dec-17 11:52
professionalStan Lake11-Dec-17 11:52 
AnswerRe: CTE Sub-Sort Pin
Richard Deeming12-Dec-17 1:56
mveRichard Deeming12-Dec-17 1:56 
GeneralRe: CTE Sub-Sort Pin
Stan Lake12-Dec-17 2:35
professionalStan Lake12-Dec-17 2:35 
GeneralRe: CTE Sub-Sort Pin
Mycroft Holmes12-Dec-17 12:45
professionalMycroft Holmes12-Dec-17 12:45 
QuestionTable Design Suggestion Pin
Manish K. Agarwal7-Dec-17 19:42
Manish K. Agarwal7-Dec-17 19:42 
AnswerRe: Table Design Suggestion Pin
Nathan Minier8-Dec-17 1:33
professionalNathan Minier8-Dec-17 1:33 
GeneralRe: Table Design Suggestion Pin
Manish K. Agarwal10-Dec-17 17:46
Manish K. Agarwal10-Dec-17 17:46 
GeneralRe: Table Design Suggestion Pin
Nathan Minier11-Dec-17 1:38
professionalNathan Minier11-Dec-17 1:38 

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.