MS SQL read?

[wmgilligan]

Is it possible to use Empressa on a Windows box to read MS SQL data?

If so, any pointers to how to accomplish this?

We have a Windows based order system using MS SQL that I'd like to access (read only).
Bill

[Bruce - PhosphorMedia]

Re: MS SQL read?

I'm completely out of my league here, but I don't think Mivascript is compatible with MS SQL. You could probably use Access, and there are bound to be other tools out there...but yea, it would be good to run with what you know.

[wmgilligan]

Re: MS SQL read?

I thought I had seen in days gone buy some onfo on doing this, but it seems that it was pushed aside.

Kinda hoping maybe there was a work around...

Bill

[mvmarkus]

Re: MS SQL read?

Hi Bill,

There used to be an ODBC driver available (many many moons ago), but it isn't supported anymore. Still I guess that it may still work for basic SQL functionality. I used the driver to access various different databases (SAP DB, In-memory dbs, MS Access etc). Chris Cookson (from NZ) worked a lot with MS SQL, maybe he can chime in.

Markus

[RayYates]

Re: MS SQL read?

I've used this to connect Ms Access directly to the Merchant database. I'm sure it will work with Ms SQL but you will have to get the host to configure access through there firewall for your IP address.

http://dev.mysql.com/downloads/connector/odbc/

[nottheusual1]

Re: MS SQL read?

It can be done with the "linked servers" function in MS's SQL Management Studio. This is a link to the free express product from MS:

http://www.microsoft.com/en-us/downl...s.aspx?id=7593

I haven't used the express version, but we have done it with the standard Studio version. There's plenty of help out there, too, so I know I'm not the only one who had to do it. Best of luck.

EDIT: Total my bad - I was thinking about going the oather way - MS SQL to MySQL. Mea culpa .....

[wmgilligan]

Re: MS SQL read?

Am I understanding correctly - this could link a MySQL and a MS SQL server together?
Meaning I could move data from the MS version to the MY version?

If I could pull that off, it would accomplish the same end result.

Bill

It can be done with the "linked servers" function in MS's SQL Management Studio. This is a link to the free express product from MS:

http://www.microsoft.com/en-us/downl...s.aspx?id=7593

I haven't used the express version, but we have done it with the standard Studio version. There's plenty of help out there, too, so I know I'm not the only one who had to do it. Best of luck.

EDIT: Total my bad - I was thinking about going the oather way - MS SQL to MySQL. Mea culpa .....

[nottheusual1]

Re: MS SQL read?

Yes, it is possible to get the two talking - it uses an ODBC connector from MySQL's site. Thing is, you'll be pushing/pulling data via MS SQL - I don't think you could initiate a transaction from the other side (MySQL) with the MS SQL database without some really hefty programming - way above my pay grade, or really easy and I don't get it - both are possibilities.

I know it's possible to watch for changes in linked database tables and that could trigger an event - but I couldn't write line 1 of it. My brain has an aversion to things with MS in them.

We used a table that kept up with the last primary_key value copied and would check every 15 minutes to see if new records were added.

[RayYates]

Re: MS SQL read?

The ODBC connector can be found here.

http://dev.mysql.com/downloads/connector/odbc/

Once configured and the host has added your IP address to the firewall, you can see and link to the MySQL database tables.

Just be careful about over taxing the stores database server with complex queries. After all its running the live store.