Thanks Grasshopper for your reply..

Actually I've managed to solve the problem but i am gonna have a look at your attachments.

Thank you again.

I 've noticed it Grand..

thanks..

I am trying to connect to SQL Server 2000 (not to Sql Server Express) with Visual Basic 2005 Express Edition...

Thank you Grant.. I 'll take a look at your links..

Andras thank you for your reply.. I cant figure out the way you are describing me to connet to Sql..

Thanks for your reply

Well actually it is the first one. I export from Sap some tables to txt format. I want to read the contents of the txt files and...

Hi,

thanks for your reply. It is a select query

Thanks for your help David i will check it out....

Newbie me…!  

The error was generating...

thank you david

The varchar value i wanted to convert had the char ',' and that was the cause of  the problem. So i replace the ',' to '.' and the convert function...

I 've got the same error

Thank you , but unfortunately i don't have visual studio installed to my pc