major deployment problem

[stx]

hi

i have written a small database application using sql server. After testing my application on my pc everything works fine.
Now i copy my project to another computer also having vb.net installed (the same version as is installed on my pc). If i run my project there i always get an exception thrown when my sqldataadapter tries to fill a dataset.
the error message is 'unknown error' which doesn't tell me much.

Has anyone had the same problem or something like this?
Any help would be greatly appreciated because i'm becoming very despirate for the moment.

thnx

 

[stnkyminky]

Does pc #2 have permission to read from the db?

Also, in your try block do you have a catch for sqlexceptions? Not sure if the message will be detailed but worth a shot.

Scott
Programmer Analyst
<{{><

 

[stx]

hi stnkyminky

Yes pc2 has full permissions from the db.

SQLexceptions & innerexceptions doesn't give a more detailed description.

Thnx for replying.
I still haven't found the problem.
Any thoughts?

 

[stnkyminky]

can you provide the code for filling the ds?

Scott
Programmer Analyst
<{{><

 

[bassguy]

stinky try using this code for more clues.

try
yourdataadapter.fill(yourdataset)
catch ex as exception
msgbox(ex.tostring)
end try


I have found that this helps catch what may be simple mistakes

bassguy