Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Database Error
#1
I'm having problems with a query to a text file.  I'm not sure what I'm doing wrong here; can someone see what I'm doing wrong?

Macro Macro6
Code:
Copy      Help
Database dbt.Open(dbt.CsText("C:\Temp\move.txt"))
ARRAY(str) at
dbt.QueryArr("SELECT * FROM move.txt" at)

I get the below error.
Code:
Copy      Help
Error (RT) in <open ":3116: /11">Macro6:  0x80004005, Unspecified error.
    [Microsoft][ODBC Text Driver] '(unknown)' is not a valid path.  Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.    <help #IDP_ERR>?
The file is there as I used the 'copy as path' method from Windows Explorer.

Thanks.
An old blog on QM coding and automation.

The Macro Hook
#2
Must be folder path.
...CsText("C:\Temp"))
#3
doh!  yeah, I wasn't outputting the result when testing either which made me think it was failing.
thanks.
An old blog on QM coding and automation.

The Macro Hook


Forum Jump:


Users browsing this thread: 1 Guest(s)