connection string in asp

**ashwika42** · Oct 20 '13, 02:31 PM

hi
I am new to asp development - and I' not sure what is wrong with my connection string - when i run the application it just hangs on this statement.=

My connection string is defined in another page as :

Code:

connectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;'Persist Security Info=False;Initial Catalog=SupportDB;Data Source=ADMIN-PC\SQLEXPRESS"

and code to open the database is :

Code:

SET DbObj = Server.CreateObject ("ADODB.Connection")
DbObj.Open connectionString

the database is windows authentication

not sure what is happening - i have response.write before the connection and that statement is executed Ok

Any help will be much appreciated ...
many thanks