ODBC only works on development machine

[drmike]

I am using ODBC to connect to a remote MYSQL database.

I have two PCs one is the development PC and the other my laptop.

Both use the same DSN, both connections work and test OK. The laptop can use Access to link to the MYSQL database using ODBC.

However, when my VB.NET program connects to the database on anything other than the development machine the program fails on the da.fill(dt) statement (da is the ODBC dataadapter and dt is a datatable). The da is performaing a simple SELECT statement.

Both are running XP Pro but the development machine has VB EXpress 2005 on it as well as SQL Express 2005.

Also the development PC has automatic updates on while the other machine does not.

Can anyone suggest what the problem might be?

Thanks in advance

Mike

 

[drmike]

Didn't take ong - MDAC. I misread something on the MS site and didn't realise I needed to update my MDAC.

2.8 seems to be fine.

Mike