Forum

Search UsersRules

Connect another database server / read data

Erdogan Uguz	#1 Jul 03, 2016 09:59 AM
Active user Points:: 0 Joined:: Feb 26, 2015	Hello there. Is there a sample code that connects to a remote SQL database server? (ADO.NET, ODBC, etc etc)
	Profile

Alexei Khatin

Jul 03, 2016 11:17 AM

Active user

Points:: 0
Joined:: Apr 18, 2012

Hi.

Here is example:

Code

Connection = New COMObject("ADODB.Connection"); 
Connection.Open("DRIVER={SQL Server};SERVER=...;DATABASE=...;USER=...;PASSWORD=...");

RS = New COMObject("ADODB.Recordset"); 
RS.ActiveConnection = Connection;
RS.Open("SELECT * FR OM BANKS");
RS.MoveFirst(); 
While RS.EOF() = 0 Do
    Name = RS.Fields("NAME").Value;
    Message(Name);
    RS.MoveNext();    
EndDo;
RS.Close();
Connection.Close();

Profile

Erdogan Uguz	#3 Jul 03, 2016 12:12 PM
Active user Points:: 0 Joined:: Feb 26, 2015	Hi. I want convert date to string? How can i do it? CStr(RS.Fields("RECDATE").Value) ??? Convert / Parse / ToString() ??
	Profile

Alexei Khatin

Jul 03, 2016 03:25 PM

Active user

Points:: 0
Joined:: Apr 18, 2012

Hi.

There are several ways:

Code
StringValue = Format(DateValue, "DF='dd.MM.yyyy HH:mm:ss'"); StringValue = String(DateValue); StringValue = "" + DateValue;

Also you can call the "Format String Wizard" from the context menu to create or edit a format string.

Profile

Users browsing this topic (guests: 1, registered: 0, hidden: 0)