as I said
"sqlstring conection is not an option,"
but thnks


>>I need to create a system odbc connection programatically. sqlstring conection is not an option,
>>
>>it shoudl be something like this
>>run a loader
>>the loader creates the odbc depending in a selection the user makes
>>the loader runs the main program
>>the main program uses the odbc
>>
>>
>>i only need the code to create the odbc though
>
>In my forms Load:
>
>

>STORE SQLSTRINGCONNECT('Driver={SQL SERVER};Server=MyServer;Database=MyDatabase;uid=MyUser;pwd=MyUser');
>	   TO gnConnHandle
>IF gnConnHandle < 0
>   = MESSAGEBOX('Cannot make connection', 16, 'SQL Connect Error')
>ELSE
>     Thisform.pConnection = gnConnHandle
>ENDIF
>
>

>
>On the Form create a Property called pConnection
>
>In your search method:
>
>

>Local tConnection
>tConnection = Thisform.pConnection
>
>*	You can use different ways to get the data – here is one using SQL Passthru
>
>SQLEXEC(tConnection, 'SELECT * FROM MyTable ', 'cMyTable')
>
>