Creating DSN from Fox

[dellyjm]

How do I create a DSN from within code using Visual Fox?

Delton.

 

[foxdev]

See the FAQ: faq184-65

Basically, you'll use SQLStringConnect to pass the entire connection string. The various elements that you'll pass within the string (many are optional) depends on what ODBC driver (hence, what data source) you are using. Robert Bradley
Support operation moo!
Visit the OpCow page

http://www.agrainofhope.org/opcow.shtml

to help in this cause

 

[dellyjm]

Thanks, but what i need to know is how to go through the ODBC Datasource with Control Panel and create one from there.

Delton.

 

[foxdev]

Oh, sorry...I misunderstood. Robert Bradley
Support operation moo!
Visit the OpCow page

http://www.agrainofhope.org/opcow.shtml

to help in this cause

 

[dellyjm]

How do you do that?

Delton.

 

[flintstone42]

the following code with take the alias tmp
(Make sure you are at the top of the table)
copy to the clipboard(datatoclip), open excel
and paste it into a spreadsheet

select tmp
goto top
_vfp.DataToClip("tmp",reccount(),3)

* copy to (ofile) type xl5
oexcel=createobject("Excel.application&quot
oWorkbook = oExcel.Workbooks.Add()
oBook = oExcel.Workbooks.Add()
oExcel.Visible = .T.
oBook.Sheets[1].paste()

how this works