MYSQL :: Probs With MSSQL Server 2000

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

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.

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 + 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?

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?

Connection Probs
Im havin problems connecting to my mySql database from home, I use win XP. Connecting from my web server works fine?

When I try to connect from home I get this error "Warning: Can't connect to MySQL server on 'sqldb4.webconnect.com.au' (10060) "

Upgrade Probs To 5.0.18 - Queries Fail
I'm hoping someone on this forum can help me. I use hibernate with java
to access mysql. We are trying to upgrade from 4.1.15 non-inndb, to
5.0.18 with innodb. Hibernate makes a 'create tables' script. The
script installs, but the queries that hibernate creates now fails.
These same queries worked fine with 4.1 .

Since this is a hard problem to solve on a forum, if any kind fellow
would like to, you could install the db from this zip:

MsSQL &
I've been using MsSQL for some time now to log users that are logging into our radius system.

what i'm having trouble with is the TIME feild.
i have it set to the standard DateTime feild in SQL,
but when i pull up the info i get see this:

28/07/2003 00:01 AM 42666 bps 30.4min
28/07/2003 24:13 PM 46666 bps Logon
28/07/2003 39:57 PM 40000 bps 75.8min
28/07/2003 43:30 PM 48000 bps Logon
28/07/2003 02:10 PM 42666 bps 18.6min
28/07/2003 45:59 PM 46666 bps Logon

why would it give me times like 45:59 PM ?

i've never seen this before, and was wondering if any one had any idea's as to why?

MSSQL To MySQL
I have this query:

Uninstall MSSQL?
I've had a few problems with my first attempt at installing MySQL - I can't seem to get the PC to connect with MySQL. I did notice that an SQL Server was running in the SQL Server Service Manager panel. It's a NetSDK - MSSQL Server thing.

Do I need to unistall that before MySQL will work properly?

Replication From MSSQL
Has anyone ever gotten transactional replication to work from MSSQL to
MySQL? I have done very rudimentary tables with 1 or 2 columns but I have
run into various errors at startup about invalid cursor state. Any insight
you may have is greatly welcome.

MySQL And MSSql 7
Can MySQL read a MS Sql 7 database?

MySQL To MSSQL
I currently have a MySQL database running on one of my web sites. Is it possible to export the SQL and execute it so that it will generate table structures on an MS SQL database?On another note, I used PHP & MySQL for Dummies, just wondering if there was a ASP & MSSQL equivalent?

MySQL Vs MSSQL
We have a PHP business system that we provide to our customers. The database is MySQL 5. We have a new potential customer that is hell bent on keeping everything within their existing MSSQL database. I'm wondering if there are substantial differences in query format between mysql and mssql. There are no stored procedures, however we do take advantage of mysql 5's sub queries.

MySQL Better Than MSSQL
What are some of the technical advantages that MySQL has over MSSQL? Other than source being available and the product being free?

MSSQL Emulate
What we'd like to do is use MySQL for Goldmine (FrontRange Solutions). Is there a way to emulate MSSQL on the mySQL box without using WINE or VMWARE. We're looking for a pure linux solution or at least a place to start looking.

Mssql Codes
how to convert store procedure from mssql codes like tis to mysql store procedures. Urgent thanks

Create PROC spVerifyLogin --verify student login
(@StudentID varCHAR(10),@StudentPwd varChar(15))
AS
if not exists (select StudID from student where StudID=@StudentID)
Return -200 --no student is detected
if exists(Select StudID from Student where StudID=@StudentID and StudPwd=@StudentPwd)
return 0

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?

From MSSQL To MySQL Or PostgreSQL
I have been using MSSQL for a few years. Recently I am looking seriously for some free database platform. Both MySQL and PostgreSQL have a large community, anywhere I can find the comparison?

Compare MySql And MsSql
I am trying to switch from Microsoft MSSQL to the free mySql. But I am going to explain to customer the impact.

I want to know the following stuff.
1) What MsSQL can do but MySql cannot do?
2) What is the number of connections supported by each product.
3) Where (URL) can I find more information about the above issue?

Mysql To Mssql Converter
I need to export a mysql database to a mssql one. Can anyone recommend any good freeware to do this. I tried DTS via mssql but there are datatype problems and primary key data is not being transfered.

Importing Data From MSSQL
I currently have a database in MSSQL and am trying to import several tables into MySQL. On the MySQL Console Manager, there is a greyed out Import selection that will not allow me to use. I dont get it.

Then my next consideration would be a query to create the tables and insert it into the MySQL database.

Import Data From MSSQL
I have two systems, one using MSSQL and one using MySQL. On a daily basis, I need to import information from tables on the MSSQL database to a table on the MySQL database.
What's the easiest way to do this?

MSSQL -> MYSQL Method
I have an sql query that worked on MS SQL 2000.. I need to know what the mysql version needs to look like.

the MS sql query is as such:

Select CARTS.CARTNUMBER, CARTS.UNITPRICE, QUANTITY = (Select SUM(numitems) from selitems where SELITEMS.CARTNUMBER = CARTS.CARTNUMBER)

basicly thats an example of what im talking about.. It works in MS SQL but in mysql the same query gives me the error: "Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'Select SUM(numitems) from selitems where SELITEMS.CARTNUMBER"

Does mysql support this using a different method?

MySQL And MSSQL Transplant
I am quite proficient with MySQL databases but at my job they use MSSQL. Now, I know most SQL databases have somewhat the same syntax, but if I create a database in MySQL and dump it can I run import it to a MSSQL db? Mainly because I've noticed that the maximum value of a MSSQL int == 4 while in MySQL this is 11.

MYSQL / MSSQL Behaviours
I neet some Help for MySQL MSSQL.
There is a parameter in the "WHERE" part called "in Between".

for example:
... WHERE in Between 1 to 3

MY SQL prints all Values from 1 to 2 - exklusive the 3
MS SQL prints all Values from 1 to 3 - inklusive the 3

Is there a "between" parameter for MYSQL that makes the Output like MS SQL?

I know it is possible to use the following command:
">=1 AND <= 3" but I need the Result for "in Between".

Migrated MSSQL To MySQL
I have 2 applications that use MSSQL databases. One application is written in java, and the other one VB 6. Now... I migrated those same databases to mySQL, and made necessery changes in my applications to use mySQL. Java using J Connector and VB application using ODBC. More or less just changed the connection string. Following happened... Java application now have much better performance and works grate, BUT VB application works much slower. Both applications use some of the same databases so I guess it is not the performance of the mySQL that is the issue here but rather the connector.

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?

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?

Migrating Form MSSQL To MySQL
I am migrating from MSSQL to MySQL and I'm having trouble converting the SQL strings.
I got thins:
CODE '' strSQL = "SELECT top 1" & strDbTable & "Author.Username, " & strDbTable & "Author.Author_ID, " & strDbTable & "Thread.Topic_ID, " & strDbTable & "Thread.Thread_ID, " & strDbTable & "Thread.Message_date "
'' strSQL = strSQL & "FROM " & strDbTable & "Author, " & strDbTable & "Thread "
'' strSQL = strSQL & "WHERE " & strDbTable & "Author.Author_ID = " & strDbTable & "Thread.Author_ID AND " & strDbTable & "Thread.Topic_ID"' IN "
'' strSQL = strSQL & " (SELECT top 1" & strDbTable & "Topic.Topic_ID "
'' strSQL = strSQL & " FROM " & strDbTable & "Topic "
'' strSQL = strSQL & " WHERE " & strDbTable & "Topic.Forum_ID = " & intForumID & " "
'' strSQL = strSQL & " ORDER BY " & strDbTable & "Topic.Last_entry_date DESC) "
'' strSQL = strSQL & "ORDER BY " & strDbTable & "Thread.Message_date DESC;"

MSSQL To Mysql COUNT() Possible Index
Well we are week 3 in our conversion to mysql from mssql. This one we had to rewrite the mssql version to mysql. We are having issues with a few count statments. Code:

An Equivalent For @@ERROR Function In MSSQL
Has MySql someting like @@error in MSSQL? if no, how i can find dynamically that error occured and it's number?

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?

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

Link ODBC Or MSSQL Table With MySQL
I've noticed that it is (somewhat) possible to link MySQL or ODBC schemas into MSSQL Server but what I would like to do is link a MSSQL Server table to MySQL so that I can do cross-database joins. Having trouble finding this functionality, however. Does anyone know if there is a way or a tool out there to make a way?