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 Complete Forum Thread with Replies
Related Forum Messages:
SELECT Pid Where ( Word = '123' AND Word = '456') -
I've got a DB table called "index" that contains 2 columns being "pid" (page id) and "wid" (word id). What I want to do is select all pid's that have... this word, and this word, and ( this word or this word). So I go... select pid from index where ( word = '123' ) AND ( word = '324' ) AND ( word = '456' OR word = '678' OR word = '876' ) But even though I know there is a page with pid 1 that has rows in the table with all of those numbers, nothing gets returned - nor does MySQL return an error.
View Replies !
Key(e) Which Is In Middle Position Of A Word And In Last Of The Word
code select id,myString from myTable where myString like '%e%' result (1) I love you (2) Here we go (3) Nice to meet you (4) mell me. I have myTable like the above. I like to produce only the record which has the key(e) is in middle position of a word and in the last position of the word. The following trial code doesn't work correctly, but it will show what I want. trial code select id,myString from myTable where myString like '% %e%e %' result NONE target result (2) Here we go.
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 !
Microsoft SQL Vs MySQL
I am having a program developed in Microsoft SQL. I am going forward with the idea that we do not need their sql or windows to get it all running. saving money makes the boss . i asked if we could use mysql instead. they said something like " because the application is built for microsoft sql it uses colons and mysql uses semicolons. " The queries that the program runs internally that is. whatever, they are different they say. does this have any validity?
View Replies !
MySql Vs Microsoft Sql
Is MySql and Microsoft Sql pretty much the same? I mean do they work the same? I have a friend that has his own server and wants to store the site on his server but since I have never used Microsoft Sql I dont know if I will be able to use it.
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 !
Microsoft SQL And MYSQL Together
I need to install MySQL in the same machine where is installed Microsoft SQL Server too. Could MySQL and SQL Server work fine together or I need to unistall Microsoft SQL Server first (option that I cannot consider because it has needed by any others programs)?
View Replies !
Microsoft SQL -> MySQL
I am not sure if this is the right forum to ask, but I have a Microsoft SQL statement which doesn't seem to work in mySQL: select ProjectID,BugID,BugTitle from Bug where Cast(BugID as Char) + Cast(ProjectID as Char) not in (select Cast(BugID as Char) + Cast(ProjectID as Char) from BugTracking) Anyone has any ideas how I can modify the above script to make it work in mySQL? If I run the above script, instead of giving me 4 records in MS SQL it is giving me over 1000 records in mySQL.
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 !
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 Access Database
i need some advice as I'm sure there will be a way to do this i just don't know it. I have an access database that i use, however i need to share this with my work college who is in another location. So i was wondering if there is some way i can make all the data online so it runs from something like an MySql database and we just use the software to execute it all.
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 !
Odbc 3.51 And Microsoft Access
I have an access database using mysql tables, developed on one machine on which is mysql. When I put this DB onto a client, it works okay. We took this client pc to another location with a different machine hosting freshly installed mysql and the db is still looking for the original IP address. Even when this is changed to reflect the new machine, it still looks for the old one. I cannot update table links, yet if you go to odbc and test the connection, it says connection successful.
View Replies !
MySQL And Microsoft Access
I have a linux server running MySQL 4.0.12. I have a user accessing this database via ODBC (MyODBY), via Microsoft Access. The wierd thing is that he can write to the table(s) with Access, and he can extract data into Excel, but when he is viewing records in Access, he gets the correct number of rows, but all the cells say "#DELETED"...the data is still there, but Access apparently doesn't know what to do with it. I don't use Access when I write to the database...I use MySQL Front for writing and administering, and I am unfamiliar with Access. The only reason we are employing it with some of the users is their familiarity with Access, and MS Office. I am using the most recent MyODBC driver MySQL has on their site
View Replies !
Switching From Microsoft SQL Server 05
Right now we are running Windows Server 2003 running Microsoft SQL Server 2005 and I don't know anything about servers, but since I'm the one thats going to be learning everything about the database that is chosen I want to make sure I choose the right one. This is for a website thats going to be storing customer contact info to send out mailing lists at a later date and also for a Ecommerce Site. I was wondering what are the advantages with MySQL compared to Microsoft SQL Server 2005? And whats the major differences if possible. Trying to convince the rest of the people that I work with to convert to MySQL if it is the better choice for what we need. Using Windows NT WEBSERVER1 5.2 build 3790 Microsoft-IIS/6.0 Microsoft SQL Server 05
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 !
Path Of MySQL Database In Microsoft LAN
All computers in the LAN are running windows OS. The MySQL database is installed on a server and a script is running on a client. I have problem to use the script to connect and query with the MySQL database. What is the path or address of the MySQL database?
View Replies !
Microsoft Access / MySQL Linked Tables
I've got a UTF-8 database table with Japanese text in. I thought I'd start a new post as its a seperate issue to my previous one. I'm trying to set up MS Access using linked tables to access the data. I'm using the MySQL Connector/ODBC 3.51 driver. Trouble is its displaying the data as ??? ??? ??? like this. I need to somehow find a way of making the odbc connection or access into UTF-8. Also, the other client I'm using ( Aqua Data Studio ) displays the text incorrectly. I know the data is ok in the actual table as if I retrieve it it displays on my web page ok. EDIT: It displays FINE in MySQL Query Browser, part of MySQLAdmin. This proves its the client.
View Replies !
Int Fields :: Error :: Microsoft Cursor Engine '80040e21'
I am using ASP, connecting to MySQL. I have an issue, that appeared to be working OK, but having just read my web logs, have found a problem. I am using MySQLFront to connect to my ISPs MySQL Server. I have created a table, with a defined int field, 11 wide (e.g. MyField Int(11) ) Now, I am inserting a number that is 10 wide into it. However, just lately, I am getting... Microsoft Cursor Engine '80040e21' Multiple-step operation generated errors. Check each status value. Two typical numbers I am inserting... 8340801334 5731311330 In order to get around the problem, I have made the field a varchar(11) but would prefer to go back to int(11).
View Replies !
Graphical Interface Hangs When I Try To View Conents Of Table
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 !
Import Data Conflicts From MSSQL Or Microsoft Access
we have designed an application which contacted with a MySQL database. A client of ours wants to pre-collect data to a Windows-based database like MS SQL, or Microsoft Access. How it is possible to import these data into the MySQL database successfully and with no problems? Also, the character encoding is set to Unicode UTF-8. Which database supports Unicode in order to eliminate possible conflicts?
View Replies !
|
TRACKER
