Connecting to a remote MsSQL server...?

[sweetman]

Hi all,
can I connect to a MsSQL server using DW MX?

What are the info needed to connect?

I.e.: what do I need to ask to the server admin?

Thanks in advance.

tony

[sweetman]

>You'll need to build a connection string to the database.

>You'll need the following info:
>
>IP address of the SQL Server.
>Username and Password to login.
>Database name to login to.
>
>Your final connection string should look like somthing like this:
>
>MM_conn_STRING = "Provider=SQLOLEDB.1; Data Source=IP_address_here; Network
>Library=DBMSSOCN; Initial
>Catalog=Database_name;uid=Username_here;pwd=Passw ord_here;"
>
>Make the obvious replacements! :)

I can't thank you enough!

Thanks!Thanks!Thanks!

tony

[RobGT]

>I can't thank you enough!

>Thanks!Thanks!Thanks!

LOL
Ya just did :)

Glad to have helped!
Cheers,
Rob [url]http://robgt.com/[/url]
Extensions: [url]http://robgt.com/products/index.asp[/url]
Tutorials: [url]http://robgt.com/tutorials/index.asp[/url]
Blog: [url]http://blog.robgt.com/[/url]