'Import DB Schema from ODBC' problem

[Mike Dorey]

Hi all,

I am having problems using the ''Import DB Schema from ODBC' feature in EA, and cannot seem to get it to detect any tables from the database I am pointing at.   I can list system tables OK if I check the 'include system objects' check box.

I have tried this with 'SQL Native Client' driver - 2005.90.3042.00, and SQL Server driver 2000.86.3959.00.

The ODBC data source I have set up uses Windows Integrated Authentication, and I can connect to the database with no problem and also run queries against it using query analyser etc.

Any ideas?   Thanks

Mike

[«Midnight»]

Your SQL Server credentials are probably the culprit here. This is a SQL Server problem, not an EA issue. It is quite likely in SQL Server 2005 or 2008 where the default authentication setup works this way.

Have your DBA or whoever ensure that there is a user created for your account. It is also necessary to set the domain (or machine if you are not authenticating across a domain) name explicitly when setting up the user. Then ensure that appropriate access privileges (not the defaults) are set up on roles assigned to that user.

David

PS: Yes, I can successfully connect to SQL Server 2008, but had to go through this process once before things worked at all.