sql connection

raj07 · Post by **raj07** » Sat Feb 14, 2009 5:12 am

in vb.net code behind how i write my own connection string

Post by **Edward** » Mon Feb 16, 2009 6:05 am

Hello,

Here you are

TryCast(report.Dictionary.Databases.Item("ConnectionName"),StiSqlDatabase).ConnectionString = "Data Source=.\sqlexpress;Integrated Security=False;Initial Catalog=D:\DATA\SQLSEVEREXPRESS\NORTHWINDEXPRESS.MDF;User ID=uid;password=pwd"

Thank you.

Post by **Edward** » Mon Feb 16, 2009 6:05 am

Hello,

Here you are

Code: Select all

TryCast(report.Dictionary.Databases.Item("ConnectionName"),StiSqlDatabase).ConnectionString = "Data Source=.\sqlexpress;Integrated Security=False;Initial Catalog=D:\DATA\SQLSEVEREXPRESS\NORTHWINDEXPRESS.MDF;User ID=uid;password=pwd"

In case of compiled report:

Code: Select all

TryCast(report.CompiledReport.Dictionary.Databases.Item("ConnectionName"),StiSqlDatabase).ConnectionString = "Data Source=.\sqlexpress;Integrated Security=False;Initial Catalog=D:\DATA\SQLSEVEREXPRESS\NORTHWINDEXPRESS.MDF;User ID=uid;password=pwd"

Thank you.