ODBC Connections in a network ODBC Connections in a network LordOfCode (Programmer) (OP) 26 Feb 00 14:39 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? RE: ODBC Connections in a network foxdev (Programmer) 28 Feb 00 13:02 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. RE: ODBC Connections in a network LordOfCode (Programmer) (OP) 28 Feb 00 18:45 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. Edwin Dalorzoedalorzo@hotmail.com RE: ODBC Connections in a network foxdev (Programmer) 29 Feb 00 12:56 Well, as I said, you'll ALWAYS need an ODBC connection, but you don't necessarily need a Windows DSN, even with remote views. Unlike SQL pass-through, a remote view will require a named connection in your DBC. But you can create a named connection by specifying "connection string" 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.