Problem creating Transform query with ADO

I

Ivan Debono

Hi all,

I'm trying to create a transform query with vb6 and ado 2.8. I'm basically
doing the following:

'Create catalog connection
Set oCat = New ADOX.Catalog
oCat.ActiveConnection = dll_ado.Connection

'Create command object
Set oCmd = New ADODB.Command
oCmd.CommandText = sSQL

'Add view to catalog
oCat.Views.Append sName, oCmd

But I get the error: Syntax error in Transform statement

If I add teh query using Access it works fine. It doesn't want to be added
when I do it through ADO.

Any ideas?

Thanks,
Ivan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2003 Transform Queries?? 7
ADOX: "Could not find installable ISAM" error 2
ADO SQL Problem 2
OWC11 chartspace with a recordset in asp, and error 80004005 3
Parameter default value 17
Query to Filter by Dates, Using Form 7
create query dynamically 1
ADO query eating CPU power 1

Top