Howdy...
I honestly thought that doing this was going to take five minutes!
I created a SQL Server 2000 database on my local Windows 2000 laptop. No network involved. Let's just call the database TEST.
I did not specify any additional logon name/password...I'm just accepting the default Windows 2000 authentication.
I then created a DSN name in the Data Sources Administration under Control panel.
When I try to connect to it throught VFP, I get all types of errors about access to server denied, logon failed.
I'm trying to connect as follows:
oConn = CreateObject("adodb.connection")
oConn.Provider = "SQLOLEDB"
oConn.ConnectionString = "User ID=administrator;Initial Catalog=TEST;Data Source = TEST"
oconnection.cursorlocation = 3
oconnection.open
And then I get the errors.
I've tried all types of different connection strings, specifying my server name 'DJ1HR3', a user ID of 'SA', and nothing seems to work.
I'm feeling pretty stupid right now, having seen this demonstrated at Devcon and in 100 different computer books, but I'm missing something. I don't know if it's syntax or something I did not set up correctly.
Help!!!
Thanks in advance,
Kevin