problem
-
i have windows server 2008 R2 webserver edition, SqlServer 2008 enterprise and PowerShell 2.0. But this is Sql C# code can't connect. But can connect offical components. Exam: SQLDataSource. cs = "SERVER=.\\SQLEXPRESS;Initial Catalog=arch;Integrated Security=SSPI"; con = new SqlConnection(cs); querystring = "SELECT user_name, password, user_type FROM [users]"; cmd = new SqlCommand(querystring, con); con.Open(); I thing block code PowerShell. Help!
battulga
-
i have windows server 2008 R2 webserver edition, SqlServer 2008 enterprise and PowerShell 2.0. But this is Sql C# code can't connect. But can connect offical components. Exam: SQLDataSource. cs = "SERVER=.\\SQLEXPRESS;Initial Catalog=arch;Integrated Security=SSPI"; con = new SqlConnection(cs); querystring = "SELECT user_name, password, user_type FROM [users]"; cmd = new SqlCommand(querystring, con); con.Open(); I thing block code PowerShell. Help!
battulga
You say you have SQL Server 2008 enterprise, yet your connection string is for SQLEXPRESS. Is your SQL Server 2008 a named instance, named SQLEXPRESS ?
Christian Graus Driven to the arms of OSX by Vista. Please read this[^] if you don't like the answer I gave to your question. "! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
-
You say you have SQL Server 2008 enterprise, yet your connection string is for SQLEXPRESS. Is your SQL Server 2008 a named instance, named SQLEXPRESS ?
Christian Graus Driven to the arms of OSX by Vista. Please read this[^] if you don't like the answer I gave to your question. "! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
This is code can run before time on Windows Server 2008, SQLServer 2008.
battulga