Page 1 of 1
sql connection
Posted: Sat Feb 14, 2009 5:12 am
by raj07
in vb.net code behind how i write my own connection string
sql connection
Posted: Mon Feb 16, 2009 6:05 am
by Edward
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.
sql connection
Posted: Mon Feb 16, 2009 6:05 am
by Edward
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.