not connecting to database 1

[lizzieborden]

I have a vb app that connects to a sql server database. It works fine before compiling but then after I compiled it and put it on the network and run the .exe it reads 0 records. I have seven (test rows in my table). I copied it over to xp machine desktops and it works. I copy it to nt4 desktops and it still reads 0 records?????

I have the .net framework and sp on all workstations.

Here is my code just in case: If conagency.State = ConnectionState.Closed Then
conagency.ConnectionString = "workstation id=DAP;packet size=4096;integrated security=SSPI;data source=DAP;persist security info=False;initial catalog=Agency_Profiles"
conagency.Open()
End If

 

[chrissie1]

try this instead

conagency.ConnectionString = "workstation id=DAP;trusted_connection=true;data source=DAP;initial catalog=Agency_Profiles"


Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[lizzieborden]

Thanks Chrissie1 -

This didn't work for me. My app still works from Windows XP but not NT4????

 

[lizzieborden]

It looks like it may be a permissions issue somewhere... I can log into my workstation and run it and it works (I am an admin). If I log into my workstation as a user it doesn't show any records????

 

[chrissie1]

Do your users have all the neccessary rights on the db.

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting

 

[lizzieborden]

Chris -

I did find that the users did not have all of the rights they need. Users can now log onto XP workstations and utilize the software but NT 4 users cannot??????

 

[chrissie1]

Yes, the NT4 thing. Funny things those NT4. I never had problems with them. did you install MDAC 2.8 on them or just try to install the sql-server client tools on them and see if you can make a connection with the enterprise manager.

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting