I'm trying to migrate from MS-SQL Server on Win2K to MySQL on SuSE 9.0 Pro. I use an ERP program named Unisoft Atlantis (written in Delphi). It natively supports MSSQL, Oracle, DB2 and Interbase. It also supports BDE drivers. I have imported the whole the database from MSSQL to MySQL, I have set the user rigths on the MySQL server, I have installed the ODBC driver on my WinXP Pro workstation. The ODBC driver can test the connection between the wks and the server, and it says its OK. Atlantis has a utility to configure the client. It allows to choose the DB engine to use, the server, auth details etc. The utility can also test the connection to the server. It displays the version of the ODBC (which means that it USES the driver) and the message "Connection OK". No errors! When I start the main program (Atlantis client), it opens its main window, sends something to the net (connecting or authenticating, I guess) and freezes. Under normal conditions (MSSQL) it pops up a login window and after logging in it shows its icons, menus, buttons etc. According to the diagnostics of the ODBC driver and of the program itself, all seem to work ok. What am I doing wrong?

P.S. I'm a newbie

I think there is an option in odbc to turn on sql logging - this creates a logfile with timestamps, soemthing like "C:\sql.log" (not sure of the name of the top of my head) Maybe you can use this to see how far the connection is getting.

Are you sure that you have assigned your user all of the relevant permissions on that database, SELECT, INSERT, UPDATE etc?

Thanks david_ross, I tried sql logging and I think I found something.
I read the sql.log file. It is huge and it has the format shown below.
All the lines end with the statement "return code 0 (SQL_SUCCESS)" except 2 or 3 wich end with "return code 1 (SQL_SUCCESS_WITH_INFO)"

Here are some lines from the log file. This is one of the statements with non 0 error code.


Goserver c4c-68c ENTER SQLFetch
HSTMT 01382258

Goserver c4c-68c EXIT SQLFetch with return code 1 (SQL_SUCCESS_WITH_INFO)
HSTMT 01382258

DIAG [01004] [MySQL][ODBC 3.51 Driver][mysqld-4.0.15-Max]String data, right truncated (501)

Goserver c4c-68c ENTER SQLFetch
HSTMT 01382258

Goserver c4c-68c EXIT SQLFetch with return code 100 (SQL_NO_DATA_FOUND)
HSTMT 01382258


I think this is the problem but I don't know what it means. Maybe the data wasn't imported correctly? I tried many ways to export from MSSQL and import to MySQL. There are many converters from the official MySQL site, some take the db directly from MS and import it directly to My. Others take the db from MS and store it to an sql file (plain text, sql commands) or to
ms-access file etc. I tried them all. Any ideas?

That isn't an error I'm familair with but after a bit of googling I found this:
http://www.easysoft.com/products/999...6&product=2002

You may want to try the "Regional settings" fix:

I made an experiment and the result is a little strange.
The program is currently using an MSSQL database without ODBC (it has native support for MSSQL). I set it up to connect to the MSSQL server through ODBC and got the same result.
All the diagnostics were ok but the client never connected to the server. What's that supposed to mean? Maybe Atlantis can't use ODBC?

Have you contacted the software developers to ask them if it can use ODBC?

Do htey have a website or something?