Need help on database connection in asp

[sean2818]

I have some codes as following in asp:


set Conn=server.createobject("ADODB.Connection")
Conn.open "Driver=SQL server;PWD=asptest;UID=asptest;SERVER=SWIFT"

it works well.

but if i change codes like these:

set Conn=server.createobject("ADODB.Connection")
Conn.Provider="SQLOLEDB"
Conn.open "SERVER=SWIFT;UID=asptest;PWD=asptest"

It doesn't work.

Can anyone give me any idea on latter codes?

Thanks

Sean