Are you sure that connection string is correct in compiled application?
>I download and install MDAC 2.8 but did not work but I try the previous installed VFP7 in the command windows like this.
>oCon = CreateObject("ADODB.Connection")
>oCon.Open("Provider=SQLOLEDB.1;Data Source=< myserver >;Initial Catalog=< mydatabase >;User ID=sa;Password=;")
>It work but even before I install the MDAC 2.8 but when I try the compiled program in made in VFP8 after I install the MDAC 2.8 this is the message OLE lDispatch exception code 0 from Microsoft OLE DB Provider for SQL Server [DBNETLIB][ConnectionOpen(Initialized()()).]General network error. Check documentation.your network. What am I doing wrong?
--sb--