Save this Search
     
Sort by:
  • Posted Date
Other IT & Programming
Fixed Price: $20 - $100   |  Posted: Mar 20, 2015  |  Ends: 2d, 6h  |   3 Proposals
I need this sometime in the next 12 hours (before 6pm Pacific Time Zone ) I want a simple VBscript that I can use to query a database that's on a remote computer and show the results. I will run this from the command line on Windows 7 and it will display results on command line. EXAMPLE COMMAND: Cscript.exe MikeQuery.vbs "select GivenName from customers" RESULTS: Albert Bob Carl --- done --- In this example MikeQuery.vbs is the script and my parameter in quotes is the SQL query. It must connect to the database using an existing "System DSN" that I already configured in Windows ODBC (named "MikeDSN") using the proper driver, hostname of database server, database username and password, and database. The database is Sybase SQL Anywhere version 16 (now SAP) but I don't think it matters since we would use the existing DSN to connect. It should be easy but I'm running out of time and it's frustrating trial and error on what I have found with google.(ID: ...
Category: Other IT & Programming       
Skills: SQL, ODBC, VBScript       

w****pps
 [?]
Sign in to view client's details.
| w****pps
|    United States
Symbol Key
Payment method not yet verified
Payment verified
Purchased $1-$500
Purchased $500-$5,000
Purchased more than $5,000
You have already submitted a
proposal to this job