November 26, 2002 at 11:54 pm
Hi.
I have an VB exe that executes procs from a SQL DB via bcp to dump the query results into text files. It doesn't work on client machines, these machines do not have MS SQL installed. Can anyone help me here. I used BCP instead of ADO becuase it makes my app asynchronous. I din't use DTS because my procs make use of # tables and DTS does not like them
Kudah
November 27, 2002 at 2:26 am
You will need to install the client tools to use bcp.
You could hack it and start by copying bcp and then see what happens
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
November 27, 2002 at 2:31 am
Hi, Tnx for that, however it is not company policy to have SQL Server installed onto client machines, so which DLLs would I need to ship my app with inorder for BCP to work where there is NO SQL Server installed.
Regards.
quote:
You will need to install the client tools to use bcp.You could hack it and start by copying bcp and then see what happens
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
November 27, 2002 at 3:36 am
I never tried, so you will have to test.
But I ran dependency walker on bcp and the only DLL, that was not part of the OS was c:\winnt\system32\sqlunirl.dll
There might be dynamic linked DLL's. You can see those with the filemonitor from sysinternals. You can download this freeware program from http://www.sysinternals.com/ .
Joachim.
November 27, 2002 at 7:48 am
No, do not install SQL Server just the CLient tools using custom install. Yopu can choose not to install EM and QA in that situation I believe but still have bcp. This way you do not have to figure out the DLL mess to pull ands register.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply