sql.request

[teepee]

Does anyone have a comprehensible guide on how to use it that a dolt like me
can follow? Every time I try I get a #N/A.

The only guide I can find is at
http://www.bygsoftware.com/examples/zipfiles/UsingSqlRequest.zip but it's
really hard to follow.

 

[Guest]

From the MSDN Library:
http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/office97/html/SEC41.asp

Not sure how familiar you are with ODBC; but if you are getting #N/A as a
result, it is usually because of problems either with the SQL syntax or the
connection string. There are a few examples of connection strings in the
reference above, but since these are dependent on the database driver used it
is not easy to give an all-encompassing guide on how to write the connection
string. Best thing I have found is to search the database developer's site
for "connection string" or do a generic net search for "Connection String"
with your db name, e.g. "Connection String Oracle"

 

[teepee]

From the MSDN Library:

http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/office97/html/SEC41.asp

Many thanks

tp