Another Program To Access MySQL Database
I have a list of 8 rows by 11 columns that I exported from Excel into MySQL to populate my Database and that all made it through.
I am now trying to create a label with a label making program that will connect to a database. I have installed the ODBC 3.51 driver and tested the link and it finds the file.
When I try to open the database file from the label making program it says "Error Reading Record Fields", I click on details and it says "ODBC driver does not support dynasets."
I have no idea what a dynaset is or why it is an error???
Is there a way around this?
I can save the excel file as a DBaseIII .dbf file and it works but I wanted to be able to use a database for better tracking of information.
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
How To Access MYSql From External Program
I have a Mysql database on a webserver and would like to access order information automatically from my home computer. I have the ecommerce software send me an email of the order and I wrote a VB program to extract the information from the email and populate an Access database. There must be a better way. Can I somehow have MS Access backup that database on my home computer?
Packaging A MySQL Database With A Program
In writing a visaul basic database program with Access as the database you simply copy the database file into the packager and it is installed with your program on the target machine. I am guessing that with mysql, since it is a 'server' program, it is not that easy. Am I wrong? And where would I find information on this. I have been working on a business accounting program and am a long way from finished, but I wanted something more robust than access as the database. I just need to know how to get the database to the target machine with my program.
How To Convert MS Access Database To Mysql Database??
now i have more than ten thousand data in MS Access database and now i heed change it in to mysql database!So do you know how to that?I think i not time to key in back this all data because it is imposible la,because more than 10 thousand data la!
Converting Ms Access Database To Mysql 5 Database
I've imported a ms access database into a table in a mysql database. The access database contains a field that holds date/time values in 'general date' format. These all show up at 01/01/1970 in the mysql database. I believe the field in mysql is wanting UTC and shows numbers when looked at from the sql command line (i.e. March 13, 2006, 5:31 pm is shown as 1142289086). How do I get the access data into that format so it will import properly?
Access To The Mysql Database
I've installed MySQL 4.0.20d-win on a Win2k server with service pack 3. When I perform a "SHOW DATABASES;" command I only see the "test" database. I understand there is also a "mysql" database which contains the priviledges table. I have logged in as root and the mysql client reports I do not have access to this DB. A couple of the reference books I've read, says I can access this DB but it is referencing an older version of MySQL server. My question is, "can I access the 'mysql' DB with my version of the MySQL server?"
MYSQL In A Program
How would I access a database from a program? All I need to connect in the program is the IP address or the URL, though I do not know how to get those from a database. Also, I'm still having trouble with this: http://forums.mysql.com/read.php?10,141978,141978#msg-141978
Converting A Mysql Database To MS Access
I have to convert a mysql database to Access with all of its tables and data inside them. Please suggest me some utility or some methode. I'm a ASP developer and I don't know anything in php so please guide me..
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.
Access Link To Mysql Database
I have set up two links in access to two different mysql databases. One allows me to add records and make changes. The other says that I cannot update the file and won't let me make changes of any kind. I have no idea what is different, or what I did different in setting these links up. Anyone know how I can make the database editable?
Access Mysql Database From Php Codes
I am using Apache2, Php 4.4.2, and mysql server 4.1 and have configured httpd.conf for apache and php.ini file for php. Now I am writing a small program to access my database on mysql server as follow: <?php $connection = mysql_connect ('localhost' , 'root' , 'aungmyinchin') or die (mysql_error()); echo "$connection"; mysql_select_db("dms",$connection); $query="SELECT * FROM FEATURE"; $result = mysql_query($query,$connection); echo $result; ?> But when I ran on browser (through an html link), I have the following error message as: Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:Program FilesApache GroupApache2htdocsSku-Feature.php on line 3 Client does not support authentication protocol requested by server; consider upgrading MySQL client.
Converting Access Database To Mysql
Have for some years developed applications in Microsoft Access. One of my clients now require the database to be usable nationwide. Cannot use replication as data changes must be immediately accessible to all users. I gather, to use Access on the net is either difficult or expensive (using Terminal Server, which is I understand one way of doing it, requires the purchase of multiple user licences and also needs a professional engineer to set it up, etc). Have no experience of mySQL. How difficult is it to create/convert the sort of forms one uses in Access to mySQL? Can one convert the data tables easily to mySQL? How about queries, reports, etc?
Using MySQL To Input Into Another Program
I have been working on a workaround to see if I can figure out how to get DATA from MySQL into another program. The other program is built on MS SQL server. The problem is that it is so bloated that a remote and my computer at the plant cannot correspond back and forwards. It takes approximately 10 minutes to key an order in to the remote plant. I was working on a much smaller database through MySQL and using OpenOffice.org as the front end. I just wanted to go a step further and see if there was a way to use a triggering mechanism of some sort to input the data from OOo/MySQL to the actual program the company uses.
Linking C Program With Mysql API
I'm linking a simple C code with mysql. I compile the code with this command: linux> gcc -L/usr/lib/mysql -I/usr/include/mysql sqlTest.cpp -lmysqlclient -lsocket -lnsl But it complains that "-lsocket" cannot be found. So, I removed "-lsocket" and try again, then I got the messages like /tmp/ccIelMdT.o(.eh_frame+0x11): undefined reference to `__gxx_personality_v0' /usr/lib/mysql/libmysqlclient.a(my_compress.o)(.text+0x66): In function `my_uncompress': /usr/src/packages/BUILD/mysql-5.0.27/libmysql/my_compress.c:85: undefined reference to `uncompress' /usr/lib/mysql/libmysqlclient.a(my_compress.o)(.text+0x11c): Infunction `my_compress_alloc': /usr/src/packages/BUILD/mysql-5.0.27/libmysql/my_compress.c:58: undefined reference to `compress' My system is SUSE Linux 9.1, and I installed mysql by downloading the rpm files from this site, and use "rpm -i mysql-xxxx.rpm" to install them. The libraries are installed at /usr/lib/mysql, and include files are at /usr/include/mysql. Can anybody tell me how I can configure my system to make it work?
Program MySQL With Apache
I don't even know what this is called, but I'm looking for a free tool that allows me to code MySQL and will work with Apache and PHP.
How Can I Access Mysql Database Running On Windows Pc
How can i access mysql database running on windows pc from linux server, on both machine i am using mysql 5 and perl 5.8.8 , ip of windows machine ie. 192.168.0.50 and linux server has 192.168.0.10 on single LAN.
Program To Optimise Mysql Queries
Basically im looking for a program that will take input (my query) and produce an output with a much nicer, more efficient query. I have seen sql programs that do this sort of thing, but nothing for mysql. Just wonder if there is any programs that i have missed? Tryed Toad for mysql, but that wasnt what i wanted, i dont want a program to admin a mysql database, simply to produce a more efficient query.
MySQL Admin Program/Script
I'm looking for an application, or php script that makes entering and retrieving information out of a database automated. The process would like so: I enter in the mysql un/pass etc. and create tables and rows. Also defining what type of input each row should have. Whether it be a checkbox, a dropdown menu, plain text input. Also defining what options for things like the checkboxes and dropdowns. After that, you would be able to go to a simple front end that had the inputs you defined. You could create your entries and retrive them. Sorting them how you see fit. Given the obvious use for such a thing, there must be plenty. I must not be wording my searches correctly though. I would prefer something free/open source.
Redirect Out Of Mysql Client Program To A File
I have mysql on MS Windows2000. I like to redirect the output/error messages of MySQL client programs to a file. For example, when I execute: "mysql --user=root --password=[wrongpaswd] --silent --database=mysql > errfile" The following error message is coming in the screen, not in 'errfile' "ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)" I also need to capture the same for utility "mysqlimport". How capture the output of these client programs in a file?
Create A C++ Based Program Using Mysql Odbc.
I want my software to be independant of operation system and databases. That's why I want to use odbc, and don't want to use MFC. Here I have some questions to ask: 1. On unix (like sun solaris), does there exists any kind of midware like odbc? 2. I search on the internet, and find most of the examples are based on PHP. Is there any c++ examples? 3.Once I chose odbc, does that mean that whatever kind of database I would use later, I don't have to change my source code? 4. now I program on window xp platform. If I use odbc, when impliment my program to a unix platform, do i have to rewrite my code? I just started this project, and I'm a newbie. The problems may be a little bit of stupid. Can you guys give me some information about this topic?
Displaying MySQL TEXT Datatype In C Program
I'm currently trying to display the contents of a field which datatype is set to TEXT, I'm trying to output this through a C program. the line is as follows: while((row = mysql_fetch_row(result)) != NULL) { printf("SID: %d Sensor: %s",(row[1] ? row[1] : "NULL")); } I have trued %c and %s in to print the Sensor name, however %s crashes the program and %c produces a smiley face.
Making Connection To Mysql From A C Program On Windows
can any one please tell me "how to make a conncetion to mysql database from a C program on windows " . Please help me by giving possible code for making a conncection,selecting data etc. i.e. what library files i need to include,what are the functions needed to be called.
Create My Own VB Backup Program For A Remote MySQL DB
I understand that the basic principles to create a TCP/IP backup program for a remote MySQL DB are: a) Query/retrieve the schema. b) Query/retrieve each table and create inserts for each row of data. The way I want to do it is even more basic, as I know what my schema is so I only need to reterieve and create the insert rows to put into my backup text file, which is basically a large DDL. The problems that I am experiencing are I want to keep the schema in an external text file so that I'm not storing it in the actual app and I thought I would also have another external file to store each 'select * from tablex' query. Is this a good way of doing it? How would I merge the results together to make a new (and 3rd) external text file backup?
Problem: Displaying MySQL TEXT Datatype In C Program
I'm currently trying to display the contents of a field which datatype is set to TEXT, I'm trying to output this through a C program. the line is as follows: while((row = mysql_fetch_row(result)) != NULL) { printf("SID: %d Sensor: %s",(row[1] ? row[1] : "NULL")); } I have trued %c and %s in to print the Sensor name, however %s crashes the program and %c produces a smiley face.
MySQL Database - Adding New Data Source 'Access Denied For User'
I am trying to install MySQL on my machine at the moment. I have downloaded the file mysql-essential-5.0.21-win32 from the MySQL website and installed it. I then downloaded MySQL Control Center, which came zipped in a folder called mysqlcc-0.9.2-win32. I have installed both applications and I have a MySQL database which I have acquired from elsewhere. I copy/pasted it into my C:Program FilesMySQLMySQL Server 5.0data directory, but when I try to add a new database in MySQL CC it doesnt allow me. I have also installed the ODBC for MySQL (called mysql-connector-odbc-3.51.12-win32). However, when I try to add a new data source in the Control Panel I get this error: [MySQL][ODBC 3.51 Driver]Access denied for user 'versiontwo'@'localhost' (using password: YES) versiontwo is the name of the database. the database has a password.
How To Allow Access Just To One Database?
I have several database setups on my hosting account using Cpanel. I want to allow an individual access to just one of these databases using phpmyadmin. However whenever I try to go to the direct link to the open database in phpmyadmin it asks me for a username and password and just won't accept the dbusername and dbpassword. It wants the hosting package uname and password! Thus when you log in like that you can access all the databases under phpmyadmin. Am i missing something really simple here?
Can't Access Database
I have just installed MySQL version 5.0.18 on a VMWare session running Suse 10. I was able to start the server, create a database, and create a user with permissions to said database. I am able to connect to the database and run queries on it remotely from the host OS (keeping in mind that the database is on a virtual machine, so this is technically remote access). However, if I run the admin.php file for PHPNuke or the vb_test.php file from vBulletin, I'm unable to access the database. Do these forums not support the newer versions of MySQL?
Access Only To A Particular Database
How do I grant full access on a particular database (all tables) to a particular user. I issued the following command but when I log in as the user and do I "show database" I don't see the database: grant all on mynewdb.* to 'gregh'@'%'; This way anyplace the user gregh logs in from, the user would have access to mynewdb. However, when gregh logs in from localhost, and does a "show databases", only the "test" database shows up. Am I doing something wrong?
Access Database On Web
I have a database on a webserver and now would like to write a small windows application to access this database, read and write to it. As I understand it correctly, I have to code in the username and password of the database. So, the question is, if I deploy this little application to other users, can they not get hold of my username/password by just decompiling the application? Is this not a big security risk? Or are there other ways to read and write to the database without me coding in my password?
Access Database
I am having trouble getting started. I have an Access database with multiple tables in it, and I want to post it on a website so that people can search it and edit it. I dont konw really where to begin. I have a domain with MySQL capabilities, but I really dont know what to do next. I would really love some hand holding, and it wouldnt take that much time to teach me how to do it. IM me at RND328 if you are willing or just respond to this post.
Access Database
A friend of mine mailed me a access database (.mdb), but I only use Linux (RH 9.0) . Is there anyway that I can open the database in mysql?
Access To Other Host Sql Database
I currently own a website with various different MySql databases. I use the mysql_connect ("localhost",""....) to connect. I would like to give another website access to this database. What would they have to enter in place of "localhost"?
Restrict Database Access
I have a complete application developed using MySQL as the data server and Microsoft Visual Fox as the GUI. My users all have privileges dependent upon their job functions BUT I can not find a way that I can stop other applications from accessing and changing the data as long as they do so with a valid userid and password. The reason this is a BIG problem is many of the 'rules' governing table updates are part of the application and NOT part of the database. I can not use the IP validation as it is quite possible the unwanted access and changes could come from the same IP that a valid change would come from. This seems like it should be so easy to solve but I have spent many hours in the documentation with no results.
Database Access From Different Locations
My database is housed in a directory say "CHAMPION".Now, i copied this directory contents to a different location say "FORMULA1". The formula1 directory does'nt have the database. Is it possible to display the contents of this database from the formula1 directory???? (All the directories are in the server). Or in other words, please clarify the following if I does'nt make any sense above. In my server, there are 3 directories: "CHAMPION", "FORMULA1", "DRIVERS". The above 3 directories are for three different webpages.I want to share one database to all these three.Where should i place my database???Right now, my database is placed in the "CHAMPION" directory and the champions webpage is working fine.I want "FORMULA1" and "DRIVERS" webpages also to access the same database.
Access A Database From Different Websites
Is it possible to access a MySQL database from a domain other than the domain that the database is phtsically on, and if so, how? For example, if my database is located on www.site1.com, and I want to access it from a script on www.site2.com, how do I do it? For arguments sake, assume both websites are physically located on the same server, and they share an IP address of 123.123.123.001.
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.
Mysqlimport Program
I have been using load data in file command until recently on a windows machine - works fine. we are now using a Netware 6.5 box and are trying to use mysqlimport from the command line. I am using: mysqlimport --password=123456789 --fields-optionally-enclosed-by="" --fields-terminated-by="," 0608c sys:mysqlinstirling.txt to import a CSV text file into the database 0608c. the data looks like this "2007-06-28 16:07:00",0,13.58,15.77,-13.35,-12.69,-13.36,-6.61,-3.821,...... when the program executes it seems to give the desired results except the timedate is all zeros...
Extraction Program
I am looking for a simple extraction/load program to load data daily from a Progress 8.3B database via ODBC to a mysql 3.23.57 database. It does not necessarily need to do any data-type transforms. It need to run on Windows 2000 and be able to run it as a service, or as a cron task if running under Unix.
Setup Program
I'm writing a Java setup program for installing a JDBC app, which connects to a Mysql database.I want to create a script in order to provide final user setting privileges in that database and add it a table, without needing to write Mysql commands. How can I do it ?
DB Modelling Program
Is there a database (ERM) modelling program for Mac OS X that can handle MySQL? Maybe a freeware one?
Php Email Program
Does anyone know of a php or even cold fusion based script out there for accessing email that can be customized? Right now I use SquirrelMail which is great, however, you can't really customize it to tie in with your web site. Is there something out there that is very flexible that I could make fit right into my site which is pretty reliable in terms of web email?
Php Email Program
Does anyone know of a php or even cold fusion based script out there for accessing email that can be customized? Right now I use SquirrelMail which is great, however, you can't really customize it to tie in with your web site. Is there something out there that is very flexible that I could make fit right into my site which is pretty reliable in terms of web email
How To Make Database Access Fast
In my linux server (LOCAL), *accessing data through the PHP scripts from MySQL (3.23.41)tables, it is taking more time. * Earlier it was very fast. * Now a days some reports it is taking more than five minuits. Earlier it use to come with in a minuit. *What may the problem and what I have to do spead up the process.
|
TRACKER
