Search results for query: *

Hi there, hope you can help me! i have lots of users generating reports in .rtf format and i wanted to create a viewer, web based, which will allow them to log on, select a report and view it. i am having a problem with the viewing part. the trouble is i cant assume the user has word...

wonderfull..... you are a star, a star for you. Russ

Hmm yes i agree that lmhosts would work, but i would have to add it on every client, and of curse you are right F1LBY it would come back and bite me. especially since this seems to be the whole point of wins. anyone any other ideas, i cant believe samba left this out it seems a fairly common...

HI there, i have changed my nt4 wins server to a samba server but i need to add static mappings so my print servers (dlink 303) can be resolved by name. any ideas on how to do this? Regards, Russ

Hi, I was wondering how i get gcc to work? i have the openserver dev kit, which works fine i have installed the version off the skunkware ftp site and it seems to be ok, then i tried to compile freetds so i could access some mssql servers and ./configure says i cant create binaries! so... i...

Thankyou MarkSweetland! it was indeed being truncated. it was my own stupid fault with a typo a new install of vb6 and i hadnt set option explicit to always be on and was adding two different strings in the cmd.execute and the correct two in the debug.print i would never have found it if you...

for debugging I am writing the sql statement out to a text file just before i execute it, so what you see is a cut and paste of the string. Also it works fine, if i paste it into query analyser! i am at a loss, i have been tearing my hair out for days now! Regards, Russ

Hi Mark, Now the message is "error near SELECT" what the heck am i doing wrong? an ive never seen that syntax (using select) but hey, thats not saying much ;-> Regards, Russ

Hi, I have a sql statement that doesnt work. the error is -2147217900 (error near '(') vb6 sp5, sql server sp3. the sql works when pasted into query analyser. ive tried single and double quotes square brackets/no square brackets round the fieldnames any ideas, its driving me insane?? Russ...

I have a DTS job that uses an odbc connection to get at data that resides on a samba(unix) share. the DTS job seems unable to access the share. how can i make sure it exists when i run the job?? regards, Russ

Ah I see! they are all there, they are probably failing because there are now lots of them. all the same!! ;-> thankyou for your prompt response a star for you. Russ

Hi, JayKusch no, how would i do that? where is it stored?

Hi, i have a dts package which i can execute and it works when i try to schedule it, i change the schedule and press ok. but when i go back into the schedule, its back at defaults. anyone know whats going on?

HI, im not sure if this is possible.... i want to store in a databse the name of a function that is to be run. when the user logs in the code looks in the database for that user, retrieves the function name and runs it. any ideas how to do this? Cheers Russ

Well. i suppose more detail is in order ;-> connection1 = connx odbc driver to powerflex data connection2 = sql server need to do the following:- select * from connection1.scanbox where scanned_date = curdate() and put the results in connection2.scanbox scanbox contains 500,000+ records...

HI there, i appear to be duplicating records as i import them using dts. what is the best way to stop this. i cant drop the table or truncate it as people are locking it. regards, Russ

HI, Please can you tell me how to do this :- DTS package input : connx ODBC for powerflex output : sql server 2000 source sql statement:- select * from scanbox where scanned_date = convert(char(10),getdate(),10) this wont work! how do i restrict the select based on the date field...

Hmm. bastien: the datasource will be remote, on a server. CClint: the reports are actually datadynamics activereports i wanted to keep the report, and its logic seperate from the menu structure. the problem is i will then need the menu program, the report exe, which asks the questions and...

hi, this is not so much a coding question as a concepts question :) the scenario:- i am designing a reporting system. the idea is that i will have a treeview holding the reports menu. when a user clicks a report, it will run a seperate vb program, which gets parameters and runs the report...

we used to get this all the time! read an article on ap lawrence' site and now we use netcat. doesnt happen anymore