ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   sql.request (https://www.excelbanter.com/excel-discussion-misc-queries/62003-sql-request.html)

teepee

sql.request
 

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/...SqlRequest.zip but it's
really hard to follow.



K Dales

sql.request
 
From the MSDN Library:
http://msdn.microsoft.com/archive/de...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"
--
- K Dales


"teepee" wrote:


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/...SqlRequest.zip but it's
really hard to follow.




teepee

sql.request
 

"K Dales" wrote in message
...
From the MSDN Library:

http://msdn.microsoft.com/archive/de...html/SEC41.asp

Many thanks

tp




All times are GMT +1. The time now is 02:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com