Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.
marabou

marabou

IS-IT--Management
Jan 12, 2001
86
GB
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
 
Status
Not open for further replies.

Similar threads

K
  • Locked
  • Question
We're using command in crystal report
Replies
1
Views
210
hilfy
hilfy
JustMe24
  • Locked
  • Question
How to select from 2 rows in a table
Replies
1
Views
149
SoftwareRT
SoftwareRT
David Richardson
  • Locked
  • Question
Adding BLOB Fields to Reports in Crystal Reports Professional 8.5
Replies
7
Views
260
hilfy
hilfy
socalvelo
  • Locked
  • Question
Mouse Clicks not Working in Sections Area
Replies
2
Views
214
socalvelo
socalvelo
VHDN
  • Locked
  • Question
Using Special File in Command
Replies
5
Views
184
hilfy
hilfy

Part and Inventory Search

Sponsor

Back
Top