Conn String Confusion

Hi Peeps,

I am totally confused now.

My application uses a direct connection, which works 100%. The string:

Public sConn As New SqlConnection("Data Source='JUAN-PC';Initial Catalog='chromepos';Integrated Security=True;User Id='sa';Password='password';")

The application is designed to retrieve the settings from a file, which worked fine. The string:

Public strConn As String = "Data Source='" & frmMain.sql_Server & "';Initial Catalog='" & frmMain.sql_Catalog & "';Integrated Security=True;User Id='" & frmMain.sql_User & "';Password='" & frmMain.sql_Pwd & "';"
Public sConn As New SqlConnection(strConn)

This worked fine until this morning. Now the application opens and closes the connection, but can't seem to actually perform any commands. Any advice?

The system should retrieve the connection values from a seperate file and then use them to connect to SQL as set by the user.

The system retrieves everything, I tested that but as soon as I send a SQL command, it returns an error.

0 answers