I
IMRAN
I have created a component which parses some flat
files and stores in Sql database. Now I want to move
that COM object to database server.
Now the scenario will be like this :
1) ASP page will get the file from the client
2) Then ASP page will call the stored procedure
alongwith the file data as parameter.
3) Store procedure will store that file on local hard disk
of databa server and will call the com object passing
the file path with name to it.
How can I pass the file to sql server ?
I am thinking about passing it as binary data.
Please advise !
files and stores in Sql database. Now I want to move
that COM object to database server.
Now the scenario will be like this :
1) ASP page will get the file from the client
2) Then ASP page will call the stored procedure
alongwith the file data as parameter.
3) Store procedure will store that file on local hard disk
of databa server and will call the com object passing
the file path with name to it.
How can I pass the file to sql server ?
I am thinking about passing it as binary data.
Please advise !