Connecting to SQL 7

[Lethal]

Is it possible to connect to a SQL 7 Server via the standard data control?? Reason being, using this control is the only way I can figure out how to use a bookmark. ADODC is giving me fits trying to use the bookmark property.
Any suggestions??

try using the data environment. it always works fine for me whenever i connect to SQL Server 7.

[Orpheus]

Set the .DefaultType property to Use ODBC on the form ( or dbUseODBC in code) and then set the database name to an ODBC DSN. I cannot guarantee that bookmarks will work anyway because it is dependant on the database to provide this functionality.