MYSQL :: SQLServer 2000 Conversion

Access/jet To SQLServer Or MySQL
We have developed an Access/Jet database (2000, XP & 2003 versions) that has
been used by clients all around the world for several years and is extremely
robust with 55 tables, 172 hard stored queries (plus about the same in VBA
SQL code), 60 forms and about 18,000 lines of code. The biggest advantage
with Access is that it doesn't cost the client anything for if they don't
have Access already then we provide the Runtime version which makes our
application extremely cost effective for the client.

The most concurrent users recorded has been 23 without any problems and in 5
years we have only ever had 1 corruption when a server fell over.

We now need to expand the concurrent user abilities with the most being say
around 175 at the worst possible time with the objective being to allow
employees in an organisation to enter a record (for eg. logging an IT Help
Desk Call themselves rather then contacting the Help Desk and getting them
to log the call). We know that which ever way we go there will be a massive
learning curve and there WILL be an impact to the cost to the client as only
some clients have MS SQL Server.

Strategically we POSSIBLY may down the track be moving away from Access and
to ASP.NET as the front end (or both) but at the moment we believe we have 2
options - either MS SQL Server or MySQL for the backend. I must stress that
the most important factors are cost to the client, ease of self
installation, size of learning curve for us and the ease of future
enhancement development and support to the client.

Read MS SQLServer Data From MYSQL
what is the interface in MYSQL that I can use to read MS SQLServer data ?
Either programing in the code or tools are fine.

Connect To Sqlserver Directly From Unix Prompt
How can I connect directly to sqlserver from a Unix Prompt? I am using DataDirect in the ODBC connectivity. Is there any way whether I can connect to SQLServer from the prompt,just a select stmt will do.

For eg: if I use select * from table|sqlplus -s usernmae/password@hostname

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

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.

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?

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?

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:

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.)

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?

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?

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.

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.

Connecting To Mysql From MSAccess 2000
I've set up a ODBC DSN to connect to Mysql. This DSN works fine with MS =
Excel. However, it returned the following error when I tried to link =
some Mysql tables from Access 2000:

ODBC--call failed.
[MySQL][ODBC 3.51 Driver][mysql-4.0.4-beta-max-nt]Access denied for =
user: '@<my ip address here>' to database 'tradingdata' (#1044).

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?

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.

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 :

Hex/Dec Conversion
Are there any built in functions in MySQL for converting between hexadecimal and decimal? I've got a CHAR(1) column with hex values, and I can change them just fine with PHP's hexdec() and dechex() functions, but I'm wondering if there's anything similar already built-in to MySQL.

i.e. Can you do something like this: "SELECT HEXDEC(hex_column) FROM table"?

Now() Conversion
Can anyone help me with now() ? I used it to write the submisson time in mysql db, and need to convert it back. I tried explode in php but I did not have a marker to use for arguments.

Access Conversion
we are looking to convert our pages from Access to MYSQL (required for our host) and also our ASP pages. I am pretty familiar with Access and ASP but not MYSQL. What is involved in converting the database and then will it be necessary to change the ASP page connections to the database. the connections were made using a DSN-less connection. Here is an example:
_____________________________________________________
'Create an ADO connection object
Set adoCon = Server.CreateObject("ADODB.Connection")

'Set an active connection to the Connection object using a DSN-less connection
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("database.mdb")

'Create an ADO recordset object
Set rsRec = Server.CreateObject("ADODB.Recordset")
_____________________________________________________

Conversion Of Time
I've a column in a table where are stored the amount of total hours of some jobs, for example:

totalHour = 32:30:00

I need to convert this time from 60" to 100", for examples:

totalHour = 32.50

Is there any formula or other in mysql to do this?

Date Conversion
I have a datefield in my table which is of type varchar(30). The values for this field is something like this:
Fri Jan 12 01:30:45 EST 2007
I want to convert this date value to the format of yyyymmdd ie 20070112.
Is there any function available for this? Or please let me know if there is any other solution for this.

Mysql Conversion
I have a user who is using Chinese characters in UTF-8. He came from a 4.0.27 MySQL version to 4.1.19 and now they do not work. Instead the following error occurs:

Warning: mb_strpos(): Unknown encoding or conversion error. in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/string.lib.php on line 112

He is using Cpanel control panel which does not necessarily support 4.0.27 very well anymore.

Conversion Between Charsets
Does anyone have an idea on how to solve the following problem:
I have data stored in my Mysql database with encoding latin1.
I need to produce an outputfile with cp850 encoding. Therefore I thought that I could use
SELECT CONVERT(_latin1'MÃœLLER' using cp850) AS name
but I do not have the impression that this works. How do I tell? In latin1 the "Ãœ" is represented by hexadecimal code DC; in cp850 "Ãœ" is represented by "9A". By saving the query result to a file and looking at the hexadecimal code, the conversion did not change DC into 9A;

Varchar Conversion
Is there a way to convert a varchar field containing date data (Sep/9/2005) to a differet field of date format?

Database Conversion
Currently, I am on an InvisionFree Forum and trying to move it off to a phpNuke forum. I have received my data from InvisionFree and have been trying very hard to use a hack to get the data crossed over to phpBB, then to phpNuke. I just cannot seem to do as I have followed the directions to the "T". I get nowhere. Where can I find someone to help me out with my dilemma? Possibly, even crossing the data from one format to another.
I really need to get this up and running very, very quickly because my Discussion Forum is financial stock related and I currently have over 550 members waiting for the new forum to open up.

Date Conversion
I've got three Oracle generated file fulls of 'Insert' statements. I'm using them to load my MySQL database and all is going well until I need to load a DATE column.

Oracles default DATE format is MM/DD/YYYY, while it appears that MySQL DATE format is YYYY/DD/MM.

So, how do I convert the Oracle format into MySQL format? I've tried reading the 4.1 MySQL online manual, but I don't completely understand how to go about it.

Date Conversion
ok i have a comma delimited text file
and im trying to use LOAD DATA INFILE and i got it all working except the dates, there is a birthdate and date paid field
in the comma delimted file it shows the dates in this format
mm/dd/yyyy and i need it to be in the mysql date format which is
yyyy/mm/dd
is there any way to convert these date fields using the LOAD DATA INFILE with FIELDS ESCAPED BY or something of that matter?

Conversion Of Access To MySQL
ok i know it can be done and i know there are programs out there but does anyone know of any FREE ones? i really need just 1 database converted

Unit Conversion With MySQL
imaging you have this database with these tables:

table A

| id | unit | magnitude |
-----------------------------
| 1 | meter | 1 |
| 2 | millimeter | -3 |
| 3 | centimeter | -2 |

table B

| id | name | initial value | initial value unit id |
---------------------------------------------------------
| 1 | test a | 300 | 1 |
| 2 | test b | 10 | 3 |

table C

| id | id table A | value | value unit id |
----------------------------------------------
| 1 | 1 | -20 | 1 |
| 2 | 1 | -30 | 3 |
| 3 | 1 | +40 | 2 |

Now, if I want to get an update of the actual status of id 1 from
table B with adjustments from table C, what is the best way to do so?

The problem is the fact that you have changing units. One time its
meter, another time its centimeter.

I could "translate" all the values in the table to one unit to make
calculations a lot easier, but is there a more elegant way?

Spreadsheet To Mysql Conversion
I need to convert an Excel spreadsheet to a MySQL dbf. I'm on OS X. I've found several Windows applications that do this but nothing for Mac. The only app that seems to come close is Navicat, but it needs to establish a remote connection to the existing database, which my server doesn't allow. What I need is a utility that will convert the spreadsheet locally so that I can then upload it via the server's phpMyAdmin control panel (which they've modified to prevent the uploading and converting of spreadsheet files on its own). Does anyone have any ideas? I'm spent hours and hours researching this, but so far, no cigar.

Date Code Conversion
I have a data set that I inherited that was exported into a text CSV file, apparently from a MYSQL database. The file contains date code values that I would like to convert into date strings.

What is the algorithm that MYSQL uses to create the date code? ie, how can I convert the value 1086066000 into "Jan 28, 2004"? I'd prefer to do it in something like Matlab that I'm fluent in, rather than MYSQL where I'd be starting from total zero.

OLE Automation Date Conversion
I have a database with many datetime columns that are stored as
floating point numbers that represent the number of days since Jan 01,
1900 - or I guess it's really since Jan 00, 1900. This was done
because the datetime field in MySQL had a precision of only 1 second
and we needed fractional seconds - I'm not sure if this constraint is
still true.

Currently we don't have time to write any frontend applications to
query the database so I want to make it easier for people to filter
the data without having to convert to/from a number.

What I'm looking for is some type of MySQL conversion function to do
the following:

SELECT * FROM mytable WHERE timestamp ConvertToNumber("2007/5/25
1:23 PM")

SELECT ConvertToDateTime(timestamp), someothercolumn, FROM mytable

The only related methods I could find where CAST() and CONVERT() but I
couldn't find any way to use them to produce the results I wanted.

Conversion From Postgres To Mysql??
I have a dump of postgres data that I need to convert to MySQL. Does anyone know of any conversion tools or technical articles to facilitate this process?

Foreign Character Conversion
Server Info

Apache 2.0.54
MYSQL 4.1.11
PHP 4.3.10-16
Linux Debian-4sarge

Working remotely using Windows XP, Locally using similar spec but with Windows XP

My problem is this. I am in the process of upgrading a website which uses a database, I am creating a customized database using information provided from an external database. On this database there are records which contain information in regards to destinations around the world for example:

Country=Foo,Region=Foo etc...

The information taken from the database will be used to form web links as well as been used within the copy of the web page for example: Code: