SQL Connection failure

[Gertsch123]

Hi

I use the following code to connect to a SQL2000 DB on a remote server

global $DSN = "DRIVER={SQL Server};SERVER=MySvr;DATABASE=MyDB;UID=MyUser;PWD=MyPwd;"

$conn.Open($DSN)

but keep on getting the following error

C:\scripts\testdb.au3 (10) : ==> The requested action with this object has failed.:

$conn.Open($DSN)

$conn.Open($DSN)^ ERROR

->10:25:47 AutoIT3.exe ended.rc:1

>Exit code: 1 Time: 1.775

I'm sure the username, password and DB name I use is correct as well as the server name.

Any Ideas?

Thanks

Gert

[Gertsch123]

Sorry, uploaded message twice

Gert