Get "Invalid Data Source" with DataGrid/adodc

[JohnBates]

Hi all - I will try to explain this as best I can:

I have attached my SQL Server 7 table to a VB 6 DataGrid and a DataReport.

The DEConection objects Connection Source is....

Security = SSPI;PersistSecurityInfo=False;InitialCatalog=Warehouse;
DataSource=SQL_SERVER;ConnectTimeout=15

The adodc Connection String is...

PROVIDER=MSDASQL;driver={SQL Server); server=SQL_Server;uid=;pwd=;database=Warehouse;

PROBLEM: When I launch the app from my desktop, the datagrid and report shows all the data, no problems.
But when SOME users run the app from their PC, under their NT login..... the DataGrid does not show any data and the DataReport form gives them message "Invalid Data Source", there is no error number associated with the message.

Do you suspect a Permissions problem in SQL Server or any other ideas ??

Thanks for any help. John

 

[culshaja]

You are using integrated security so you need to make sure that SQL Server is aware that those users exist and that the database user is linked to the Domain Username.

Another thing would be to check that the users have the correct permission son the relevant table(s)/stored procedure(s).

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305