>Still getting an invlid connection:
>
>mpro30 = sqlc("Provider=sqloledb;Data Source=10.1.1.73,40873;Network Library=DBMSSOCN;Initial Catalog=Chains;user ID=chris;password=chris2;")

Hmmm.... normally I have wrapper methods so I do not have to deal with those directly
something like

lcConnectionString = This.GetConnectionString()
lnConnection = sqlStringConnect(lcConnectionString, This.lODBCShareConnection)


Ah, I see. You are using SQLConnect(), I am using SQLStringConnect.

With SQLConnect You will have to pass the single items as different parameters, i.e. different strings devided by colons.

the syntax is SQLCONNECT([cConnectionName | cDataSourceName [, cUserID [, cPassword ]][, lShared]])

However You are not passsing a connection- or DatasourceName but the Connectionstring. could You try with SQLStringConnect instead?