ODBC Connection - SQL Server authentication doesn't work in VB app

[marabou]

We have a report which we have stripped out the location of the view and just left in there the view name and the name of the dsn (a Sql Server 2000 dsn)(for migration purposes). Opening the report in all locations with the right named dsn works only as long as the server has NT authentication on it. This new client has SQL Server authentication on their server and we cannot get the report to open within the VB app.

Has anyone any ideas on why it is doing this. It is quite urgent so any help would be greatly appreciated.

Thanks in advance

 

[gurlfob]

Try to pass the connection string from VB. What Report object collection are you using in VB to call the report? I can give you the code if you want. Let me know.