Database connection error in DCS

For bug reports and fixes, installation issues, and new ideas for technical features.

Moderator: SEOW Developers

Post Reply
Ala13_Mdie
Posts: 33
Joined: Wed 31 Jan 2007 2:01 pm
Location: Alicante, Spain

Database connection error in DCS

Post by Ala13_Mdie »

Hi:

I have a problem when I try to connect to the DB. It seems that I haven?t changed from MSAccess to MySQL, but I did.

Image

All the values in all the Login fields are right, but I'm the only one that can't connect to any database of our SE DB installation.

Anyone could tell me what to do?

Thank's and S!
IV/JG7_4Shades
Posts: 2211
Joined: Mon 08 Jan 2007 11:10 pm
Location: Perth, Western Australia

Post by IV/JG7_4Shades »

Sometimes the DCS gets confused, I'm not sure why. To fix this, select "Use MS Access" and hit "Clear Connection", then select "Use MySQL" and clear that connection too. Close the DCS. Start the DCS, select "Use MySQL" and enter connection settings. Should work now.

Cheers,
4Shades
IV/JG7_4Shades
SEOW Developer

Image
Ala13_Mdie
Posts: 33
Joined: Wed 31 Jan 2007 2:01 pm
Location: Alicante, Spain

Post by Ala13_Mdie »

I'm afraid it doesn't work. I've cleared both type of connections, restarted DCS, but it says no. :?

Just started appears that error message, without doing anything, and before doing anything.

To 'avoid' this message, I have to reinstall the program (uninstall it and install it again), but when I launch it and I insert the connection info... this message is shown again.

S!
IV/JG7_4Shades
Posts: 2211
Joined: Mon 08 Jan 2007 11:10 pm
Location: Perth, Western Australia

Post by IV/JG7_4Shades »

Just checking: you do have .NET Framework 2.0 and MyODBC 3.51 installed?
IV/JG7_4Shades
SEOW Developer

Image
Ala13_Mdie
Posts: 33
Joined: Wed 31 Jan 2007 2:01 pm
Location: Alicante, Spain

Post by Ala13_Mdie »

Reinstalled .NET Framework 2.0 and MyODBC 3.51.20.

The f*****g error message keep on being shown. :?

S!
Katana
Posts: 20
Joined: Thu 11 Jan 2007 5:56 am
Location: Paris - France

Post by Katana »

Install local Access Database
Try to connect it (on database1 slot)
Try connection
Is it good ?
... then Close DCS
Open again DCS and change to Mysql connection
Set parameters and Try connection

It's Ok ?

If it's not. What's your error message ?
C6_Katana
SEOW Developer
Ala13_Mdie
Posts: 33
Joined: Wed 31 Jan 2007 2:01 pm
Location: Alicante, Spain

Post by Ala13_Mdie »

Ok. It's working finally. Thank you very much. :roll:

When I changed to MySQL, after closeing and opening DCS again, that error message appeared, but it let me connect to the MySQL DB now. :?: :shock:

Thank's again. :wink:

S!
22GCT_Gross
Posts: 302
Joined: Fri 13 Apr 2007 1:13 pm
Location: Italy

Post by 22GCT_Gross »

It occurred also to me sometimes. I solved reloading php/apache/mysql.
22GCT_Gross
moosch
Posts: 1
Joined: Tue 13 Nov 2007 5:36 am

Post by moosch »

Hi,

I have the same problem, following the solutions as mentioned above doesn't solve the problem for me.

Everytime I try to connect I get the same error. I have installed it on my Vista 64bit system with ODBC 3.51.21 and .NET 3.0. I have no problem connecting to MySQL with the ODBC-link and also MP retrieves the data correctly from DB.

I tried installing DCS on my XP laptop. At first I had the same problem but after closing and reopening DCS it had already selected the MySQL database and I was able to connect. On my Vista system it doesn't remember that I selected MySQL previously.

At the moment I'm running out of options, could anybody help me in solving this problem? Thanks!
IV/JG7_4Shades
Posts: 2211
Joined: Mon 08 Jan 2007 11:10 pm
Location: Perth, Western Australia

Post by IV/JG7_4Shades »

Hi Moosch,

DCS is built explicitly under .NET 2.0 and (32-bit) XP. I know that Crazyivan was experimenting with DCS on 64-bit software, so I'll see if I can get him to join this thread.

Cheers,
4Shades
IV/JG7_4Shades
SEOW Developer

Image
Post Reply