elliott einbinder

Does anyone know how to make the 'textcopy' utility use windows
authentication to connect to the database? I did what the help says to do,
where you leave username blank for it to use "trusted connection" but it
then tries to connect with a (null) username. I can't seem to get it to use
my currently logged in Windows user info and use Windows auth; it appears to
only want to use sql auth. we have purposely removed sql auth from our sql
server for security purposes. any ideas?

Thanks!

--
___________________
prelewd@earthlink.net

gert e.r. drapers

According to textcopy.exe -?

If you do not specify a /U login a trusted connection will be used.

TEXTCOPY Version 1.0
DB-Library version 8.00.194

Copies a single text or image value into or out of SQL Server. The value
is a specified text or image 'column' of a single row (specified by the
"where clause") of the specified 'table'.

If the direction is IN (/I) then the data from the specified 'file' is
copied into SQL Server, replacing the existing text or image value. If the
direction is OUT (/O) then the text or image value is copied from
SQL Server into the specified 'file', replacing any existing file.

TEXTCOPY [/S [sqlserver]] [/U [login]] [/P [password]]
[/D [database]] [/T table] [/C column] [/W"where clause"]
[/F file] [{/I | /O}] [/K chunksize] [/Z] [/?]

/S sqlserver The SQL Server to connect to. If 'sqlserver' is not
specified, the local SQL Server is used.
/U login The login to connect with. If 'login' is not specified,
a trusted connection will be used.
/P password The password for 'login'. If 'password' is not
specified, a NULL password will be used.
/D database The database that contains the table with the text or
image data. If 'database' is not specified, the default
database of 'login' is used.
/T table The table that contains the text or image value.
/C column The text or image column of 'table'.
/W "where clause" A complete where clause (including the WHERE keyword)
that specifies a single row of 'table'.
/F file The file name.
/I Copy text or image value into SQL Server from 'file'.
/O Copy text or image value out of SQL Server into 'file'.
/K chunksize Size of the data transfer buffer in bytes. Minimum
value is 1024 bytes, default value is 4096 bytes.
/Z Display debug information while running.
/? Display this usage information and exit.

You will be prompted for any required options you did not specify.


--
GertD@SQLDev.Net

Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2003 All rights reserved.

prelewd

thanks for the quick reply. unfortunately, I actually tried that, and
instead of using a "trusted connection" it tried to login using "(null)."
the only way I got it to work was to allow sql logins on my sql server and
then specify a login with textcopy, such as 'sa'. I don't like this
solution, but for some reason, it wouldn't properly use the trusted
connection, so I had to. if anyone has experienced the same thing I'm
referring to, and knows how to get around it, that would be great. I was
originally having the problem from a workstation connecting to the sql
server thru a vpn, so I tried to do it from the same pc where the sql server
is running, and the same problem happens there.

Thanks!

--
___________________
prelewd@earthlink.net

marc scheuner [mvp adsi]

Yes, it says do - but it doesn't follow its own do***entation. It will
still prompt for a user name and password, and won't accept anything
but an ******** SQL server login.

Marc

================================================== ==============
Marc Scheuner May The Source Be With You!
Bern, Switzerland m.scheuner(at)inova.ch