Application Note for QuNect ODBC for QuickBase
Opening up a Quickbase table from VBScript
This will open up the table with a DBID of 98q55xrp. It will move to the first record and display the name of the first field and its contents. You can find the DBID of your Quickbase table by reading the How to Find the DBID of a Quickbase Table application note.
Don't forget to put your username, password and DBID into this script. You'll have to replace "YourQuickBaseUsernameOrScreenName", "YourQuickBasePassword", "98q55xrp" with the appropriate values.
Dim Conn dim rs Set Conn = CreateObject("ADODB.Connection") dim connectionString connectionString = "Driver={QuNect ODBC for QuickBase};QUICKBASESERVER=acme.quickbase.com;APPTOKEN=yourAppTokenString;UID=YourQuickBaseUsernameOrScreenName;PWD=YourQuickBasePassword;" wscript.echo "Opening connection with " & connectionString Conn.Open connectionString Set Rs = CreateObject("ADODB.Recordset") Const adUseClient = 3 Rs.CursorLocation = adUseClient Rs.Open "select * from DBID98q55xrp", Conn Rs.movefirst() wscript.echo Rs.fields(1).name, Rs.fields(1) Conn.close