ODBC Connections in a network

[LordOfCode]

Is there any way I don't have to implement ODBC connections in each client machine to connect to SQL-Server Database in Windows NT Network?

 

[foxdev]

You'll have to establish an ODBC connection to connect your VFP to SQL Server. But you don't need to create DSN (data source name) entries on each client. You can use the SQLSTRINGCONNECT function and pass it a complete connection string.

 

[LordOfCode]

However, if I also want to use remote views I must set an ODBC Connection, otherwise I'd have to program all the necesary code to make the resulsets updatable. I expected that maybe there was another way to do it. <p>Edwin Dalorzo<br><a href=mailto:edalorzo@hotmail.com>edalorzo@hotmail.com</a><br><a href= > </a><br>

 

[foxdev]

Well, as I said, you'll ALWAYS need an ODBC connection, but you don't necessarily need a Windows DSN, even with remote views.<br>
<br>
Unlike SQL pass-through, a remote view will require a named connection in your DBC. But you can create a named connection by specifying &quot;connection string&quot; and entering the same criteria as you would put for SQLSTRINGCONNECT(); if you specify everything, including the driver, you won't need to create a Windows DSN.