>I have a notebook with installed SQL Express and Visual Foxpro. I need to confidure a data sources to access data in SQL Express but in the config wizard when i confirm parameters in second page (authentication mode, user and password) a get an error 17 from Sql server and i cannot proceed. I have selected SQL Server driver, inserted the name for the connection, i have selected the server ( the same notebook), Authentication mode: Windows authentication, click on next and i get the error.
>
>If i make the connection with a real SQL server i have in my lan i have no problems.
>
>Thanks
SQL Express is also a real SQL server. You didn't say what the error was.
SQL express installations, unless you modify, use a named instance. Try like:
lnHandle = Sqlstringconnect( "Driver={SQL Native Client};server=.\sqlexpress;Trusted_connection=yes" )
? m.lnHandle
If m.lnHandle = 1
SQLTables(m.lnHandle)
Endif
SQLDisconnect(0)
If m.lnHandle = 1
Select SqlResult
Browse
Endif
Cetin