#1
  1. No Profile Picture
    Contributing User
    ASP Explorer (0 - 99 posts)

    Join Date
    Mar 2004
    Location
    Carmi, Illinois
    Posts
    45
    Rep Power
    14

    Create a tcpip link to a table in a SQL DB


    I am so new at this that, I am so lost as to barely recognize that I am lost.

    I have created a table in a MS SQL Server Express Database to capture data from an Impinj speedway reader through an IP address and specific port (for example "Http://12.34.56.78:12345").

    The Reader is configured and reading tags. I can use "Ruby" to send this information to a text or csv file but, I hope to have the SQL Db do this instead. The fields are Port_Number, AntennaID, TagID, Signal_Strength (in -db). Can someone guide me to do the same in SQL Server Express 2014. The process will eventually be added to a SQL Server 2008 Enterprise Database., but I am attempting to learn how to do this myself instead of someone else to do the programming.


    I want to extend my Thanks for any and all responders
    Last edited by bobbrooks; October 15th, 2015 at 09:22 AM. Reason: Partially Solved
  2. #2
  3. Contributing User
    ASP Skiller (1500 - 1999 posts)

    Join Date
    Mar 2005
    Location
    Columbus, OH
    Posts
    1,665
    Rep Power
    283
    Where is your problem?
    If you know how to capture data and send to any output, just create insert statement and insert record into SQL dsatabase.
    GK
    __________________________________________________ _____
    if you found this post is useful click Give Rep button (bottom side on this reply ) and agree

Similar Threads

  1. How to create make table query when table has dependencies?
    By Sheryl in forum Microsoft Access Help
    Replies: 5
    Last Post: August 13th, 2010, 06:53 PM
  2. Link Table A & B to Create New Table C
    By MBarnesca in forum Microsoft Access Help
    Replies: 0
    Last Post: January 7th, 2009, 01:59 AM
  3. Create Database and Create Table on one form-NEED HELP!
    By xtgeminiman in forum ASP Development
    Replies: 9
    Last Post: December 6th, 2004, 01:44 PM
  4. Create Table
    By webguy in forum ASP Development
    Replies: 2
    Last Post: August 24th, 2004, 09:09 AM
  5. Creating a database table using SQL CREATE TABLE
    By Steve Schofield in forum SQL Development
    Replies: 1
    Last Post: June 25th, 2001, 04:39 PM

IMN logo majestic logo threadwatch logo seochat tools logo