"Network=dbmssocn;"

Larry,

I added that line to my program to create the DSN and if you go to the Client Configuration options, the Network library is changed to Other and the File name is now dbmssocn.

Maybe this is only for dsn-less connections?

Kevin

************************
cDSN="DSN="+alltrim(thisform.cDSN)
cDescription="Description="+alltrim(thisform.cDescription)
cServer="Server="+alltrim(thisform.cServer)
cDatabase="Database="+alltrim(thisform.cDatabase)
settings= cDSN+chr(0)+cDescription+chr(0)+cServer+chr(0)+cDatabase
If Thisform.NetworkType="TCP/IP" && leave alone for Named Pipes
settings = settings +chr(0) + "Network=dbmssocn"
Endif
********************************************