tjomme
April 14th, 2001, 02:38 PM
I need some advice on methods to transfer various amounts of data between
two programs online. Both program use the Winsock API (not the Winsock
Control) to communicate across the internet, using TCP/IP.
The origin and destination of the data are one SQL Server 2000 database,
and one using a SQL Server 2000 Database running on MSDE. However,
I cant setup direct replication between the two databases, because on one
side (the one using the real SQL Server 2000) I dont have direct access
to the database that the data is stored in, and I have to communicate with
another piece of software (Commerce Server 2000) using COM to put/get
data into the database. We can call this the Server side.
On the other side (call it the client side), the application works directly
towards MSDE, so thers no other application inbetwene it and the database
(well expect for MSDE).
I'm open for all suggestions, tips, hints, tutorials, links etc that can
provide
me with a good method of transfering the data back and forth the Server Side
and the Client Side using the TCP/IP communication setup by my Winsock
API code.
I've tried some VB chatrooms, but I felt that this would be the place where
I
could get some professional advice. Like I said, I'm open for any
suggestions
on how to move the data back and forth.
One last thing, there might (not decided yet) be a need to be able to pass
the
data through the Windows Crypt API to add some degree of encryption,
but this really shouldnt be a problem what ever way you guys might be able
to suggest (On the serverside I can just run it through as sson as I get the
data from the Commerce Server 2000 COM interface, and then send it of
somehow, and on the Client Side I can crypt it when i got it from MSDE).
Please, If you are able to contribute in anyway then please share your
information with me.
Thank you for taking the time to read this.
// Andreas Håkansson
two programs online. Both program use the Winsock API (not the Winsock
Control) to communicate across the internet, using TCP/IP.
The origin and destination of the data are one SQL Server 2000 database,
and one using a SQL Server 2000 Database running on MSDE. However,
I cant setup direct replication between the two databases, because on one
side (the one using the real SQL Server 2000) I dont have direct access
to the database that the data is stored in, and I have to communicate with
another piece of software (Commerce Server 2000) using COM to put/get
data into the database. We can call this the Server side.
On the other side (call it the client side), the application works directly
towards MSDE, so thers no other application inbetwene it and the database
(well expect for MSDE).
I'm open for all suggestions, tips, hints, tutorials, links etc that can
provide
me with a good method of transfering the data back and forth the Server Side
and the Client Side using the TCP/IP communication setup by my Winsock
API code.
I've tried some VB chatrooms, but I felt that this would be the place where
I
could get some professional advice. Like I said, I'm open for any
suggestions
on how to move the data back and forth.
One last thing, there might (not decided yet) be a need to be able to pass
the
data through the Windows Crypt API to add some degree of encryption,
but this really shouldnt be a problem what ever way you guys might be able
to suggest (On the serverside I can just run it through as sson as I get the
data from the Commerce Server 2000 COM interface, and then send it of
somehow, and on the Client Side I can crypt it when i got it from MSDE).
Please, If you are able to contribute in anyway then please share your
information with me.
Thank you for taking the time to read this.
// Andreas Håkansson