VB application

[Ruaidhri Garvey]

Hi

I have created a Visual Basic application the connects to my SQL database.
The appliction lets a user click on a button, data is retrieved from the database
and then formatted in Excel. Everything works fine on my machine (this is probably
because i have both VB and SQL installed on my machine)
I have created a .exe and deployed the application on some users desktops. The
problem is that when they click on a button - nothing happens. I dont even get any
error messages! Everything else appears to be fine. I have tested the DSNs and
they appear to be fine too.
Does anyone know why this would happen ??

Thanks, Ruaidhri.

[Ruaidhri]

No - it is a simple application that runs a few stored procedures
and formats the results in Excel.

Have you any idea.




PS. Scott i may have something that might help you out.
I will post it when i find it later today.


------------
pd at 1/20/01 12:43:12 AM

Are you linking DTS package with your VB applicatio?


------------
Ruaidhri Garvey at 1/19/01 11:58:31 AM

Hi

I have created a Visual Basic application the connects to my SQL database.
The appliction lets a user click on a button, data is retrieved from the database
and then formatted in Excel. Everything works fine on my machine (this is probably
because i have both VB and SQL installed on my machine)
I have created a .exe and deployed the application on some users desktops. The
problem is that when they click on a button - nothing happens. I dont even get any
error messages! Everything else appears to be fine. I have tested the DSNs and
they appear to be fine too.
Does anyone know why this would happen ??

Thanks, Ruaidhri.

[Scott]

Thanks Ruaidhri,

I will check back later


------------
Ruaidhri at 1/22/01 1:02:48 PM

No - it is a simple application that runs a few stored procedures
and formats the results in Excel.

Have you any idea.




PS. Scott i may have something that might help you out.
I will post it when i find it later today.


------------
pd at 1/20/01 12:43:12 AM

Are you linking DTS package with your VB applicatio?


------------
Ruaidhri Garvey at 1/19/01 11:58:31 AM

Hi

I have created a Visual Basic application the connects to my SQL database.
The appliction lets a user click on a button, data is retrieved from the database
and then formatted in Excel. Everything works fine on my machine (this is probably
because i have both VB and SQL installed on my machine)
I have created a .exe and deployed the application on some users desktops. The
problem is that when they click on a button - nothing happens. I dont even get any
error messages! Everything else appears to be fine. I have tested the DSNs and
they appear to be fine too.
Does anyone know why this would happen ??

Thanks, Ruaidhri.