Topic profile page for Access to MySQL.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: Access to MySQL.
Topic "Access to mysql" was discussed 0 times on 0 sites in last 3 months
Started 4 days, 13 hours ago (2009-12-12 21:07:00)
by liu jackle
Recently having came accross a difficult problem. It is a long complex sql, when this sql is executed on access, it is very fast, about not more than 1s. but when migrating to mysql, speed becomes unbearable, about 10s. the table structure are the same from access to mysql. I have removed group by and order by, max,min, sum function, speed becomes very fast. then I add one of group by and ...
Started 2 weeks ago (2009-12-02 13:51:00)
by elshizzo
Like 2 years ago I created a site here which had MySQL access in which I only had to pay a one time fee of like 10 or 20 bucks [cant remember which]. Now it seems like I have to get a plan where I pay every month for Mysql access? Am I seeing this right? If so, I'm pretty dissapointed. That was the main draw to using 110mb.com
Started 1 month ago (2009-11-13 07:17:00)
by jahlewis
Is it possible to allow users of virtual sites to access their databases directly via port 3306? if so, can remote users access them via SSH tunnels? We have an external firewall on our virtualmin server, which is blocking 3306. Can we tunnel port 3306 to the virtualmin server, then allow the clients to access the database using their ODBC etc. tools? In our case, the server has an ...
Started 1 month, 2 weeks ago (2009-11-01 02:09:00)
by Jacob
Hi, I need some information on working with Ms Access Database with My SQL . In my work Ms Access is used frequently for importing and exporting tables of database too and fro. I need some instructions on the same. Which is a better way to get tables from MySQL and in the same way add up a database information in it via Access. Does this is possible by Cobol also. Thanks in ...
Started 3 days, 1 hour ago (2009-12-14 09:21:00)
by mystic7
I wrote this fairly complicated bit of code to generate a network "geneology" a while back. It worked fine back then when it was connecting to an Access database, however I'm trying to port it over to another website that's connected to a MySQL database and I get a error '80020009' /rep_area/geneology.asp, line 6 error. line 6 is located within the function (which someone ...
Started 1 day, 18 hours ago (2009-12-15 16:04:00)
by Krandor
This is what I meant: Code: qry2 = "SELECT DISTINCT Referrer_Name, Referred_By FROM tbl_admin WHERE Referred_By IS NULL ORDER BY Referred_BY DESC" Should be: Code: qry2 = "SELECT DISTINCT Referrer_Name, Referred_By FROM tbl_admin WHERE LEN(Referred_By) < 1 ORDER BY Referred_BY DESC"
Started 1 day, 18 hours ago (2009-12-15 16:05:00)
by NeverSayDie
Quote: Originally Posted by Rulmeq MySQL isn't free. You have to pay for it if you are embedding it in an application, or if you are attempting to sell access to it. It's a common misconception that it's free because it's free to use for the likes of a backend to a website etc (because your service provider has paid for the ...
Started 6 days, 16 hours ago (2009-12-10 18:26:00)
by Roberto[_11_]
Hi, Let me tell you that I found the solution with one of your suggestions: I edited the DSN file and I found that there were missing the user and password definitions, so I completed the text with the corresponding sentences. After that, I linked all the tables again and finally everything is working perfectly now. I really appreciate all your suggestions and time ...
Started 1 week, 1 day ago (2009-12-09 00:10:00)
by CodyRo
Quote: Originally Posted by pads I have root access for my VPS I tried mysql> status and i get this, [root@server1 ~]# mysql> status ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: N O) I'm assuming this means MySQL is running? Double check.. does the following yield ...
Started 6 days, 10 hours ago (2009-12-11 00:00:00)
by nccsbim071
Hi Marc, thanks a lot for the reply, finally i got someone telling me something. I will definitely try this If you know a lot about this please help me, i am really stuck Please add me in your messenger: My id is randhir.uba@gmail.com My skype id is randhir.uba or if you use other please let me know, skype would also be good Thanks again
Started 2 days, 21 hours ago (2009-12-14 13:28:00)
by healdem
well seeing as Access is a variant of SQL I'm confused, unless you mean the Joomala only works with specific SQL engines there use to be a tool called dbtools which would do the job pretty painlessly failing that you could explore the MySQL Migration tool failing that you could export the data using CSV files or simialr, and then load the data within MySQL
