SQL Express Win Auth

[EZEason]

I have an app that is to store data into a SQL Express database. The connection works fine. I can store data from my pc. The database is set up for Windows Authentication. When the app runs on another workstation, the data is not save. Here is the connection string:

    ConnectionString = "Provider=SQLNCLI;" & _
                        "Integrated Security=SSPI;" & _
                        "Persist Security Info=False;" & _
                        "Data Source=Serv\SQLEXPRESS;" & _
                        "Packet Size=8192;" & _
                        "Initial Catalog=Database;"

I do not get any errors about the conneciton. Is there something I'm missing?

What doesn't kill you makes you stronger.

 

[gmmastros]

It looks like you are mixing your connection strings (between sql 2000 and sql 2005). You should take a looks at

http://www.connectionstrings.com

    ConnectionString = "Provider=SQLNCLI;" & _
                        "Trusted_Connection=yes;" & _
                        "Server=Serv\SQLEXPRESS;" & _
                        "Database=Database;"

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[EZEason]

I tried it and recieve Error 3706: Provider cannot be found.



What doesn't kill you makes you stronger.