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