General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Ok, I just started to use the MSDE and I installed it in a PC with Windows XP Professional.
I have another machine with Windows 2000, and I’d like to connect to the SQL server on the XP machine.
I already created a DSN on the machine with Win XP and MSDE.
Now my newbie questions:
Do I need to create a DSN on the client machine in order to connect to the SQL Server on the WinXP box?
By looking at some samples at the fox.wiki.com, it looks like if you can execute sqlstringconnect in order to establish a connection to the DSN and start creating, modifying, etc. the SQLServer database without having to create a connection into a VFP database. However, the views should be created and I think it is here when database created connections are needed. Is it that the sqlstringconnect function is useful only to perform administration activities for the SQL connection and remote view should be created in order to access the data?
Any advice about first steps tith MSDE, what to do next and how to do it will be very helpful for me.
Thanks in advance.
Oscar Corte
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only