ASP.NET RSS ASP.NET RSS

Parameter is no valid

Please support our ASP.NET advertiser: Intel Parallel Studio Home
Reply
1 2 3

•
•
Join Date: Aug 2008
Posts: 1,160
Reputation: dickersonka will become famous soon enough dickersonka will become famous soon enough 
Solved Threads: 137
dickersonka dickersonka is offline Offline
Veteran Poster

Re: Parameter is no valid

 
0
  #11
Apr 7th, 2009
i'm not sure what you are meaning

the actual value? of what?
and what are you wanting to use for testing?
Custom Application & Software Development
www.houseshark.net
Reply With Quote Quick reply to this message  
•
•
Join Date: Apr 2008
Posts: 114
Reputation: ninjaimp is an unknown quantity at this point 
Solved Threads: 6
ninjaimp ninjaimp is offline Offline
Junior Poster

Re: Parameter is no valid

 
0
  #12
Apr 7th, 2009
we have been provided with a data dump of a postgre sql table into a .psv doc

the data holds informatin on images and the actual image is stored as binary. Now when you open this doc to look at the information i want to see how it compared to that of the data that would be stored in an sql image field.

the reason beimng in that the rouine i have that should open the image from the binary data and save it is failing in the previous errors i have reported and i can only put it down to how the data has been passed to us?

if that makes any sense at all
Reply With Quote Quick reply to this message  
•
•
Join Date: Aug 2008
Posts: 1,160
Reputation: dickersonka will become famous soon enough dickersonka will become famous soon enough 
Solved Threads: 137
dickersonka dickersonka is offline Offline
Veteran Poster

Re: Parameter is no valid

 
0
  #13
Apr 7th, 2009
why can't you just do an import into sql server without going code side?

also are you sure you mean a psv or csv?
Custom Application & Software Development
www.houseshark.net
Reply With Quote Quick reply to this message  
•
•
Join Date: Apr 2008
Posts: 114
Reputation: ninjaimp is an unknown quantity at this point 
Solved Threads: 6
ninjaimp ninjaimp is offline Offline
Junior Poster

Re: Parameter is no valid

 
0
  #14
Apr 7th, 2009
yes, its a pipe seperated value list

We have gone that route as we are still not sure if the data is correct. Would opening the data as text change the way that the binary information is displayed?
Reply With Quote Quick reply to this message  
•
•
Join Date: Aug 2008
Posts: 1,160
Reputation: dickersonka will become famous soon enough dickersonka will become famous soon enough 
Solved Threads: 137
dickersonka dickersonka is offline Offline
Veteran Poster

Re: Parameter is no valid

 
0
  #15
Apr 7th, 2009
opening it up wouldn't do anything, as long as you don't save it

have you tried to import inside management studio specifying the pipe, or doing something like this?

sql Syntax (Toggle Plain Text) 
  1. BULK INSERT MyTableName
  2.     FROM 'c:\mydata.psv' 
  3.     WITH 
  4.     ( 
  5.         FIELDTERMINATOR = '|', 
  6.         ROWTERMINATOR = '\n' 
  7.     )
Custom Application & Software Development
www.houseshark.net
Reply With Quote Quick reply to this message  
•
•
Join Date: Apr 2008
Posts: 114
Reputation: ninjaimp is an unknown quantity at this point 
Solved Threads: 6
ninjaimp ninjaimp is offline Offline
Junior Poster

Re: Parameter is no valid

 
0
  #16
Apr 8th, 2009
im running visual studio 2008 pro - is the management tool included with that?
Reply With Quote Quick reply to this message  
•
•
Join Date: Apr 2008
Posts: 114
Reputation: ninjaimp is an unknown quantity at this point 
Solved Threads: 6
ninjaimp ninjaimp is offline Offline
Junior Poster

Re: Parameter is no valid

 
0
  #17
Apr 8th, 2009
i've found out the reason - the data i have is in standard escape format and of course i need to convert this back to its binary equivilent.

Do you know of any built in methods that will take this text and convert it back to binary in either vb or c .net
Reply With Quote Quick reply to this message  
•
•
Join Date: Aug 2008
Posts: 1,160
Reputation: dickersonka will become famous soon enough dickersonka will become famous soon enough 
Solved Threads: 137
dickersonka dickersonka is offline Offline
Veteran Poster

Re: Parameter is no valid

 
0
  #18
Apr 8th, 2009
the management tool you need for the import is just sql management studio or even run it through code
did you try the bulk insert?

escape format meaning?
Custom Application & Software Development
www.houseshark.net
Reply With Quote Quick reply to this message  
•
•
Join Date: Apr 2008
Posts: 114
Reputation: ninjaimp is an unknown quantity at this point 
Solved Threads: 6
ninjaimp ninjaimp is offline Offline
Junior Poster

Re: Parameter is no valid

 
0
  #19
Apr 8th, 2009
Dont have access to SQL server at the moment and not sure if it would work with the sql express?

the data that has been provided is a table dump of a postgre sql table and the format is plain and uses standard escape sequence similiar to c or perl.

Now i need to convert that back to its binary equivilent.
Reply With Quote Quick reply to this message  
•
•
Join Date: Aug 2008
Posts: 1,160
Reputation: dickersonka will become famous soon enough dickersonka will become famous soon enough 
Solved Threads: 137
dickersonka dickersonka is offline Offline
Veteran Poster

Re: Parameter is no valid

 
0
  #20
Apr 8th, 2009
are you meaning all your double backslashes?

just run a replace on your escaped characters

ASP.NET Syntax (Toggle Plain Text) 
  1. Dim fileAsString As String = myString.Replace("\\", "\")
  2.  

i think this is how with vb, more familiar with csharp
Custom Application & Software Development
www.houseshark.net
Reply With Quote Quick reply to this message  
Reply
1 2 3

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the ASP.NET Forum
Thread Tools Search this Thread



.net activexcontrol advice ajax alltypeofvideos appliances asp asp.net bc30451 beginner bottomasp.net box browser button c# cac checkbox click commonfunctions control css dataaccesslayer database datagridview datagridviewcheckbox datalist deadlock deployment development dgv dialog dropdownlist dynamic dynamically edit embeddingactivexcontrol expose fileuploader fill findcontrol flash formatdecimal formview gridview gudi iframe iis javascript listbox login microsoft mono mouse mssql multistepregistration news novell numerical objects opera panelmasterpagebuttoncontrols radio redirect registration relationaldatabases reportemail rotatepage save schoolproject search security sessionvariables silverlight smartcard smoobjects software sql-server sqlserver2005 ssl suse textbox tracking treeview unauthorized validatedate validation vb.net video videos virtualdirectory vista visualstudio web webapplications webdevelopemnt webdevelopment webprogramming webservice xsl youareanotmemberofthedebuggerusers
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC