Remote ODBC Socket Server

[ptrex]

Remote ODBC Socket Server

Sometimes it happens that in order to do an ODBC connection, you need to install some client software.

Like for instance to do a ODBC connection for Oracle you need to install their software on each client.

http://odbcsock.sourceforge.net/

ODBC Socket Server is an open source database access toolkit that exposes Windows ODBC data sources with an XML-based TCP/IP interface.

Well using this ODBCSocketServer COM interface will solve this issue.

The Server wll return the data in XML format.

This COM server support a COM interface as well as it has clients that suppoort C++, Python, Perl, PHP

Install the ODBC Server Service in the server or PC that has the Database cllient software running.

And then use this client to query the database from any client that has the ODBC Client COM registered.

"Or if you don't want to register, use my REGFREE DLL approach in my signature."

; http://odbcsock.sourceforge.net/
; Download the ODBC Client / Server here :
; http://odbcsock.sourceforge.net/release/ODBCSocketServer.zip

$HostName = "127.0.0.1"
$PortNr = 9628
$Seconds = 100

$ODBCClient = ObjCreate("ODBCClient.ODBCClient")

If Not IsObj ($ODBCClient) Then
    MsgBox(0,"Error", "No ODBC Client Object registered on your machine ")
Else
    MsgBox(0,"Error", " OK ")
EndIf

$Host = $ODBCClient.Hostname($HostName)
$Port = $ODBCClient.Port($PortNr)
$TimeOut = $ODBCClient.SocketTimeOut($Seconds)

$Qry = $ODBCClient.ExecSQL(("SELECT * FROM table") 

ConsoleWrite($Qry)

Enjoy !!

regards

ptrtex

[JRSmile]

Remote ODBC Socket Server

Sometimes it happens that in order to do an ODBC connection, you need to install some client software.

Like for instance to do a ODBC connection for Oracle you need to install their software on each client.

Well using this ODBCSocketServer COM interface will solve this issue.

The Server wll return the data in XML format.

This COM server support a COM interface as well as it has clients that suppoort C++, Python, Perl, PHP

Install the ODBC Server Service in the server or PC that has the Database cllient software running.

And then use this client to query the database from any client that has the ODBC Client COM registered.

"Or if you don't want to register, use my REGFREE DLL approach in my signature."

; http://odbcsock.sourceforge.net/
; Download the ODBC Client / Server here :
; http://odbcsock.sourceforge.net/release/ODBCSocketServer.zip

$HostName = "127.0.0.1"
$PortNr = 9628
$Seconds = 100

$ODBCClient = ObjCreate("ODBCClient.ODBCClient")

If Not IsObj ($ODBCClient) Then
    MsgBox(0,"Error", "No ODBC Client Object registered on your machine ")
Else
    MsgBox(0,"Error", " OK ")
EndIf

$Host = $ODBCClient.Hostname($HostName)
$Port = $ODBCClient.Port($PortNr)
$TimeOut = $ODBCClient.SocketTimeOut($Seconds)

$Qry = $ODBCClient.ExecSQL(("SELECT * FROM table") 

ConsoleWrite($Qry)

Enjoy !!

regards

ptrtex

you make me afraid of beeing spyed,

every project i start you deliver a function for...

BIG THANKS!!!

keep up the good work.

is it possible to get the sourcecode of this and replace the server component with an autoit script so that maybe events or queries can be done to autoit scripts by other autoit scripts via com interface?

[ptrex]

@JRSmile

Thanks !!

The lesson is, if you need something go and look for it on the net.

Almost everything has already been invented by someone else.

This saves my at least a lot of time.

Ps : Regaarding the source code it is included in the download zip file, you can have a look.

regards,

ptrex

Edited September 28, 2007 by ptrex