We help IT Professionals succeed at work.

database conversion (sql to mdb)

1,979 Views
Last Modified: 2008-04-27
Hello,

I have given a database called xy.db. When I look at it using the editor, I see a copyright notice from Watcom.
With the "DBTool MYsql manager" from www.dbtool.de, I tried to convert the file into an MDB.
The dialog asks me for a profile name, a servername, a port, a database name, a user name, and a password, to manage the remote server.
Well, I have no idea of all that. I have given the file xy.db. What to do ? I have access to the PC where xy.db comes from, but I have no documentation, and the company which created xy.db refuses to help.
I just want to convert my own data.

desperately yours, Sonja,

PS: the requirements for the DBtool are: Microsoft ActiveX Data Objects 2.6, Microsoft Jet 4.0. Where do I get these things from, or how do I see whether I have them already ?
Comment
Watch Question

Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Hello Mish33,

thank you for your answer ! Would you be so kind to tell me where I can get the sybase sql anywhere driver ?

best regards, Sonja
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
thank you. Now I need time to test it.

Author

Commented:
Hello Mish33,

> Use ODBC to open that file with "Sybase SQL Anywhere" driver.
now I have installed SQLAnywhere. Then what is next?:

* Start
PROGRAMS/
SQLAnywhere/
AdaptiveServerAnywhere/
ODBC-Administrator ?

*After this, I get 7 tabs. What should I do next ?


OR should I use "interactive SQL" ? The result I get is:
---------------------------------
[Sybase][ODBC Driver][Adaptive Server Anywhere]Integrated logins are not permitted

      Error code=-205
      SQL state=28000

Connection parameters:

      User=
      Password=***  <----I did not enter any password !
      DBF=C:\path\xy.db
-----------------------------------

By the way, now I see some files *.DBF, from Firefox, from this application. Maybe useful to know.


Sonja
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Hello all,

I guess the easiest way for me is by using MSAccess and import the database xy.db into an mdb. I select the pulldown menu MSAccess/Data/ExternalData/Import. Then I can select the odbc data type. After, I select xy.db.dsn (which I got from playing around wit SQLAnywhere). Then I must either select USE INTEGRATED LOGIN, OR I have to give the ID and the password.
When I use integrated login, then MSAccess says: (Translated):
-------
ODBC call failed.

sybase/odbc driver/adaptive server anywhere/Database server not found (#-100)
Microsoft/odbc driver manager/error at SQLSetConnectAttr call for driver (#-40)
-------

If I select empty user ID and PW, then it fails, as well.

So is the User ID & PW what causes the problem, or is it something else ? How to solve it ?

Sonja
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.