>Hello all,
>
>In development, I have created remote views based on connections that I made in the ODBC data source icon of the control panel. Now that I've got everything working correctly with the updating etc of the views, I need to code in the connections so that the users will have the same connectivity that I have but created programtically. This is the problem.
>
>I am confused with the create connection command and the sqlconnect() function.
>
>In the DB is stored the name that I gave the connection which in this case is call "bulletin". I also called the view "bulletin" which is connected to an MDB on the novell server named "bulletin.mdb" (there is an entire path here which I am leaving out).
>
>I would assume that in my main.prg, I have to issue the OPEN DATABASE command and then check for the existence of the connections?(How??) (Should I store this info in a separate table (Myodbc fields connection name, source, driver) and then scan it. If the connection doesn't exist I cannot "use" the view. How do find out? Should I issue the command "LIST CONNECTIONS TO myodbc.txt" and then open the txt to see what it holds?
>
>Once I have the connections, how can I know if they exist in the computer, or, if you will, are the views actually connected to the mdb files or not?
>
>HELP!!
>
>Thanks
>
>Sandy
Check out this entry from the UT Windows API listing:
http://www.levelextreme.com/wconnect/wc.dll?FournierTransformation~2,31,Forum=0,18,42You can use it to programmatically create a DSN on your client's PC. You may need to dig out the required parameters for an Access MDB.