sql through odbc crashes

[steve]

I am evaluating Project 2003 for my employer and I am having some issues with
the importing of data through odbc.

Basically project freezes, sometimes it will automatically crash itself out
and show the send report screen, other times it will freeze for upwards of 30
minutes. I do the same query through ODBC in excel and it only takes about
15 seconds to complete and populate the work sheet.

Any ideas on how to get project to not crash?

 

[steve]

Additionally, I have tried just importing from excel, that seems to work well
except for the fact that project wants to see all columns as TEXT types
instead of the various dates and status values. If anyone could tell me how
to get it to recognize the proper types from excel that would be an
acceptable method for me to use.

Thanks

 

[Maurice Birchler]

You may have run into the same issue I had with opening the entire project.
Perhaps this may help...
The connection to the SQL database must be by the same SQL login as the
login that actually created the Project. Having SQL 'owner' access rights to
the database is not enough.

The reason being that hidden SQL syntax is DATABASE.Owner.TABLE.COLUMN etc.
and only when the SQL login to the database is the actual owner who 'created'
the TABLES in the first instance, can the DATABASE.Owner prefix be omitted
from the syntax.