Page 1 of 1
Database connection error in DCS
Posted: Wed 19 Sep 2007 10:08 am
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.
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!
Posted: Wed 19 Sep 2007 9:39 pm
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
Posted: Thu 20 Sep 2007 6:03 am
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!
Posted: Thu 20 Sep 2007 7:37 am
by IV/JG7_4Shades
Just checking: you do have .NET Framework 2.0 and MyODBC 3.51 installed?
Posted: Thu 20 Sep 2007 8:20 am
by Ala13_Mdie
Reinstalled .NET Framework 2.0 and MyODBC 3.51.20.
The f*****g error message keep on being shown.
S!
Posted: Thu 20 Sep 2007 8:39 am
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 ?
Posted: Thu 20 Sep 2007 8:59 am
by Ala13_Mdie
Ok. It's working finally. Thank you very much.
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.
Thank's again.
S!
Posted: Fri 21 Sep 2007 7:30 am
by 22GCT_Gross
It occurred also to me sometimes. I solved reloading php/apache/mysql.
Posted: Tue 13 Nov 2007 10:57 am
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!
Posted: Tue 13 Nov 2007 8:36 pm
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