Kevin,
That may be true. I try to stay away from DSN entries. Do you need to create one? Do other programs use the DSN entry you create? If not, you may be able to use DSN-less.
>"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
>********************************************
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao