Infralution Support Forum Index Infralution Support
Support groups for Infralution products
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

MySQL support for License Tracker

 
Post new topic   Reply to topic    Infralution Support Forum Index -> Licensing Feature Requests
View previous topic :: View next topic  
Author Message
newyuppie



Joined: 07 Nov 2006
Posts: 12
Location: San Diego, CA, USA

PostPosted: Tue Nov 07, 2006 12:42 am    Post subject: MySQL support for License Tracker Reply with quote

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
View user's profile Send private message Visit poster's website
Infralution



Joined: 28 Feb 2005
Posts: 5027

PostPosted: Tue Nov 07, 2006 8:15 am    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website
Rich



Joined: 31 Aug 2006
Posts: 9

PostPosted: Mon Nov 13, 2006 2:21 am    Post subject: Reply with quote

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 Laughing

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
View user's profile Send private message Visit poster's website
Infralution



Joined: 28 Feb 2005
Posts: 5027

PostPosted: Mon Nov 13, 2006 2:36 am    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website
Rich



Joined: 31 Aug 2006
Posts: 9

PostPosted: Mon Nov 13, 2006 2:47 am    Post subject: Reply with quote

Excellent. Turns out I was changing it in app.access.config Embarassed

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 Wink
Back to top
View user's profile Send private message Visit poster's website
tslewis



Joined: 06 Mar 2013
Posts: 38

PostPosted: Mon Mar 11, 2013 5:15 am    Post subject: Reply with quote

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
View user's profile Send private message
Infralution



Joined: 28 Feb 2005
Posts: 5027

PostPosted: Mon Mar 11, 2013 5:43 am    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website
tslewis



Joined: 06 Mar 2013
Posts: 38

PostPosted: Mon Mar 11, 2013 6:48 am    Post subject: Reply with quote

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
View user's profile Send private message
Infralution



Joined: 28 Feb 2005
Posts: 5027

PostPosted: Mon Mar 11, 2013 9:03 am    Post subject: Reply with quote

See my post on the other thread you started
_________________
Infralution Support
Back to top
View user's profile Send private message Visit poster's website
tslewis



Joined: 06 Mar 2013
Posts: 38

PostPosted: Thu Mar 14, 2013 6:18 am    Post subject: Reply with quote

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
View user's profile Send private message
Infralution



Joined: 28 Feb 2005
Posts: 5027

PostPosted: Thu Mar 14, 2013 6:45 am    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website
wrighty



Joined: 17 Aug 2007
Posts: 5

PostPosted: Thu Aug 01, 2019 3:49 pm    Post subject: A yes for MySQL Reply with quote

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
View user's profile Send private message
CADbloke



Joined: 07 Jan 2016
Posts: 25
Location: Sydney

PostPosted: Fri Aug 30, 2019 8:05 am    Post subject: Reply with quote

SQL Express is free
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    Infralution Support Forum Index -> Licensing Feature Requests All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group