Hi
I am using Alpha Five V.9 and SQL Server Database for my web application.I created a Named connection string for connect the DB.In Xbasic code how can use the Named connection string to connect the SQL server.I tried & get the records from the table as follows :

tbl = table.open("[SQL_Connection]\product_category.dbf")
tbl=tbl.sql_exec("select * from product_category where highercategoryid=0")
recs = tbl.records_get()
dim a_cats[recs] as p
a_cats.initialize_from_table(tbl,".t.","catdescription")
tbl.close()

In the above, [SQL_Connection] is the Named Connection string.
Here i unable to connect it.If i use the connection string

"{A5API='SQLServer',Server='ABC\SQLEXPRESS',Trusted_connection=yes,Database='xyz'}"

like this it is working fine.so how to use the Named Connection string in XBasic code?...Please help me to come out of this problem...Thanks in Advance....