>How do I modify this for SQL Server 7.0
>
>goApp.nhandle = "SQLStringConnect(Driver=Microsoft ODBC For Oracle;" ;
> + "UID=" + alltrim(oLoginForm.txtUserID.Value) + ";" ;
> + "PWD=" + alltrim(oLoginForm.txtPassword.Value) + ";" ;
> + "Server=SID;"
>
>I.e. what is the driver for Microsoft for ODBC SQL Server 7.0
You can go into the ODBC Manager and create a File DSN pointing at the SQL Server, and then open the DSN with Notepad. It will contain the connection string you want to use in your SQLSTRINGCONNECT command.