View previous topic :: View next topic |
Author |
Message |
newyuppie
Joined: 07 Nov 2006 Posts: 12 Location: San Diego, CA, USA
|
Posted: Tue Nov 07, 2006 12:42 am Post subject: MySQL support for License Tracker |
|
|
i dont know if it has been requested before, but i would love if you could make the License Tracker to support MYSQL server too.
(i tried changing the connection string but i got an error that RecordCount was not supported)
thanks |
|
Back to top |
|
|
Infralution
Joined: 28 Feb 2005 Posts: 5027
|
Posted: Tue Nov 07, 2006 8:15 am Post subject: |
|
|
We will have a think about this. The problem with supporting many database backends (we already support Access and SQLServer) is that it increases our testing load when we make changes to License Tracker. _________________ Infralution Support |
|
Back to top |
|
|
Rich
Joined: 31 Aug 2006 Posts: 9
|
Posted: Mon Nov 13, 2006 2:21 am Post subject: |
|
|
On the subject of where the data gets stored for License Tracker, I noticed that the mdb files end up in Program Files/... Can a non-admin user write to the that location? If not that will pose a problem for the person I have in mind to track sales
It's not critical, but another reason why a configurable mdb location would be nice is so that I can place it in an area of my disk that gets backed up.
I tried changing the connection string, but it didn't seem to have any effect. |
|
Back to top |
|
|
Infralution
Joined: 28 Feb 2005 Posts: 5027
|
Posted: Mon Nov 13, 2006 2:36 am Post subject: |
|
|
You can just change the connection string in the LicenseTracker.exe.config file. For instance to use a License database in the C: root drive you would use:
Code: | <?xml version ="1.0"?>
<configuration>
<appSettings>
<add key="ConnectionString" value="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\License.mdb" />
<add key="DateFormat" value="#{0:MM/dd/yyyy HH:mm:ss}#" />
<add key="WildCard" value="%" />
</appSettings>
</configuration> |
_________________ Infralution Support |
|
Back to top |
|
|
Rich
Joined: 31 Aug 2006 Posts: 9
|
Posted: Mon Nov 13, 2006 2:47 am Post subject: |
|
|
Excellent. Turns out I was changing it in app.access.config
I got a nice unhandled exception complaining the .mdb couldn't be found though. Easily solved by copying the existing mdb into place, just thought I should mention it in case you wanted to fix it |
|
Back to top |
|
|
tslewis
Joined: 06 Mar 2013 Posts: 38
|
Posted: Mon Mar 11, 2013 5:15 am Post subject: |
|
|
Mysql seems to be the norm on the hosting sites ive been too. I currently dont have the option of a MS sql server Database with bluehost - my current hosting company |
|
Back to top |
|
|
Infralution
Joined: 28 Feb 2005 Posts: 5027
|
Posted: Mon Mar 11, 2013 5:43 am Post subject: |
|
|
Most (in fact all the ones I've ever seen) web hosts that offer Windows IIS (ASP.NET) hosting offer SQL Server as a database option. Are you sure that your web hosting is Windows server based? _________________ Infralution Support |
|
Back to top |
|
|
tslewis
Joined: 06 Mar 2013 Posts: 38
|
Posted: Mon Mar 11, 2013 6:48 am Post subject: |
|
|
Infralution wrote: | Most (in fact all the ones I've ever seen) web hosts that offer Windows IIS (ASP.NET) hosting offer SQL Server as a database option. Are you sure that your web hosting is Windows server based? |
No its not MS based, sorry I'm a newbie to all this, I assumed all hosting platforms were the same but obviously linux is not going to work with a MS product. Silly me.
I sgined up with a linux based option for my web site and I had not thought about database requirements.
I guess I coudl have a separate hosting site for the database but it seems expensive to pay for two..... |
|
Back to top |
|
|
Infralution
Joined: 28 Feb 2005 Posts: 5027
|
Posted: Mon Mar 11, 2013 9:03 am Post subject: |
|
|
See my post on the other thread you started _________________ Infralution Support |
|
Back to top |
|
|
tslewis
Joined: 06 Mar 2013 Posts: 38
|
Posted: Thu Mar 14, 2013 6:18 am Post subject: |
|
|
Infralution wrote: | See my post on the other thread you started |
Thanks, the sql server licensing options provided by ms are a mess, they still cant give me a clear answer. A standard sql server license is 2800 bucks. I still think the option of being able to use a mysql database is a good option provided there are .NET methods available to access and manipulate mysql database files. |
|
Back to top |
|
|
Infralution
Joined: 28 Feb 2005 Posts: 5027
|
Posted: Thu Mar 14, 2013 6:45 am Post subject: |
|
|
You definitely don't need full SQL Server - SQL Express (which is free) will be fine unless you are running a major corporation with thousands of licenses issued per day - in which case the money is probably chicken feed. _________________ Infralution Support |
|
Back to top |
|
|
wrighty
Joined: 17 Aug 2007 Posts: 5
|
Posted: Thu Aug 01, 2019 3:49 pm Post subject: A yes for MySQL |
|
|
MySql is by far the cheaper option and all our apps use it even on Windows Server 2016, MSSQL is way way to expensive and Access is old tech by todays standards. |
|
Back to top |
|
|
CADbloke
Joined: 07 Jan 2016 Posts: 25 Location: Sydney
|
Posted: Fri Aug 30, 2019 8:05 am Post subject: |
|
|
SQL Express is free |
|
Back to top |
|
|
|