Hi friends,

I have created a database in SQL Server which is SQLServer
authenticated. The user name is : abc123 and password is : xyz123 and the
server name is SERVER(in which SQL Server is installed, W2K Server). Database
name is : kanetopdb

How can i connect from .aspx.vb file?

i have given "SERVER=server;UID=abc123;PWD=xyz123;database=kane topdb;"

But i couldnt connect?

Try these
"SERVER=server;UID=abc123;PWD=xyz123;data source=kanetopdb;"
OR
"SERVER=server;User ID=abc123;Password=xyz123;data
source=kanetopdb;persist security info=true"
or you could follow the following
1. Create a text file
2. rename db.udl
3. double click on the file
4. in the graphical interface click on provider tab Select OLEDB
provider for SQL Server click next
5. Provide the required information
6. Close the form and open the file in wordpad

This works for me.

"server=lisa;database=master;uid=saprow;pwd=fkgfub v;"

"Rajani" <Rajani (AT) discussions (DOT) microsoft.com> wrote