how to reverse engineer a MySQL database in visio

14 Nov

Posted by aRo` as asp.net

This is an awesome feature of MS visio that a lot of poeple don’t know. I use it mostly for documentation purpuses at the end of a development cycle.

1. Enable your MySQL to listen for network connections.
2. Allow privileges for your MySQL for the XP client to connect
3. Install the MySQL ODBC connector
http://www.mysql.com/products/connector/j/
4. Create the ODBC connector
On the windows machine:
Control Panel → Administrative Tools → Data Source (ODBC)
Click on System DSN, then click Add…
Choose MySQL ODBC 5.1 Driver

From there add the Data Source name, Can be anything you want.
Then add the server, user, pass & database info.

5. Open up Visio
6. File → New → Software and Database → Database Model Diagram
6. From the menu, select Database → Reverse Engineer
7. Select the Data Source name
8. Click Next >
9. Enter your password, and click OK
10. Select all tables or views you wish to reverse engineer

source: ubuntuforums

0 Comments

an overview of ecommerce solutions

19 Jun

Posted by aRo` as software

What ecommerce software would you use ?

Browser-Based Storefront Creation Services

* Shopify - http://www.shopify.com
* Big Cartel - http://www.bigcartel.com
* Nascent Commerce - http://www.nascentcommerce.com
* Yahoo! Stores - http://store.yahoo.com
* PayPal - http://www.paypal.com
* BizLand - http://www.bizland.com
* Mercantec SoftCart - http://www.mercantec.com
* MerchandiZer (HipHip Software) - http://www.merchandizer.com
* ShopSite - http://www.shopsite.com
* Big Step.com - http://www.bigstep.com
* HyperMart - http://www.hypermart.com
* Miva Merchant - http://www.miva.com
* Monster Commerce - http://www.monstercommerce.com
* Shopping Q - http://www.shoppingq.com
* Actinic - http://www.actinic.com
* Mals E-Commerce - http://www.mals-e.com
* ClickCartPro - http://www.clickcartpro.com
* FlashECom Cart (hosted solution) - http://www.flashecom.com
* SWREG - http://www.swreg.com
* Nexternal - http://www.nexternal.com
* CubeCart - http://www.cubecart.com/site/home/

FREE Browser-Based Storefront Creation Services

* FreeMerchant - http://www.freemerchant.com

Shopping Cart Solutions

* Avactis - http://www.avactis.com/
* Cart32 - http://www.cart32.com
* CartIt - http://www.cartit.com
* EasyCart - http://www.easycart.com
* PDG Shopping Cart - http://www.pdgsoft.com
* QuikStore - http://www.quikstore.com
* smc WebStore - http://www.smctechnologies.com
* Midi Cart - http://www.midicart.com
* Dansie Shopping Cart - http://www.dansie.net/cart.html
* Sales Cart - http://www.salescart.com
* Retail Cart - http://www.retailcart.com
* X-Cart - http://www.x-cart.com
* EDatCat - http://www.edatcat.com
* VP*ASP - http://www.vpasp.com
* Bazaar Builder = http://www.bazaarbuilder.com
* XMart eCommerce = http://www.digitalplacebo.com
* Ecommerce Templates - http://www.ecommercetemplates.com
* ASPX Shop - http://www.aspxshop.com
* ASP DotNet Storefront - http://www.aspdotnetstorefront.com/
* DigiShop - http://digishop.sumeffect.com/
* PHPCart - http://www.phpcart.net

FREE Shopping Cart Solutions

* PHPCart - http://www.phpcart.com
* OS Commerce - http://www.oscommerce.com
* PHP Shop - http://www.phpshop.org
* Agora Cart - http://www.agoracart.com
* AFCommerce - http://www.afcommerce.com
* ZenCart - http://www.zencart.com

Advanced eCommerce Systems

* Interchange - http://www.icdevgroup.org
* Broadspire Small Business Web Stores - http://www.smallbusinesswebstores.com/
* MarketLive - http://www.marketlive.com
* Blue Martini Software’s Customer Interaction System - http://www.bluemartini.com
* IBM WebSphere Commerce Suite - http://www.ibm.com/websphere
* Intershop Communications’ Enfinity - http://www.intershop.com
* Microsoft Commerce Server - http://www.microsoft.com
* ICN Software’s AceFlex B2C - http://www.icnsoftware.com
* INetStore - http://www.inetstore.com
* MerchantSpace - http://www.merchantspace.com

0 Comments

do you trust your webhost ?

05 May

Posted by aRo` as hosting

This question is fair and simple: Do you trust your webhost ?

I was worried about it when i was browsing through the FAQ of my webhost. I opened the topic “How to redirect my site so it always appear with www.?” and this is what i saw…

You should know that codehomepage.com was my previous domain. It still redirects to arolabs.com.
At least they could have changed the domain name here…

I don’t really care they used my code, but it would have been nice they told me they’re going to use it. Or give me some free hosting…

Now this redirect script is something that’s available all over the net, but what about your own coded applications ? They could just zip it and sell it !

That’s the reason all my profesional websites are hosted on a dedicated server.

Do you think your website is save with your current hosting provider ? (Even if your not on a shared hosting account).

add to digg