[archive] Possible to setup MS SQL Server via ODBC; For website feed

[Migrated content. Thread originally posted on 01 March 2007]

I am trying to setup a website that interactes with the ERP data files in real time. The only way I see possible is if I connect a Microsoft SQL Server to to the ERP system via AcuODBC. Can I setup SQL Server as a client to the ERP's ODBC datasource. If I can, I can build the website around the MS SQL Server and perform queries on the SQL server to read and write data to it. This should result in the data being written back the ERP system. Is this understand correct? I would appreciate any help. Thanks in advance.