troubleshooting Question

Error performing a "Load into" from VB.Net to Informix

Avatar of webkiwi1
webkiwi1 asked on
DatabasesVisual Basic.NET
3 Comments1 Solution995 ViewsLast Modified:
Hello experts...quick one before the holiday weekend!

I am trying to load a comma deliited file into an Informix table from within VB.Net.

I am buidling the string:

 "load from " & Chr(34) & filename & Chr(34) & " delimiter " & Chr(34) & "," & Chr(34) & " insert into mytable"

but am getting the error "ERROR[42000][Informix .NET provider][Informix]A syntax error has occurred." can it does not complete the load into my table.

If I break the program and copy and paste the string into my database application (Server Studio) it works just fine. ("load from "c:\temp\test.txt" delimiter "," insert into mytable")

Any thoughts?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 3 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros