Reporting Services Equivelant In MySQL Or PostGreSQL?
Does anyone know a product equivelant to MS SQL Server Reporting Services, but for MySQL or PostGreSQL?
View Complete Forum Thread with Replies
Related Forum Messages:
MySQL Vs. PostgreSQL
For everyone who thinks about moving from MySQL to PostgreSQL I have a realy bad news - It's not worth. Why, You may ask... A few days ago I have installed and tested PostgreSQL, becouse I realy need UTF-8 support and subselects. I thought that PostgreSQL will be as good as MySQL but also will give me that features, which aren't availble in MySQL. Well, after installation and moving my MySQL dbs into PostgreSQL I decided to check if PostgreSQL is as fast as MySQL is. I was shocked... I have made several tests with simple and complicated querys - select, update, insert, drop. PostgreSQL execute those querys even 20 times slower than MySQL. On average, PostgreSQL is 2-3 times slower. So, all people who needs trigers/views/procedures etc. have to be patient and wait for new MySQL versions.
View Replies !
Mysql Or PostgreSQL
I have to do an aplicattion with on big table (million of rows). I want know what of both (Mysql or PostgreSQL) manages more efficiently big tables.
View Replies !
PostgreSQL To Mysql
I have a JAVA CMS application over Postgres 8. Now,i would like to change a back-end database, MySQl 5 for PostgreSQL. So i dump my DB with pg_dump .... Now,i would like to import this dump over MySQL, but i've same error becuse into my postgreSQL BD there are the SEQUENCE . Is it possible to import this DB on my MySQl?
View Replies !
Move DB From PostgreSQL To MySQL
Can anyone point me to some instructions on moving a database currently on Postgres to MySQL? Is there an easy way to do this? I've been searching the web, but I can't find exactly what I"m looking for (I find a lot of MySQL -> Postgres stuff).
View Replies !
Mysql Services Windows 2003
------=_NextPart_000_0001_01C34BC2.26B3C4C0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Why can't I start the service in windows 2003 server have any one a solution?
View Replies !
Windows SQL Services And Removing MySQL
I had installed mySQL when a programmer wanted to use it for a project. Then i uninstalled it. Now the MS SQL services (SQLserver, sql server activation directory helper, sql server browser, and sql server vss writer), cannot be started. The error messages seem to indicate that there are some files missing in order to run the services. I tried to re-install MySQL, but not it is giving me error zero when i run the configurator.
View Replies !
Mysql Stock In Services Forgot To Remove
i have uninstalled mysql to put it on a different drive soon The old mysql stayd in Services and I dunno how to remove it from administrative services? Mysql is not installed atm i will install it soon in other words how do I remove from administartive services once i uninstall the whole thing.
View Replies !
Any MySQL Reporting Software
Does any one know of an inexpensive software I can use to generate custom web reports off an MySQL database. Preferably dynamic reports based on the users criteria on the web. I am not a programmer, if I can't setit up myself I will get someone to start it.
View Replies !
MYSQL Live Reporting
I am looking on building an application for a call center which provides live updates as records are added and logged into a mysql database. For example when a user closes a deal I want to detect that a record in the opportunities table changed from pending -> closed won and when that happens do something. My exact usage will be to flash a big WIN! graphic on a plasma screen in the sales center so this application will likely be using flash as well. Any thought on what can do this or the technologies I should be looking at.
View Replies !
Data Transfer Services
Does anyone did DTS using MYSQL before? thinking to migrate from MSSQL to MYSQL.. If MYSQL can do DTS, then I don't need to do scripting to transfer data.
View Replies !
Remote Conn Via ODBC Or Web Services?
I need your help, I've developed an application succesfully using PHP and MySQL But in order to mantain the MySQL database I need to make constant connections from either Progress or Delphi It's been working just fine using the MySQL ODBC 3.51 connector, but only in the SAME machine (localhost) any other machine atmysqlting to connect remotely gets an error This implementation works if my customer has a dedicated server posted on the web, but other customers need to hire external hostings In that case, how can I connect progress or delphi to a REMOTE MySQL DB on a external SERVER?
View Replies !
Use Reporting For Web
How will use the Reports Tool from navicat for MySQL and publish those reports on the web dynamically. Alos, is there a way once the report is generated the data from the database is deleted, so I only have to look at the reports.
View Replies !
Top Reporting
I have a relatively simple database. 1 table, 7 columns, looks something like this: id | domain | servername | engineer | steps | notes | timestamp id is incrementing, timestamp is generated by mysql. the column steps is used for what the engineer did to fix an issue with a server. So now we have about 13000 entries in this database and my boss wants me to come up with some reporting and I'm having a lot of trouble with it. I'm trying to find the best way to pull a list from the db that would be something like 'top 10 servers where steps LIKE iisreset' and I can't seem to figure out how to get it to do it properly.
View Replies !
Reporting Module
I am looking for a reporting tool for mysql. throw some suggestions. 1. report sould be editable (hopefully simple ascii text file) 2. need to concat some fields e.g. Model Brand modelA brandA, brandB, brandC, brandD, brandE modelB brandZ, brandH Byung Choi
View Replies !
Reporting Tools
Does anyone know of a good reporting tool for MySQL databases that would allow me to write queries and format the query results into reports
View Replies !
Any Good Reporting Module ?
I am looking for a reporting tool for mysql. throw some suggestions. 1. report sould be editable (hopefully simple ascii text file) 2. need to concat some fields e.g......
View Replies !
Commercial Or Free Reporting
I wondered if you could let me know which is the best report generating package for mysql.... I am looking into open source or commercial packages... I want the package to create me a link where I could add a button to so my user does not see the sql code... they just click the button and pops the charts... The Package must output plenty of charts... I searched through google, but I prefer to know by people that have used the packages
View Replies !
Reporting Database On Different Server
I want to have a reporting database in a different database that exists on a different server that is more/less(?) normalised for faster reporting. Is there any easy way to move data between different databases that are on different servers???
View Replies !
Definedsize Not Reporting Correctly?
I'm connecting to a MySQL DB (4.0.26-nt) using ODBC in ASP and trying to use AddNew to add records to some tables. When assigning longer string values to a varchar field, I get the dreaded "Multiple-step operation generated errors. Check each status value." error. I know that this is related to trying to stuff too much data into a field, but... Here's the funny thing -- when I check a field's defined size using: rs(myFieldName).definedsize, it reports a number smaller than when I view the design of the table within MyPHPAdmin. That is, the field is a varchar(70), but definedsize gets reported as 50. Therefore my string of 60 characters won't fit and I get the error. Increasing the field's size doesn't change the reported definedsize... unless I drop the table and re-create. This is all on my ISP's server, so don't know if it's something they can deal with or not?
View Replies !
Master Child Reporting
Need to create a query that will pull a status field from a child table based on two seperate fields. One is date and the other is time. Can not use datetime field due to restictions in other legacy application. Want to select single related record with the highest date and time.
View Replies !
Reporting Software Like Crystal Reports
Got any recommendations for some software that can handle table as large as 800,000 records with joins to other tables to produce a time base report e.g. weekly slices of data. I guess you could say is similar to reporting a sales table but with thousands of transaction per week. I need a cheap solution about $100 USD. Software: PHP 4 or 5 + MYSQL on Windows XP
View Replies !
Recommend A Good Reporting Tool?
I am generating multiple mysql databases on embedded data acquisition units. The databases are not complex with only a couple joins. The data will be accessible two ways. 1.) Users will be able to download(mysqdump) a snapshot of the mysql data from an individual DAQ device onto a flash drive or their laptop's hard drive. 2.) Users will access a central server via LAN or WAN(internet) running mysql that will have data updated from the individual DAQ's in real time. I need to provide the ability to produce reports from mysql dumps on a users laptop and produce similar reports from a connection to a mysql server. Is there a tool that provides a client app that can use a pre-made template, read a CSV file to produce a report and also use that same or similar template to produce live reports from a sql connection. I would prefer the reports be html pages, though pdfs would do... I would prefer open source but that isn't a hard requirement.
View Replies !
ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mysql.sock' (13)
I have a problem connecting to sql and can't find anything on the net to solve the problem. I have some sql databases running on a server. when I'm root on the server and I want to login to sql I do "mysql -ustudent -p -Dwordnet30 and it works fine. when I'm logged in with the user account on the server, i get this error message: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) so with the same user name in mysql, i can log on when i'm root, but not when i'm the user. the grant table for the user looks like this: Code:
View Replies !
Can't Connect To Local MySQL Server Through Socket '/home/data/mysql/mysql.sock' (13)
I just installed mysql on linux. If I open a terminal, su to root, then type "mysql", I am able to connect to the server and run my queries. If I exit out of su so that I am my own id (baisley) and type "mysql", I get this error: Can't connect to local MySQL server through socket '/home/data/mysql/mysql.sock' (13) Any idea why? mysql.sock has full permissions (read/write/execute), so it should be accessable by user baisley. If I am baisley and I run "mysql -u mysql" (as mysql is the user that the RPM set up), it will connect. What I would like to be able to do is run this without having to be user mysql all the time. How do I go about setting that up, or is it better to run all my queries/make tables as 1 user?
View Replies !
ERROR [HY000][MySQL][MyODBC 5.00.11][MySQL] 2006 MySQL Server Has Gone Away
Hosting Package Environment: ASP.NET ver 2 MySQL 5.0 FP Extensions 2003 Progression: Developed Website Outline Developed Database in Access2003 Migrated AccessDB to MySQL @ Hosting Service using Migration Tool. Can connect using MySQL Admin tools and run queries fine and all data, relations etc. are there. PROBLEM: (The heart of the matter) Starting simple, created GridView Control using Microsoft Visual Web Developer 2005 Express, a few glitches here and there, used the MySQL Connector/ODBC v5.00.11 followed instructions. Can see database in Database Connections Window but when I try to connect the GridView Control to it I get: "Database schema could not be retrieved for this connection. Please make sure the connection settings are correct and that the database is online. ERROR [HY000][MySQL][MyODBC 5.00.11][MySQL] 2006 MySQL server has gone away" Had thought that "Microsoft Visual Web Developer 2005 Express" might be messing with the ODBC driver so thought to download the .NET Connector. That's when it all went bad. The documentation does not say how to install or use the connector or where to put the files. It seems to assume that these bits of information are common knowledge and I suppose that if I had kept up with the technology it might be. But alas I didn't and it Isn't and It Don't work.
View Replies !
Could Not Load MySQL Driver! Compile Php --with-mysql Or Install The Mysql.so Module.
I am trying to install Media Wiki 1.5.2 on Windows XP and I have already installed apache_2.0.55-win32-x86-no_ssl ,mysql-5.0.15-win32 and php-5.1.1-Win32 . When I am trying to install Media Wiki 1.5.2 I receive the following message : Warning: dl() [function.dl]: Not supported in multithreaded Web servers - use extension=mysql.so in your php.ini in C:Program FilesApache GroupApache2htdocsmediawikimediawiki-1.5.2install-utils.inc on line 17 Could not load MySQL driver! Please compile php --with-mysql or install the mysql.so module.
View Replies !
Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mysql.sock' (11)
We run Bitrix CMS and upon installing the web statistics module, it will sometimes show this error: Error! mysql_connect('-', '-', '-') Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11) The max connections has been raised to a 1000... and SHOW GLOBAL STATUS says for the maxed used connections: Max_used_connections 273 The server does not really max out...
View Replies !
How To Configure MySQL ODBC Driver To Connect To A Mysql Server On My Own Side Of The Router?
Using MS Access, I have attached to MySQL servers in other states and other countries on the other side of my router. But when I use the MySQL ODBC driver 3.51 to connect to a MySQL server on my own LAN, the driver tells me it cannot make the connection. Here are the ODBC driver connection parms: Data Source Name: (free field - name my "my linux box" will do nicely) Host/Server Name (or IP) - something like MSQLUserName@ServerName.net has worked fine for me in the past. Now I'm trying 192.168.1.106 Database Name - whatever, mysqldb works fine, any valid db User - root Password - myrootpass Port - 3306 has worked fine 4 me N the past. Dunno whether 2 use now SQL Command On Connect - haven't ever put anything here Perhaps there is some configuration in mysql user privilege for the mysqluser "root" that would prevent him from logging from a remote PC to the mysql server?
View Replies !
Warning: Mysql_query(): Can't Connect To Local MySQL Server Through Socket '/tmp/mysql.sock' (2)
I'm trying to connect to my MySQL database (sitehosted by GoDaddy) using PHP. I am having these errors and don't understand what they mean Warning: mysql_query(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6 Warning: mysql_query(): A link to the server could not be established in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6 Notice: Query: SELECT * FROM types MySQL error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 6 here4 Warning: mysql_close(): no MySQL-Link resource supplied in /home/content/n/l/a/nladmin/html/v5.0_3/c_register.php on line 13 I've checked paths and connection settings and don't see any problems. My guess is now that the problem is coming from the opening and closing of the DB. my script, c_register.php uses a require_once('../mysql_connect.php') to open the connection to the database. But I also have a function definition in c_register.php that uses require_once('../mysql_connect.php') when called because it needs a connection to the DB. Here's a visual that might help:
View Replies !
MySQL Error Number 2003 :: Can't Connnect To MySQL Server On 'hostname'(10065)
I was running an older version of the query browser a while back to connect to an older version of mySQL (3.0) running on a linux box. The server hasn't changed, but the query browser has been upgraded to 1.1.10. I can't go back to the older version of the query browser because the machine that ran it got re-formatted so I downloaded the new version and installed it. So ... I get the following error when I try to connect: MySQL Error Number 2003 Can't connnect to MySQL server on 'hostname'(10065) Interestingly, I wrote a simple PHP script to connect to the server and pull some data off of it:
View Replies !
Table Rows Inserted By Embeddded MySQL Cannot Be Retrieved By MySQL Tcp Client
I have encountered a weird behavoir of embedded MySQL. Through a simple program I made (in Delphi 6), I can insert rows to a table through embedded MySQL and I can retrieve the rows from my program. But using mysql.exe which points to the same table (through 127.0.0.1, with the same basedir and datadir), I cannot see the rows I inserted using my embedded program. Another way around, the rows inserted by mysql.exe can be seen in my embedded program. But after a row is inserted by mysql.exe, the rows inserted by the embedde program are deleted (or cannot be queried). Can anybody explain why is this? Is there a way to fix it?
View Replies !
DBD::mysql::st Execute Failed: Lost Connection To MySQL Server During Query
I am using perl to connect to a database and then pull the rows off of the table one by one to manipulate the data. If I use a smaller table (~8 MB), I wait for around 20 seconds but then the table values are read just fine. However if I use a larger table (~30 MB), I wait for a while and then I get the message: DBD::mysql::st execute failed: Lost connection to MySQL server during query I have tried searching for the solution to this problem and haven't found anything that helps yet. I have changed the values of 'max_allowed_packet' and 'wait_timeout', with no effect. Any ideas?
View Replies !
I Want To Make Transfer Data Between MySQL Server To MySQL Local .
I want to make transfer data between MySQL Server to MySQL Local . My Environment. Server < --- > My PC Client Server = ::::: MySQL DB Server ( for Linux ) ::::: Apache .. ::::: Linux PC Client = ::::: Window ::::: MySQL run localhost ( for window ) How i transfer data from mysql server to mysql local .? Caz i don't want to connect via 3306 port .. Can i use others way?
View Replies !
Can't Connect To Local MySQL Server Through Socket '/tmp/mysql.sock'
I've installed MySQL-4.0.14 under RedHat 8, using both rpm's and compiling from source. When I try to run MySQL, I get the following error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' After much searching on Google, and reading many newsgroup threads on this error, as well as reading the manual, I'm still stumped. Most of the advice I've found suggests that the path to mysql.sock is wrong, which makes sense, but I don't have the file mysql.sock anywhere on my machine, so obviously I can't correct the path.
View Replies !
|
TRACKER
