MYSQL :: Connecting To Mysql From MSAccess 2000

MSAccess Front With MySQL
I already have a MySql DB running and I am using some PHP to manipulate the data. I am in dire need to use a "Combo Box" such as usable in MS Access. I already have an Access front end (just starting it up actually) linked to the MySql DB. I am running into problems with the combo box producing a #DELETED field message after the "After Update" event. I can't seem to find a resolution to this.

If I close the form and go back to it, the record is there. So the question is how do I get around this issue? I am only using Access for the combo box, it seems the easiest way to do what I want. JavaScript and Java is beyond me at the moment,I would much rather use them, but I have not the time to learn them.

Migrating An MsAccess DB To MySQL
Well, as the subject of this post says, I want to convert a microsoft access database into a MySQL database. I'm already running Ubuntu 6 server with a LAMP installation. The MySQL server is already up and running and I've created some test databases. The Access database is located on a Windows server.
I have full permissions to the Access database and the MySQL database. I'd like the migration to be as simple and painless as possible. Any recommendations on free tools to use?

Convert MSAccess Db To PHP And MySQL
I created an MSAccess db a few years ago that I want to use online. My ISP uses PHP and MySQL. I was able to convert the db to MySQL using DBTools Manager Professional and create alot of the forms for individual tables by using PHPMyEdit. I don't know how to re-create some of the forms that use lookup values or queries (let alone if or how you create a lookup table in MySQL or create sub-forms)

I've been reading up on PHP and MySQL but unfortunately, like a lot of us, do not have the time to develop the skills and I was at one point hoping there is a software package or process for doing the complete migration. After my limited research I figure that I should take a different approach. Rather than try to migrate what I have, I should maybe rebuild using the tables and forms I have already converted and get some help from others.

The ultimate question is then: Can I post the process my MSAccess db does in hopes that someone can tell me how to build it in PHP and MySQL?

Msaccess->mysql Cpanel Migration
I developed a site in php/msaccess and am currently hosting it at home. i have recently purchased web hosting services w/ mysql/cpanel and would like to migrate the site form home to my knew host. my first question, is how do i move the data from an msaccess db to the cpanel mysql db?

Migrate Data From MSAccess To MySQL
I supposed this is a simple one, but here it is. How can i migrate date from MSAccess tables to MySQL tables?

Create Tabels In MySQL From MsAccess Frontend
I am using an access (2K) front and back end, but need to create/drop tables in MySQL for some data import/export.

I have the ODBC and connection and it works fine, I can connect via VBA code no problem, but some times I need to create new tables in MySQL, also via VBA/DAO code.

How Much Is MYSQL? Does It Run On Win 2000 Server?
How much is MYSQL?

Does it run on Win 2000 server?

Does it have reliable ODBC drivers?

Has anyone reliably used it with a Powerbuilder application?

I tried looking for a FAQ (didnt see one) and doing a keyword search.. a lot of hits - to many threads to digest.

MySQL On Windows 2000
I am migrating my web enabled Access dbs to MySQL.
I am using ASP on my development machine running Win 2000 professional with IIS and MySQL.When I attempt to run queries on my development machine, against the MySQL databases they run like a dog!! My Access databases flew compared to MySQL. I'm not expecting blistering performance, but it's taking minutes to access tables with under 20 rows.However, when I upload to my hosting company, everything is fine.
Can anyone give my ideas how I can tune my developmet machine speed up the queries?

Mysql Crash On Win 2000
I have latest mysql version 5.0.2 alpha installed on my windows 2000 machine. Now there is bug in the version, which causes the server to crash everytime I try to use any mysql client like phpmyadmin, mysql query browser. The only possible way of accessing the database for now is only through the command prompt and not theough any other client. This bug has already been reported to mysql. But it appears they have fixed in the cvs. But as of now there is no binary patch for windows. Anyone got any ideas on how do I tackle this one without having to change my version.

MySQL Script And SQL 2000
I have a MySQL script which contains scripts to create tables and insert data. I would like to re-create those tables and insert those data in Microsoft SQL 2000. What would be the best way to do that?

Can Run Two Versions Of MySQL In Windows 2000?
I have been running 4.0.13 for several weeks now and though I'd like to =
test 4.1.0. 4.0.13 is under c:MySQL. I downloaded 4.1.0 under c:4.1 =
AlphaMySQL. When I try to launch mysql it brings me to the old =
version, how do I access the new one without killing the old one? (I =
have also tried putting 4.1.0 on a totally different machine and linking =
to it also.)

MySQL + SQL Server 2000 Both Running On XP Pro?
I've had mysql on my machine plenty of times with no trouble currently i have SQL Server 2000 Trial running but never both at once. Unfortunately i have to have them both on at the moment.

So before i install and mess everything up, Does anyone here have this setup?

I basically want to get php/mySQL/MSSQL running with IIS

App In Server 2000 Connect To MySQL - MAC
I am absolutely new to MySQL. I came across the need to look at MySQL from an application I was developing using REALbasic.

Here is the system:

An MS 2000 Server with an application that needs to connect to a SQL database.
A MAC OSX 10.4.7 PPC G4 running MySQL mysql-max-5.0.24a-osx10.4-powerpc.pkg.

What I can do:

I can connect to the MySQL table using the data app in REALbasic on the MAC and make changes etc.

What I need to do:

I need to create a DSN to allow the App on the 2000 server to connect to the MySQL server table on the MAC to make changes etc.

How can I accomplish this?

Communication Between MySQL And SQL Server 2000.
Is there an established (third party software for instance) means to allow communication between MySQL and SQL Server?

For instance, SQL Server has a replication service that allows a database to be kept in sync with another one (SQL Server to SQL Server). Does anyone know if such a thing exists for SQL Server to MySQL and MySQL to SQL Server?

#2000 - Unknown MySQL Error
I'm using my SQL via one of SBC yahoo's packaged deals for web access.

Everything had been going along smoothly...until today.

Under PHPMYADMIN...privileges I started seeing the following msg:

Warning: Your privilege table structure seem to be older than
this MySQL version!
Please run the script mysql_fix_privilege_tables that should be included in your MySQL server distribution to solve this problem!

Whatever SQL statement I try to run (a select, alter, update etc etc) I get the #2000 - Unknown MySQL error msg. So I can't run the script mentioned in the error msg since it won't get past the very 1st alter statement.

I'm not sure what went wrong but I can't even "reload mysql" - I just keep getting the "Uknown" msg.

With the exception of the "mysql" database, all of my other databases show a dash sign instead of the number of tables (in the PhpMyAdmin drop down. I can't even click on one of them without getting the "uknown" msg.

MySQL On Windows 2000 Server
I want to install MySQL on to a Windows 2000 Server, I also want to remotely manage it using MySQL administrator, so connecting to the server using its IP Adderss, On windows workstations if you try and connect to the MySQL database from a remote mechine it does not allow you to do it (I have disabled all firewall's etc.).
Do you have to install a server version and not LOCAL version of the MySQL server?

MSaccess
How can I convert a MSaccess file to MySQL?
Is there a programm or script for this? Or is there a PHP script that can extract data from an MSaccess file when its online?

"external" MySQL Server MsAccess Connection
I do have rented server space (webhosting) with 3 MySQL databases and a standard URL (e.g. www.1234567.ch).

Is it possible to connect to this "external" server with MsAccess?
If yes how?

Exporting Binary Data From Access 2000 Into MySQL 4.1.5 Gamma
I'm trying to export a pictures table, my mySQL database table already
exists so I have linked both tables in Access and I tried to run a
simple append query in Access to export the data but I either :

- lose the connection to mySQL
- have packets that exceed max_allow_packet

I have tried different things to set max_allow_packet to a higher
value which seems to be 1M by default. I want it to be 1G like setting
the value at run-time from the prompt but it seems that no matter what
I tried, I either get the syntax wrong or the command is simply
ignored.

I have also added in my.cnf, the following lines :

MSAccess And ODBC Problem Linking Tables
my environment is:
- windows2000 pro.
- Access2000
- mysql 4.1
- MySQL ODBC 3.5.1

When i try to link tables that exist on the mysql db to the access project,
through odbc, the dialog that asks me which tables to link does not appear.
The odbc window vanishes after i select the odbc driver.

My.cnf Is Not Available Under Windows 2000
according to the manual,

There are two option files with the same function:
`C:my.cnf', and the `my.ini' file in the Windows directory.

Is it sufficient with only one of the files ?

I have only my.ini

For which purpose is my.cnf , please?

My.cnf Is Not Available Under Windows 2000
There are two option files with the same function:
`C:my.cnf', and the `my.ini' file in the Windows directory.

Is it sufficient with only one of the files ?

I have only my.ini

For which purpose is my.cnf.

SQL 7 To MSDE 2000
I would like to upgrade a machine from SQL 7 to MSDE 2000. I would like to keep the existing database from Altiris Deployment solutions intact. Is this upgrade possible?

SQL Server 2000
I'm trying to do an export from an SQL Server 2000 Database to and ODBC driver pointed to a mySQL Server Database. The export works if there is at least one record in the mySQL table. If the mySQL table is empty it gives an error that looks like this:

Insert error, column 1 ('field1', DBTYPE_STR), status 6: Data overflow.

The strange part is that the export works perfectly fine as long as there is one record in the mySQL table, if there are no records in the table, I get the error above

SQLServer 2000 Conversion
I have a web app that uses SQLServer 2000. I am switching to MySQL 4.

1.1. I have re-created all the tables but I'm running into 2 problems.

1. In SQLServer I can create a date field and as the default value I

can use a macro/function to have it set the default. I have not seen

an equivalent in MySQL. After doing some research I have seen only

two possible solutions:

a) Use timestamp. This is not suitable because it has a tendency to

auto update and it's more trouble than it's worth to use a field that

does this when you know it should never really change.

b) Use datetime and just insert the time in. This option will
require

me to mess in the web app and go through and change SQL which I

really would rather not have to do but will as a very last resort. I

prefer the database to handle this sort of thing.

So am I missing something? Or does MySQL simply not support using

macros or functions as default values like SQLServer does?

2. Second problem may not be MySQL. I use Naicat and I created a

varchar field with a length of 2. When I saved the table it was

converted to a char of length 2. This was not cool because the two

are not equivalent. I don't care how much faster char is. So my

question is, is there something in MySQL that doesn't allow varchars

of length < 4 or is this a Navcat thing?

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
=-

Stormblade (Shaolin Code Warrior)

Software Developer (15+ Years Programming exp.)

Access 2000 As Frontend
I know this is an 'old chestnut', but I have been trying to add an ODBC connector for MySQL frpm mysql.com. It downloaded and installed correctly, but when I came to configure it, the dialogue looked different from the picture on mysql.com help page. I figured it had just changed and made a best guess of what went in which text box.

Thing is, whenever I try to test the connection, I get an error message;

[MySQL][ODBC 3.51 Driver]Access denied for user: 'dbusername@my fixed ip address' (Using password:YES)

I am assuming it got through to the MySQL database and was denied access because it had my fixed ip address attached, rather than say, localhost? Is it a config problem or have I missed something?

Raw Partition With InnoDB On Windows 2000
I have MySQL/InnoDB on Windows 2000 and i want to create a RAW
PARTITION to use InnoDB tablespace...

In Linux the configurarion is:

innodb_data_file_path = /dev/hda1:32Gnewraw
innodb_data_home_dir =

and in Windows 2000 ?? Code:

Raw Partition With InnoDB On Windows 2000
I have MySQL/InnoDB on Windows 2000 and i want to create a RAW PARTITION to use InnoDB tablespace... In Linux the configurarion is:

innodb_data_file_path = /dev/hda1:32Gnewraw
innodb_data_home_dir =

and in Windows 2000,

5.0 Security On Windows 2000 Best Practices
Does anyone know of a set of standards for securing MYsql 5.0 on Windows
2000? I already saw the document on mysql.com's website at
http://dev.mysql.com/tech-resources...ql_windows.html,
but something that is missing is precisely what are the minimum
permissions needed for the server? Specifically, which directories need
which access rights?

Probs With MSSQL Server 2000
Well i have installed MSSQL server 2000 on my PC(OS:XP Prof). And the server does run as well as the agent. I know how to use the registration wizard of SQL server 2000, cause untill i sucessfully complete the registration process i woun't be able to create a database OR use the query analyser.

I know how to access the registration wizard, but i at last it gives me an error saying"access not granted, unsucessfull registration" **** like that.
:confused:

And i am using the same PC as the server as well as client.

SQL Server 2000 To MySQL Server
I'm trying to do an export from an SQL Server 2000 Database to and ODBC driver pointed to a mySQL Server Database. The export works if there is at least one record in the mySQL table. If the mySQL table is empty it gives an error that looks like this:

Insert error, column 1 ('field1', DBTYPE_STR), status 6: Data overflow.

The strange part is that the export works perfectly fine as long as there is one record in the mySQL table, if there are no records in the table, I get the error above.

Regular Text File How To Sql 2000 Table Code
i have a text file as follow, line with ¡°|¡±and {LF},

8|-000000186075919.|+000000000387820.|2008-03-31|20010423|
9|-000000000003919.|-000000000123620.|2008-03-31|20010123|
8|-000000018623419.|+000000000381230.|2008-05-30|20010423|

i want to sign char(1)£¬year decimal(18,3) , month decimal(18,3), trandate
smalldatetime£¬update smalldatetime£¬after to sql table is as follow,

sign year month trandate update
8 -186075919.000 387820.000 3/31/2008 4/23/2001
9 -3919.000 -123620.000 3/31/2008 1/1/2001
8 -18623419.000 387820.000 5/30/2008 4/23/2001

Open And Close Time 2000 Kills The Connection
I am moving some data from a text file into mysql and my code in c# using ODBC fails.

Actually I created a loop to test mysql and realized that mysql goes banans when

for(int i=0; i < 5000; i++) {
connection.Open();
connection.Close();
}

This code is for illustration purposes ONLY but it should work!? When I reache around 2000 the connection.Open() loses the connection to localhost and terminates the program! After a minute I can get access to mysql again? Inserting a delay of 100ms seems to keep things going.

Connecting To MySQL With PHP
Originally Posted by tluther
I am new to MySQL & PHP. I am following samples in book by Kevin Yank on how to connect to MySQL with PHP. I have installed Apache, MySQL 5.0 & PHP 5.2 and am attempting to run as local host. When following the lessions in the book everything was working ok until I tried to connect to MySQL. In the PHP script I am using localhost as the address, root as username and the same password I use when I open MySQL through the command line clinet. I have been able to create and modify a sample database but just can't get PHP to connect. Any suggestions would be appreciated. I will be glad to email you the script I am using to try to connect if you need it.

This is the code I am using:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Our List of Jokes</title>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
</head>
<body>
<?php

// Connect to the database server
$dbcnx = @mysql_connect('localhost', 'root', 'mypasswd');
if (!$dbcnx) {
exit('Unable to connect to the ' .
'database server at this time.');
}

// Select the jokes database
if (!@mysql_select_db('ijdb')) {
exit('Unable to locate the joke ' .
'database at this time.');
}

?>
Here are all the jokes in our database/p>
<blockquote>
<?php

// Request the text of all the jokes
$result = @mysql_query('SELECT joketext FROM joke');
if (!$result) {
exit('Error performing query: ' . mysql_error() . '');
}

// Display the text of each joke in a paragraph
while ($row = mysql_fetch_array($result)) {
echo '' . $row['joketext'] . ''
}

?>
</blockquote>
</body>
</html>

Connecting Php And Mysql
how can i connect mysql database to php so that we can prepare it to upload online?

Connecting DMW With PHP/MySQL !!!
When attempting to test the connection to a MySQL database within a PHP site in Dreamweaver, the following error occurs:

An unidentified error has occurred. I have installed Mysql 4.1 and php 5 and run dreamweaver MX with an apache web server. If i create a simple php info() page it pops up fine so the server is fine and so must php. I can log into my Mysql database and select tables etc, so that's fine. But i just can't get Dreamweaver to connect to the database. I get a 'unidentified error' message something to do with the selectDatabase.js.

Connecting To Mysql
I am not able to connect to the mysql DB if I am not the root user. I
have already found identified an issue:

* mysql.sock is NOT located in /tmp

So, to get around it I created a sym link to the actual location
(/var/lib/mysql/mysql.sock). This file, and the sym link, are both
owned by root but they have full permission for all user. But the
parent directories are ONLY READ and EXECUTABLE for non root users.

If I change the permissions on:

* /var
* /var/lib
* /var/lib/mysql

I am able to connect to mysql (from both command line and my PHP
script). But I really don't want to leave it so open.

Any ideas how to get around this? I'm thinking the best solution would
be to make mysql create the .sock file in /tmp so that I don't have to
create the sym link. But I an open for any / all suggestions.

Connecting To A MySQL DB With .NET
I was looking to create a VS.NET program that can connect to a MySQL database on a Linux server. I see that MySQL has some projects that integrate .NET with MySQL but my question is are those projects restricted to using MySQL on a Windows OS or can my program, on a Windows OS, connect remotely to MySQL, on a Linux OS?

Connecting MySql To VBA
I am asked at work to connect MySql database to excel through VBA (macros)..how do i do this, does anyone knows a tutorial or somehitng like that, I have prety much created a code, but it does not through me any data back..

Connecting To MySQL
I'm running mysql on windows and I would like to connect to the database by typing mysql (only) and not mysql -uroot -proot. This works just fine from my linux and i cant figure out why it wont work on my windows box. I get the following error:

C:>mysql
ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO)

Do I have to modify my.ini?

Also, I would like to grant the user phpuser access to a particular database. How can i do this?

Connecting To MySql DB From Different PC
I just made a test with mySql on Windows NT. I created a table with different fields, and I made a Java program to connect with JDBC to that DB. It works if I connect from the same PC where mySql DB is. I used this Java sentence to connect:

.....DriverManager.getConnection( "jdbc:mysql://localhost/......

And it made the query I want.

But I would like that a PC in Internet could connect to that DB. I suppose I must put the IP of the mySql server instead of "localhost" on that sentence, but I got this error:

java.sql.SQLException: Invalid authorization specification: A
cess denied for user: 'a@cable87a004.usuarios.retecal.es' (Using password: YES)

I think I should change something on Winmysqladmin at bind-address (my.ini Setup) ?...I have tried to uncomment bind-address and write the IP of the mySql server, but it doesnt work...

Connecting To Mysql
when I try to connect i get the following error, you can see the website at amoudonline.net.
I would very much appreciate any help.

Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/fhlinux182/g/goyaonline.org.uk/user/htdocs/news_in_somali.php on line 4

Connecting PHP With MySQL
I wanna connect a php document with mySql. So i write the following code...:
$link = mysql_connect("127.0.0.1:3306", "HostName", "Password");
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);

I have tried this instead of 127.0.0.1:3306 with localhost but the result i get is:

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in D:ServerApache2htdocsPHPFILEsmyfirst.php on line 51

Could not connect: Client does not support authentication protocol requested by server; consider upgrading MySQL client

I have MySQL 4.1 and i do not know what to do!
Please help me i am in great need thank u. I would appreciate it if u mailed me also.

Connecting To MYSQL From VC++ 6
I'm looking for some assistance in using Embedded SQL in C using VC++ 6.0 to
connect to MYSQL in Windows XP.

This is new to me, but it is my understanding that I need to use a
precompiler. I'm confused about where to get the precompiler. Can someone
explain in simple straight forward terms what I need in order to do this?
I've been Googling for hours with no real answers.

Connecting To MySQL
I have a php script trying to connect to mySQL server. i am unable to connect. I think my issue is the login details to mySQL - my php code is fine.I've done my installations recently and I've never needed to use logins to access mysql. are there any?
i think i read somewhere that the password for the root login in mySQL is blank so I've left it like that in my script.

$conn = mysql_connect("localhost", "root", "")
or die(mysql_error());
mysql_select_db(mysql, $conn) or die(mysql_error());

Connecting To MySQL
so I have used mySQL once and it was a long time ago. I am more of an Oracle person We had some sort of front end tool. I am now faced with developing php pages and they are using a mySQL database. I am connecting remotely to a linux server which has the mySQL database. So once I am connected to the server, how do I get to the database? With Oracle I would launch SQLPlus, connect to the database, and run my SQL statements. Is there something similar with mySQL?