Open it and keep it open.

You don't need DSNs. You can use DSN-less connections. You only need a DBC if you use remote views.

>I am going to convert an app from VFP to SQL Server.
>
>Do I open the connection on application startup, or only when I
>want to hit the database?
>
>Do I used DSN's? Do I really need a DBC?
>
>I would appreciate any tips on converting from VFP to SQL.
>
>Thanks