I am using RCM3000 processor and i am trying to connect it with the SQL server 2005 Express Edition but i am unable to connect please tell me the procedure of how to connect it with the SQL Server 2005 Express Edition.
Thanks in advance
Hemantk.
Via the serial port? You’ll have to write software on the PC side to interpret the serial comms into SQL queries, and send it back to the rabbit if necessary.
I don’t think the RCM3000 has an ethernet port, otherwise this would have been a better option since the rabbit can then send the queries to the SQL server directly.
– Nope sorry I am wrong, the RCM3000 does have an ethernet port.
I’ve had to do something similar with php and mysql. Here’s what worked for me.
Write a script in whatever scripting language you are using. It will do two things:
Get the data from the user(GET or POST command)
Write that data into the database.
I know thats vague and thats becaue I am not familiar with windows server or their sql, however the concept should remain the same. I’ve been using this setup for years and it works great. Hope that helps.