Getting an error when I created a exe from VB

[miller1975]

Hello All,
I had made a VB program to update some tables using ODBC connection.
The VB codes works great when its ran from the VB mode. I want to make an exe out of it so I can make it a Scheduled process to run from Windows XP.
When I made the exe, it created the exe successfully.

But when I tried to run the exe it gave me this error
-2147467259(80004005) runtime error
[Microsoft][odbc driver manager] Data source name not found and no default driver specified.

The funny part is, I have one other exe on the same machine which was also made from VB and that one runs fine.

Any ideas why this is not working.

Thanks in advance

 

[bjd4jc]

It would seem that the target machine is missing an ODBC entry.

 

[miller1975]

Both the target and destination is the same machine and I am running OBCS based exe files and they work fine..
Only this one is giving this error.

 

[Mthales]

This is probably completely unrelated to your problem but I had something similar and it turned out I'd made a real mistake in my coding and where the exe ran from was having and effect.

M

 

[dpk136]

i'm having the same problem. has anyone figured this out.

David Kuhn
------------------

http://www.davidpkuhn.com

 

[avanderlaan]

What account are you trying to use to execute your scheduled process? If you are relying a user DSN, it may be invisible to that account.

 

[dpk136]

i figured it out on my own. Apparently it got blocked by my firewall. i had to go into the firewall and allow it. that was the only problem, so i would check that if i were you and see.

David

David Kuhn
------------------

http://www.davidpkuhn.com