Search results for query: *

I fixed this. I forgot the command.ExecuteNonQuery()

Oh I figured I needed to move this line inside the loop but it still does not work. Dim data As String() = regex.Split(line)

Hi can anyone check this to see if I did this right becausea im getting nothing inserted in my table. thanks my csv file looks like this into four columns: PAULK Pauly's Bar Paul Kimmel The Fat Man PAULK Pauly's Bar Paul Kimmel The Fat Man PAULK Pauly's Bar Paul Kimmel The Fat Man ALFKI...

OK now it gets passed the authentication but fails to update the databse: update summary Time: 08/18/2008 16:19:24.257 KB Number: KB921896 Machine: OSIT5 OS Version: Professional Service Pack 1 (Build 6001) Package Language: 1033 (ENU) Package Platform: x86 Package SP Level: 2 Package Version...

I ran this "select IS_SRVROLEMEMBER('sysadmin')" result looks like this: (no column name) 1 | 1

Can you post the ERRORLOG from when the upgrade is running? where do I find this?

Can you post the error message? "Your account information could not be verified. Press OK to return to authentication mode screen to determine reason for failure. For setup to verify your credentials the services must be startble, connectable. and you must be SQL server admin." Is it the...

Thanks but I am still getting an error during the authentication.

I am using a named Intsance. how do I do this? Try starting the SQL Server from a command prompt using the -c switch and then run the service pack installer.

yeah, its cascading. thanks anyway. I decided just to do 3 different reports which will suffice. But now i see. this will work if the parameters are static.

thanks. its just un clear on where to put this. do i do this in the selection expert under the formula selction? if so, this is what i did: if {?Type - WOTYPE2}="Default" then {TASKS.WOTYPE2} like "*" else {TASKS.WOTYPE2} = {?Type - WOTYPE2} it still forces the user to make a selection on the...

I am trying to update to sQL SP2 but I keep getting an error during the authentication. It says user could not be verified, for setup to verify credentails services must be started and connectable. It says Success in the status column for SQL database services so I dont understand why I am...

can you calrify that code a little better. what about param 2 or param3

I am doing a report that asks the user for 5 paramter values. (start date, end date, Type, subtype2, subtype3). Butit forces the user to select all paramter values. I also want to allow the user to be able to select just type. or type with subtype2 and without the subtype3 paramter but it wont...

actually i fixed.. thankx. a simple oversight

ok I got it but I have to log on as other user everytime. its not like xp where its my default logon username

yes, it isnt logging in to the domain. how can I fix that

the error I am getting is: Login failed for user 'username'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452) View products that this article applies to. it wont let me update with the service pack2 it tells me: my account could be verified...

I just installed SQL 2005 developer on a vista machine and my windows authentciation is not working? SQL server is configured for mix mode and I have shared memory, tcp/ip and named pipes enabled. The problem to me is when I log in to the server it has my username: "computer name\username"...

Yeah, teh test to column thing worked. thanks.