Error 'Invalid Data Source, check configuration'

[Ian McIntosh]

Hi,

I am trying to setup MSSQL with EA v11

I get the error 'Invalid Data Source, check configuration'

I've created a database, run the install script without error, setup the ODBC data source & tested it - all OK.

When I try to open a project and connect to the server, I select my newly created connection, enter the user name & password. I press test connection & it passes that.

I then press ok, once again enter user name & password, then get the error message above.

[qwerty]

You need to fill that DB before you can use it. Open an EAP and user Project/Data Management/Transfer.

q.

[Ian McIntosh]

thanks for the reply.

Any idea which is the best SQL driver to use with EA?

The instruction video suggested EA should identify the database is empty & prompt a transfer.

However, going via the transfer function directly did at least give me a bit more info on the problem. It complained of an unsupported driver. I switched to using SQLOLEDB and now its doing something - but its progressing very slowly. The dialog box has stopped responding & looks like its hung, but I can see the number of records in the database increasing.

(as a test I'm just using the example eap, which I needed to run a clean on before I could do the transfer)

[qwerty]

EA supports native MSSQL but it partially depends on which version you use. ODBC should work in almost all cases. You can change the driver later at any time.

q.