I am having difficulty connecting to my ISP through DW MX.

I am using the following connection string but get errors.

Dim MM_ConnTest_STRING
MM_ConnTest_STRING = Dim sConnect SConnect = "Provider=SQLOLEDB;Data Source=sqlipaddress;" & "User _ ID=userid;Password=password;" & "Initial Catalog=catalog;"

When trying to define a connection I get the message "Format of initialization string does not conform to OLE DB specification"

Any ideas what could be wrong?

I have no problems connecting to the db using MS SQL Enterprise Manager.

Thanks

Davrus

Russell

Create a Custom Connection to your database in DMX and enter this string:

"Provider=SQLOLEDB; Data Source=ISP IP DATABASE ADDRESS; Initial Catalog=DATABASENAME; User Id=USERNAME; Password=PASSWORD"