Dynamic AI Support Forum

the problem is that I am able to connect to the Database and if I test the connection it is succesfull, but if I try to view the Tables the program only shows retrieving data and nothing happens.
please help

Hi Stefan,

I'd be happy to help you if I can, but I am not familiar with the Impax system other than what I've been able to Google. Do you know what the underlying database is? Or can you show me screen shots of the ODBC database connection setup (if it is ODBC of course)

You can email me on boa@cintac.com

Best regards
Bo

I sent you an e-mail
best regards
Stefan

Hi Stefan

Thanks for informing me that its a Microsoft SQL Server.

Thats a bit surprising - usually SQL server behaves very well.

What permissions does the user test have on the sql server? Maybe the account can connect, but not list tables - I don't know which version of sql server you have - but you could test by assigning the dbowner role and see if that makes a difference.

If not, try - just to test, see if you get any results if you
a) insert dbo in the katalog field.

or

b) try to connect to a different database on the sqlk server (sometimes northwind or adventureworks databases are present)

Let me know how it goes

Bo

I changed the owner to dbo and it does not change anything
On the server I have got only the permission to read.
The MVF database is the only one on the server ,which i can access.
best regards
stefan

Hi Stefan

Can you try checking the Read only (Nur Lesen) box on the connection definition in Dynamic?

Best regards

Bo

Did not change anything
best regards stefan

Hi Stefan

Would it be possible for you to find out which version of SQL Server you're running, and the exact permissions the account "test" has on the database you connect to?

I will then try to reproduce the problem to be able to suggest a solution.

Best regards

Bo

I'll find it out and write you tomorrow the exact sql version and the permissions
best regards stefan

It is the Microsoft SQL Server 2000
and i have got the permission to read from the database
I have also got the permission to access the server
Best regards stefan

Hi Stefan

To check if the error occurs because your account does not have the necessary permissions to retrieve table and view information on the SQL server, you can try creating a dynamic view that retrieves data from a table you know exists.

You need to save your connection (you probably already did)
then

click dynamic view:

then give the view a name, select your connection and type some valid sql:


If you can retreive data from that Dynamic AI SQL view, it's probably a permissions issue.

Thanks for your patience

Best regards

Bo