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