ODBC/DSN With it own free will

P

Poul Max

Now it's getting weird - I have a module where I with the following
code

(code fragment):
CreateWorkspace.........
OpenConnection("Connection1", dbDriverNoPrompt,
,"ODBC;DSN=Navision..........
Srcstr = "SELECT Varebeskrivelse, Nummer............
OpenRecordset(Srcstr, dbOpenSnapshot)

are pulling data from a Navision database - on a couple of PC there is
no problem, but on others I get an ODBC failure and tracing reveal
that on those machines the string 'Srcstr' are changed so it looks
like this :

SELECT * FROM SELECT Varebeskrivelse, Nummer........

that means there is added an extra 'SELECT * FROM' to the string.

It is AC97 and I have tried on both a W2K and XP machine.

How the heck can that happen.

T.I.A.
Poul Max
 
Top