Community Reputation

About saprouzy

Contact Methods

Hello there, I have many VB6 applications that connect to either sql or oracle databases using crystal reports 7.5. what i have noticed is that, after printing the report and closing it, if the application isn't closed, the connection between the report and the database isn't released. how can i solve this prob. Thanks

Hey there, i have a question concerning ADO programming in VB if i have this line of code: myDB.execute "update tableX set values x=1 , y = 2 where some condition", RecordsAffected this would return the records affected by the query in the variable RecordsAffected. my question is, if i don't put the parameter RecordsAffected , does the call still returns the that number? to be more clear in context: i have a remote server and i want to minmize the traffic as much as i can, so if by removing RecordsAffected i don't get a repsonse back again i would remove it, if the response is returned even if it's removed i'll keep it. thanks.

hey thx for the replies, i did my search and what i need is a twain ocx but i didn't find any that is freeware if anyone knows a good site for ocx control where i might find such thing, please let me know thanks

"Provider = MSDAORA;User ID=myuser;Password=mypwd;Data Source=myserver;DATABASE=mydb;" hey there, am using this DSNless conenction string to connect to an oracle db is there a way to set the server name instead of the service name (ie: oracle.world) in the Date Source field. thanks.