Using C Interface To Access SQL Data On A Website
Is it possible to use the C interface to access data held on a mySQL server, preferably without needing to use anything like IIS.
View Complete Forum Thread with Replies
Related Forum Messages:
Creating A Website Forum: Use Existing Website MySQL Db Or Create A Second Db?
I am getting ready to start coding my own forum.... to seemlessly integrate it into my existing website. My question is this; should I: a) create the new forum tables in my existing database (used for the website user accounts etc.), OR b) create the new forum tables in a separate new database (it would be on the same server with same u/n p/w) Which one is the better option? I've been banging my head over trying to decide which way to go...
View Replies !
Displaying MySQL Data On Website
Currently, our neighborhood directory is in Microsoft Access, and every few years we would have it printed professionally and bound. I have Reports which formats the data for the printed directory. I would like to add the directory to the website, to replace printing it. I can easily create the tables and insert the data. I'm not sure how to go about displaying the directory data. Is there is a way to create a report and display that? Each entry represents a family in the neighborhood, but the fields that contain data may vary from family to family, such as the kids field. Also, I want multiple entries on a page - like a phone book.
View Replies !
Question Regarding MySQL Interface Options And MySQL Vs MS Access
First, there are many applications available for interacting with MySQL. One of the things that frustrated me at first was the CLI. I know that it's the foundation and understanding syntax is critical to making it all work in the end, but when dealing with large datasets, I feel that a GUI makes life easier at times. So, I started out with phpMyAdmin, seems to be 'the' geek-preferred application. I also ran into a few shareware ones here and there as well as Navicat, and I recently learned that there are 2 apps from MySQL.com for administrating the DB and creating queries. In your experience, what seems to be the best MySQL interface application? At the moment I couldn't say *exactly* what I'm looking for, but more-or-less something that will ease the headache of creating queries and managing users, tables, etc. Question #2: I have been hired to be a Web Developer, Network Admin, and Database Administrator all-in-one. We have are a retail company selling peuter goods and have a product line-up of about 100 items. The President wants a robust database to deal with everything. Right now we use MS Excel for our needs. He says it's becoming cumbersome and wants to move on. I suggested MS Access because that's exactly what it's built for, companies that have been running in Excel and want more robust control over what they're doing. But the president keeps hearing this 'MySQL' buzzword and wants a MySQL database. Fine with me, I just know Access better, that's all. I've been cramming PHP & MySQL down as fast as I can and am starting to feel more familiar with both technologies. At the moment, I feel MySQL to be more of a headache (my fault I'm sure, I just don't know it yet) But For Example: To properly normalize a DB, I sometimes have to break a table into 3 tables. The first and second are no problem, but the third 'association' table is annoying (at least doing it CLI or phpMyAdmin). See, Access, you just make 2 tables and graphically set associations very easily. So, from what you know of MySQL, do you think it would be still superior to Access seeing as we want to integrate it into osCommerce eventually and possibly some of their user contributions?
View Replies !
MySQL Versioning Of PHP Data-driven Website
I have a website that I am designing that uses a bunch of PHP scripts to generate pages for a website from data stored in an underlying MySQL database. I have the PHP scripts under CVS, and using Apache and mod_rewrite I am able to access different versions of the website from the CVS project - each with their own set of PHP scripts. The problem is this: I would like to version the MySQL database as well. This means that there would be multiple MySQL databases, with slightly varying schemas on the server. Each PHP version of the website would point to a corresponding MySQL database for its data. Multiple PHP versions could point to the same DB, as long as each PHP version has SQL statements matching the schema of the correspoinding DB. One version of the DB would be a live version of the site (v1 for example, above). Users accessing the site would causes changes to the data in the DB (not the schema, of course). The second version of the DB (v2) would need to basically be a slave replication server, using DB v1 as the master. This will allow DB v2 to be up-to-date with all of the user updates that appear in DV v1. DB v2 is the development copy. As the design matures, schema changes will be made to DB v2. At some point, DB v2 will be made the "live" server, essentially taking the role of DB v1. As long as fields are only added to tables in DB v2 to modify the schema, the developer can easily just feed the updates from DB v1 to v2, to keep the user data current. The complicated part is when schema changes need to be made to v2 where fields are deleted, renamed, moved, etc. What is needed, basically, is a system that can track the ALTER TABLE statements, and appropriately translate the UPDATE statements from DB v1 to the new schema of DB v2. The developer could specify non-obvious and more complicated changes in some sort of syntax in order to clarify the changes to the underlying schema - thus allowing the generation of the proper relational algebraic (SQL) statements from the original UPDATE statements. Does anyone know of an existing system or set of scripts that accomplishes this, or can offer an alternative solution for DB versioning?
View Replies !
LOAD DATA INFILE To Import Data Exported From A MS Access Xp
I am trying to use LOAD DATA INFILE to import data exported from a MS Access Xp table. But all i get in the date field is 00:00:00, as Access exports DATE and TIME and MySQL seems to use just the TIME portion of this. Is there any way to ahve MySQL import just the DATE portion or is there any way to have Access export only the DATE portion?
View Replies !
XA Interface
In 5.0 Manual,I see XA Interface( use SQL[XA START,...],Connector/J ). But, 1. I want know XA Interface in C API. ( using xa_switch_t like other DB ( oracle, infomix, .. ) )I can't find this in Manual. 2. If MySql is not support this, does Mysql have the plan?
View Replies !
XML Interface
Does anyone know of any project that would provide an XML interface to a database? I would like to create an XML document describing what I want to do, send it to a server and get some XML results back. Has anyone heard of anything like this?
View Replies !
Interface
MySQL is just the language that the database is programmed in, in a nutshell is that right? If so, it's not like Microsoft Access where you can create a user interface so the user can input data and apply queries to data etc. These are my assumptions, so my question is: Is there an open source application that applies a user interface to a MySQL database so a user can do these things?
View Replies !
Import Access Data
I have a database that contains information on items for sale, prices, etc. Every few months or so, I need to import data from an access database, to do the following: - insert any new items from the access database into the mysql database - update any of the current items with new information (such as price) I've done a good bit of searching on this, but most of the answers here revolve around a one-time import...this is something that needs to happen regularly.
View Replies !
Access To Data Bases
I downloaded the "Windows" version and installed it on my PC. I signed in as "root" using the following command on the shell: mysql --user=root mysql I added a new user named "admin" with the followin command: GRANT ALL PRIVILEGES ON *.* TO 'admin' IDENTIFIED BY 'pass.word' WITH GRANT OPTION First, when I try to acces mysql with the following command: mysql --user=admin -p and then typing the password when I'm asked, the access is denied and I get the following message: ERROR 1045: Access denied for user: 'admin@localhost' (Using password: YES) I need to enter mysql WITHOUT the password option. I expected to "create" new databases using that user, but whenever I try to do so, I keep on getting the following error message: ERROR 1044: Access denied for user: '@localhost' to database 'pelos' Isn't supposed to create a DB when I have assigned ALL PRIVILEGES to user admin? Why is it not accepting my password?? Sorry if the questions are stupid for most of you, MySQL connaisseurs.
View Replies !
MS Access Data Into MySQL Db
I have one table from an MS Access database full of records that I want to import into a mySQL db. Is there an easy FREE way to do this? I downloaded a DB Converter MS Access Conversion Wizard tool and that created a file with my table and records from my Access DB. The file it created was an .sql file. Now how do I import those records into my mySQL database?
View Replies !
Mysql GUI Interface
is there any GUI for mysql is availabe ??? just like SQL server or ms access .. not even like apart from phpmyadmin but like windows on which we can make database , tables , reocords .... etc .. i guess micro olap have this .. but its not free ..
View Replies !
Visual Interface
i tried the gui tools in mySQL.com but Im having some trouble instaling them, eventually ill be successful but I heard there are simpler packages, I just want to see the ER diagram of my databases, for the rest I can handle.
View Replies !
End User Interface
My goal is to set up a database to track our inspection data at our company. Currently, we are using Excel spreadsheets to make inspection reports. I would like to be able to get this information into a database so that a technician can set up the inspection plan before the inspector gets the part (the inspection plan would include the Customer Name, Part No., Revision, Items to inspect, etc.) Then when the inspector receives the part, they can pull up the inspection plan and enter the dimensional values obtained for each attribute on say six or ten parts and print an inspection report. Then this data can be sorted and viewed in different ways. We have three Windows 95 computers and three Windows 98 computers we are currently using on an ethernet network. I am thinking of using MySql, Apache and PHP to set this up. Would there be a simpler way to create an end user interface to MySql other than using PHP and Apache?
View Replies !
Using MS Access To Get Data In / Out Of A MySQL Database
I have no experience using MS Access to interface with MySQL. I have a tiny MySQL database that might need to have Access connect with it over the internet and grab data/update etc. Is this practical and what does it take to do it? My project is not time sensitive but I'd like to see what methods I can use to do remote queries with my database running on a *nix/Linux server.
View Replies !
Access To Mysql (import Data)
I have been using MS Access for some time and want to convert/move to mysql I should like to import the tables rather than re entering all the data can anyone point me in the right direction or where I can find a good intro to MYSQL?
View Replies !
Access Intranet Data Base
I have a db in my intranet, and I need to access the information from my web site which is hosted somewhere else (internet). Whats the best way to do this? Should I use a public IP for my intranet server? (then theres no point on hosting my web site some where else right?Could I syncronize both MySQL data bases?
View Replies !
Access To Deleted Data On Desktop PC
I'm involved in a court case with someone regarding a website using the Xoops CMS. They want details of news items submitted to the site but subsequently edited by myself. I've stated that the original submission has been overwritten and now no longer exists in any form. They claim that it might be 'cached' on my desktop PC, but I've explained it doesn't work like that and that the information they seek has gone forever. (I think they are getting confused with IE cached files.)
View Replies !
Importing Data From MSSQL And Access 97
I have a need to run a daily data gathering to pull information from three separate applications into a single MySQL database for reporting purposes. We are currently doing individual reports using iReport which works well, but I want to automate things - here's what I need to do: Import data from remote MS-SQL databases Import data from local or remote Access 97 databases Ideally, I want this to be a batch process running as one or more cron jons on a linux server (PHP or or PERL scripts?) rather than a GUI-driven exercise. I am looking at the various bridges from Easysoft but wondered whether there is a better place to start?
View Replies !
Updating Data Into Mysql Using MS Access
I am finding loading and updating data into mysql extremely cumbersome. I have set up MS Access to work as a front end and can export and import data to/from mysql table. The easiest way is to load all the data in an MS Access table and export it to mysql. So far no problems. However, when I import this table back into MS Access, edit it with new data and then try to export it back into the same table in mysql it won't allow me to do this telling me that the already table exists. I can get round this by changing the name of the table in MS Access (say from 'Table' to 'Table1') and exporting this. But I suspect I will have to modify any PHP scripts I may have in the future to reflect this change.
View Replies !
Limiting Users' Access To Only Their Data
I'm working on a single database with a dozen or so tables and fifty or so users. Essentially every record has a field defining the user who generated the data; think scientists' measurements. Up until now we have not been concerned with restricting access to the data. Now we would like to implement some security in the sense that a particular user would only be able to interact with his or her data; that is I would like to restrict a user's privileges based on the value of a particular field for all of the records in a given table. Is this possible? One idea I had was to generate a database for each user with only his/her data, and grant the user privileges to only this database. This seems a bit clumsy though. Other than that, I can imagine implementing something through the front end when the data is selected, but this seems problematic because if someone knew SQL and their username and password they would be able to access everyone else's data with another frontend.
View Replies !
Mysql On Linux-gui Interface
Is there a GUI interface that is easy to install to manage MySQL on linux? I'm trying add a user account and password to the db server but I'm not having any luck from the command prompt.I'm trying to setup the nexus discussion software.
View Replies !
MS-Windows Front End Interface
Is there an MS-Windows front end interface for mySQL ? I'm thinking of an MS-Access sort of approach for basic database configuration and maintenance. Maybe there's a back door way to ODBC myself from MS-access to mysql on a Windows system ? Does Mysql have an ODBC front end I can get in through ? Any pointers to some directions ? I plan to use perl/my-sql for web work. But, it seems like a _lot_ of work to build the databases and populate them via mysql commands. I'd like to be able to work them _locally_ through a basic data maintenance program and then move it to the (web) server when ready.
View Replies !
Graphical Interface Hangs
In the older version of mysql, when I pressed browse, I could see the content of the table. If I ran a query, such as select * from table, it would scroll out the result. Now, with the newer version, all it does is hang. Is there some setting I'm missing that needs to be changed? This was newly installed on our apple server.
View Replies !
Local Interface To MySQL
I need to harvest data from MySQL tables. My experience is with MSSQL and Enterprise Manager. I also connect to MSSQL with Access and ODBC. I don't need to manage anything. I just need the data. What kind of interface can I use to query and save data locally? I don't see any MySQL drivers available when I try to setup an ODBC from my desktop. Can I download one somewhere?
View Replies !
MySQL Interface Required
I hope this question is appropriate for this group. My server provides a MySQL database. Do I need a third-party interface to add tables and records to it, or is their another way?
View Replies !
Interperted Language To Interface
my question is, what is the best interperted language to interface with MySQL? i was told Perl by some and Python by others. the reason i am looking is because i wanted to create a custom gui and atmysqlt to make it easy to add entries or pull up certain records from the database.
View Replies !
Microsoft Word Interface
I am developing an online app that helps many editors review articles, check for errors, add new articles, etc. The editors are used to using Word to help them go through several articles at once. Because of this, I'm hoping to figure out a way to allow several persons access to their content on a MySQL database online via their local install of MS Word. I have been working some with the OBDC mysql provides at http://www.mysql.com/products/connector/odbc/ (ver 3.51) and have been able to connect and retrieve some data. My problem is how do I update the users' articles online after they have finished reviewing them in MS Word?
View Replies !
MySQL C++ Interface Installation
After I downloaded MySQL C++ package & installed it, I can't compile any sources. System notes "undefine reference 'function' ", is anyone familar with gcc & MySQL C++ development package ?
View Replies !
Database And Client Interface
I am planning to use MySql for my building my database. I already installed MySQL on my system. I would like to know have two databases. 1. for developement 2. for storing the correct data from the development database. Can i have two databases on the same server, so that I can copy data from one database to another. Also, I am planning to interface matlab with MySQl. i.e., Matlab would be my client program. What drivers or connections do I need to download in order to talk to the database from Matlab.
View Replies !
User Interface With MySQL
is there product that provides a developable non-web user interface in the way that Access has one for its database? I've seen many that customize database routines, but what we want to do is create a user interface that includes logic without having to go through Php, Cfm, Net, or any of the web-based technologies.
View Replies !
GUI Interface Rennie Garcia
I have experience using other databases and wanted to find out if there is a high level GUI interface for MYSQL which enables me to create a database. I am using as a backend to a large PHP site and need any easier way of creating tables etc rather than using the command line editor.
View Replies !
Mysql Interface Generator
I wanted to know if there are any program that generates a webpage with the forms to insert data into the db. Example: I have a table with {id, url, desc} The program must generate a page with text fields to enter this information.
View Replies !
GUI Interface Book By DuBois
I have only read the book by DuBois and used samples at the command line. I would like to use this for work. I am avoiding the IT push to use Microsoft Access. I have 10 people in our group who need to share data (now about 50 excell spreadsheets). What I am really looking for is a GUI that can get me most of the way there. I can have my own server behind the firewall in our corporation so I am free to do my own thing. What I have found on the net so far is: Control Center Front SQLyog NAvicat Any feedback on these? Ease of use and reporting are most important attributes.
View Replies !
Export Table To .csv Via Web/PHP Interface
I have a website running Apache 1.3.31, PHP 4.3.0 and MySQL 3.23.45 (yes, I know...). Data from different tables is presented in lists on the webpage. I've been asked to add functionality to download lists as .csv-files. I have failed to find info about how to do this smoothly through a PHP script (not via command line).
View Replies !
Dumping Data To Easily Import Into MS Access
I have a db that I need to dump into a format that can be easily read my MS Access. I tried the dump with regular PHPAdmin. Then I used the dump to run a query in MS Access. Errors occurred because MySQL inserts a backslash, "", in front of an apostophe that user enters in a text field and MS Access doesn't know how to interpret that. Any ideas for easily getting whatever kind of data from MySQL to MS Access?
View Replies !
LOAD DATA INFILE :: Access Denied
When I try to issue a LOAD DATA INFILE statement from the MySQLAdministrator SQL page, I get the following error: #1045 - Access denied for user I am logged in and I have access to the file being processed, but still nothing. I've also tried this from a PHP script and get no response whatsoever. HOWEVER, if I use the Import tab from MySQLAdministrator, I am able to process the file just fine! How does this code differ from what I'm trying to do with the LOAD DATA INFILE command?
View Replies !
Access Denied With LOAD DATA INFILE
I'm trying to use the LOAD DATA INFILE statement to load data into a new database. I created the database using the ROOT id, then used... CREATE DATABASE SWAP; GRANT ALL PRIVILEGES ON swap.* to 'SWAPUSR'@'localhost' IDENTIFIED BY 'password' I then quit out of the console and restart it using the new userid - SWAPUSR (mysql -D SWAP -u SWAPUSR -p After logging in I create the first table... CREATE TABLE Comics; So far everything is working fine. However, then I try to load the data from a text file using... LOAD DATA INFILE 'c:wwwrootcomics.txt' INTO TABLE swap.comics LINES TERMINATED BY ' '; That's when I get the error... ERROR 1045 (28000): Access denied for user 'SWAPUSR'@'localhost' (using password : YES) If I try this using the ROOT ID everything works fine. However, as this needs to work with the non-root id when I load it to my host its a problem.
View Replies !
Upload .mdb Access Data Into MySQL Table
I'm new to mySQL, but used to SQL Server.....which I'd be using DTS for this whole process. I'm glad to have to learn to do it with mySQL though. I have an Access .mdb file, that I need to upload from my local machine to our hosted mySQL site via BlueHost. I'll be using phpMyAdmin. It looks like the only way is to import into an existing table is from a text file. Are there any other ways to take the .mdb file and copy it up, and into the mySQL table? I got a converter tool, Access2MySQLPro 5, which has 10 trial conversions. Didn't know if anyone else has better ideas? Basically, I want to take this .mdb file data and put it on the mySQL table.
View Replies !
I Want To Import My Data From Access Into My MySQL DB Online
I have a MySQL database which i access/modify/interact with via PHPMyAdmin. I have a table with about 20 fields and 609 rows which i need to import into my MySQL database. not all of the fields are the same, not all need to be imported, and all of the field names are different in my MySQL db. Is there a software i can get to make this process easier. or can i export the access table to some format and import it by specifying what datafields from the access table map to what datafields in the mySQL table? I've posted a similar request recently, but this one is much simpler. just need to get some data out of access and into mysql. Would great appreciate any help or software referrals etc. Much love and a merry xmas
View Replies !
GUI Interface For Unix Linux And Solaris Etc.
Is there a GUI Interface for MySQL ... that runs on Unix (Solaris, Linux, etc) There was an earlier thread about it - http://forums.devshed.com/showthread.php?t=51564&page=1&pp=15&highlight=GUI but most of these seem to run on Windows only.
View Replies !
|
TRACKER
