From GL6100 to Database over GPRS

[capitanui]

Hy guys,

I wonder if it’s possible to write directly from a GL6100 modem to a SQL Server database over a GPRS connection.
I mean, SQL Server is a TCP/IP server running on port 1433… i can implement a TCP/IP client on the modem to connect to the remote SQL server but after TCP the modem doesn’t know anything else related to the databases from what i know - nothing related to application layer…how to authenticate or to send queries.
I read a little and it seems that SQL server uses TDS protocol at the application layer…maybe if i can implement that over TCP to send correct messages to the server…

Does anyone know it is even possible or is there someone who implemented such a wrinting to a database directly from a modem? I need to read some values from the serial port and write those directly to a database without any application in between…

[paruthiv]

I really don’t think this is possible. I don’t think Sierra Wireless provides any samples for
accessing SQL servers.

[awneil]

@capitanui

I read a little and it seems that SQL server uses TDS protocol at the application layer

You mean this:
en.wikipedia.org/wiki/Tabular_Data_Stream
en.wikipedia.org/wiki/Microsoft_ … ocol_layer

@Wikipedia

Protocol layer
Protocol layer implements the external interface to SQL Server. All operations that can be invoked on SQL Server are communicated to it via a Microsoft-defined format, called Tabular Data Stream (TDS). TDS is an application layer protocol, used to transfer data between a database server and a client. Initially designed and developed by Sybase Inc. for their Sybase SQL Server relational database engine in 1984, and later by Microsoft in Microsoft SQL Server, TDS packets can be encased in other physical transport dependent protocols, including TCP/IP, Named pipes, and Shared memory. Consequently, access to SQL Server is available over these protocols. In addition, the SQL Server API is also exposed over web services.[29]
en.wikipedia.org/wiki/Microsoft_ … ocol_layer

So why not use a Web Service?

…maybe if i can implement that over TCP to send correct messages to the server…

Of course! The servier neither knows nor cares what makes the requests - just so long as they follow the correct protocol!

I need to … write those directly to a database without any application in between…

Why is it so important to not have any intermediate application

@paruthiv

I really don’t think this is possible.

Why ever not?
It doesn’t look so hard: freetds.org/tds.html

I don’t think Sierra Wireless provides any samples for accessing SQL servers.

That’s true enough.