Microsoft Database Access error

[trancemode]

Some how, I am getting this weird error when not touching even the database.

 

I am using the microsoft database access

 

and I get errors like:

 

Error creating user: ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Cannot open database '|'. It may not be a database that your application recognizes, or the file may be corrupt. SQL Command: INSERT INTO TC_USERS (USER_ID, PASSWORD, FIRST_NAME, LAST_NAME, TYPE, ADDRESS1, ADDRESS2, ADDRESS3, CITY, STATE, COUNTRY, ZIP, HOME_PHONE, MOBILE_PHONE, EMAIL1, EMAIL2, STATUS, PARENT_ACCOUNT, EXTERNAL_ID, BILLING_ID, BILLING_STATUS, GROUP_ID, FILE_SERVER_ACCOUNT, ALLOWED_IPS, SUBUSER_ACCESS_SUPPORT, FILE_SERVER_CUSTOM_GAMES, MD5_PASSWORD) VALUES ('', 'ctjliQAhAIjR5EJNmU235g==', ', 'S', '1', '', '', '', '', '', 'US', '', '', '', '', '', 1, '', '', '', 1, '', 0, '', 0, 0, '91769bc5ac6d7921fd8605e98ceebb00');

 

 

Is there a reason why this is happening? and how to fix this?

The only way I tried was rebooting the whole server which did work but I don't wish to keep on reboot everytime it happens.

 

Thanks.

[trancemode]

Not only creating users, but also this

 

Database.Manager.ExecuteNonQuery: ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Cannot open database '|'. It may not be a database that your application recognizes, or the file may be corrupt. SQL Command: INSERT INTO TC_SERVICE_PERFORMANCE (SERVICE_ID, PERF_DATE, AVERAGE_PLAYERS, AVERAGE_CPU, AVERAGE_MEMORY) VALUES ('TC725885175555484083', '2010-04-03 14:00:00', '0', '0', '87920640')

[ECF]

I would suggest putting in a ticket and having it looked at.

[Steven Crothers]

In addition to what ECF said..

 

Using an Access database is a terrible idea... its not ACID compliant among other many many downfalls. You should migrate your data to MySQL and use that, it'll be loads faster and be far more stable.

[trancemode]

In addition to what ECF said..

 

Using an Access database is a terrible idea... its not ACID compliant among other many many downfalls. You should migrate your data to MySQL and use that, it'll be loads faster and be far more stable.

 

yep just did that!

 

Anyways, thank ECF.

 

I just converted the access database to MYSQL and i do have to agree with you.

its so much faster.. love it.

 

thanks guys

[trancemode]

However, I have a question.

 

what does system settings > remote Server DB Connections do?

 

is this if i have it on a web server except on the master server?

Or do i still need this enable if i am hosting my web and master on the same box?

 

Because everything is still working good on all locations and other boxes, but i couldn't get the remote server db connection to work and was thinking its for web server to servers? or am i wrong?

 

 

Thanks.

[ECF]

That feature is to allow the remote servers to connect directly to the database. this cuts down the time it takes for the software to send and receive responses to and from remote servers.

 

This feature is good to use for systems that have large numers of remote servers or if your server are located far apart.

 

If your servers are running fine as they are now I would suggest leaving it as is.

[trancemode]

That feature is to allow the remote servers to connect directly to the database. this cuts down the time it takes for the software to send and receive responses to and from remote servers.

 

This feature is good to use for systems that have large numers of remote servers or if your server are located far apart.

 

If your servers are running fine as they are now I would suggest leaving it as is.

 

I see.

Well i have few others boxes in 3 other locations.

however, everything seems faster than microsoft access.

and they are all currently functioning, however I was trying to get the remote DB to work (master server) but i kept on getting some invalid msg:

 

"There was an error testing the connection. Tested from - Los Angeles, CA. Error: Can't connect to MySQL server on 'localhost' (10061)"

[ECF]

You need to allow external connections in MYSql, and also make sure that you allow port 3306 through windows firewall if you have it active.

[trancemode]

You need to allow external connections in MYSql, and also make sure that you allow port 3306 through windows firewall if you have it active.

 

ah allright thanks!

 

Oh yeah, i been just noticing after i changed or convert microsoft to mysql.

i just saw this today:

StandardPlugins.Database.Manager.ExecuteNonQuery: ERROR [HY000] [MySQL][ODBC 3.51 Driver][mysqld-5.1.45-community]Out of range value for column 'PERF_VALUE' at row 1 SQL Command: INSERT INTO TC_SERVER_PERFORMANCE (PERF_KEY, PERF_DATE, PERF_VALUE)VALUES('TC5855613707280186015213', '2010-04-04 23:38:47', '9.223372E+18')

 

Is this regarding to the ODBC drivers?