cottoncandy55
New Member
Besides the fact that one access SQL Server and the other is for other ODBC data sources, is there any syntactical difference besides the actual connection string to connect to the database?<BR><BR>For example, if I want to do this, and it works with Access, will it work in SQL Server with a simple find/replace for ADO with SQL?<BR><BR>Dim myConnection as ADOConnection <BR>Dim myCommand as ADOCommand <BR><BR>myConnection = whatever<BR><BR>myCommand = new ADOCommand("INSERT into friends (firstNAME,lastname) VALUES ('David','Johnson')", myConnection) <BR>myConnection.Open() <BR>myCommand.Execute() <BR>myConnection.Close()No syntactical difference (other than the ADO prefix being swapped with the SQL prefix, or vice versa). The SQL classes offer increased performance with SQL Server 7.0 and up, though, implementing a protocol that talks directly with SQL Server instead of using the OLE-DB provider.