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


Messages In This Thread
Database Error - by ken gray - 07-19-2022, 01:06 PM
RE: Database Error - by Gintaras - 07-19-2022, 01:31 PM
RE: Database Error - by ken gray - 07-19-2022, 02:30 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)