Unable to connect to an mdb database???

[factotum]

First look at in.de and got this error:

Pro Gamma Instant Developer
File containing detailed information about the error

Send this file to <mailto:support@instantdeveloper.com>
to technical support

SQL context number: 10308
Connection string: Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=\;Jet OLEDB:System database=C:\Users\Paul\Documents\Alpha Five V12\MDBFiles\alphasports.mdb

Offending command ------------

------------------------------



Dumping ADO Error 1 of 1
Number = -2147467259 (80004005)
Source = Microsoft JET Database Engine
Description = Could not open table 'MSysAccounts' in the workgroup information file.
HelpFile = (null)
HelpContext = 4C57A5
SQLState = 3173
NativeError = -124979060 (F88CF88C)

Any idea?

Paul

[g.lanzi]

Can I ask you the version of your OS?
Can you try to create a brand new .mdb file and connect to it, so that we can begin to understand where the problem lies?

1) Create a new DB in your project
2) add a table with a field
3) in the new DB properties set ". est.mdb", then focus the server name field and after that click on the create file button.
4) verify the connection

Can you post here what appens if you do that?

[factotum]

Sorry, I posted this issue more than once because I couldn't understand why it was not appearing in the forum. Alan very kindly fixed this for me in teamviewer, so I understand now. The next hurdle is getting in.de to look at a MySQL database - seems I need to install odbc and create a dsn ???
Where do I go in documentation to understand the sequence of procedures for this?

Thanks,

Paul

[g.lanzi]

OK, glad th read that you're now able to connect to the database. Let me complete the topic saying that if you want to connect to an access database with User Level Security activated, you have to specify also the .mdw file in the server database's property. Username and password must be inserted too.

Speaking about MySQL, ID uses an ODBC driver to connect to those kind databases. You have to install the ODBC 3.51 Connector driver (that you can find here http://dev.mysql.com/downloads/connector/odbc/3.51.html ), with that you will be able to connect to the database from ID, which uses an ADO connection.

Once ID is able to connect to the database, you have to make work the web application's connection.
In C# the MySQL.Data.dll driver is automatically included in the Bin directory of the web application, so you've already done it. In Java you have to add the JDBC connector to your tomcat lib directory ( http://dev.mysql.com/downloads/connector/j/5.1.html ).

[factotum]

Thank you Giuseppe :)