Hi,
I have a table in the database and I want to insert the values into this table by using JavaScript. Does anyone know how to execute the Sql stored procedure using Javascript.
Thanks
ssrirao
Last Activity: Sep 25 '07, 09:31 AM
Joined: Nov 30 '06
Location:
-
Executing MS Sql Stored Procedure Using JavaScript
-
Microsoft JET Database Engine
When I try to Export data from a table into a locally residing Microsoft Excel, using DTS Import/Export Wizard.
I get the following error Message
Error Source: Microsoft JET Database Engine
Error Description: Not a valid password.
Context: Error during initialization of the provider.
Can anybody help me in solving the issue
--------------------------------------------------------------------------------... -
ssrirao started a topic Import Excel Spreadsheet (Residing in Internet) Data into SQL Server Database Tablein SQL ServerImport Excel Spreadsheet (Residing in Internet) Data into SQL Server Database Table
There is an Excel Spreadsheet containing data, residing in an internet site.
It’s very easy to Import data from a local Excel Spreadsheet into SQL Server Database Table using DTS.
But in my case the Excel spreadsheet resides an internet site which has a static name (Example xyz.xls) but varying data inside it.
The spreadsheet contains three columns a, b, c and data below it.
Only data get updated weekly
... -
Thanks,
Srinidhi Rao -
Thanks in Advance,
Srinidhi S. RaoLeave a comment:
-
Do u mean the "file access" ?
We have the file access! The file was created and modifed by us in the remote system. Do u think of any IIS problem? As of now there is no IIS installed in these systems.
Regards,
Srinidhi S. RaoLeave a comment:
-
DTS Package Execution (From Job)
Hi,
We have DTS package which imports data from an Excel file into an SQL Server 2000 table. The DTS package runs fine when exectued from SQL Server Enterprise Manager, but when we run the Package from a Job it executes when the excel file is in the local drive. The execution of the package fails when the excel file resides on a different Computer shared drive.
We get the following error message.
\\CompName\Shar edDrive\ExcelFi le.xls... -
This gives the error:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet. OLEDB.4.0' reported an error. Authentication failed.
[OLE/DB provider returned message: Cannot start your application. The workgroup information file is missing or opened exclusively by another user.]
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet. OLEDB.4.0' IDBInitialize:: Initialize returned 0x80040e4d: Authentication...Leave a comment:
-
Thanks....this sovled my problem.
What is the solution if the .mdb Access file resides in a unix server.Leave a comment:
-
I dont want to import the data into MS SQL SERVER.
My MS Access tables are very big containing millions of records.
(Problem with importing: Table space will exceed the disk space!, so no question of importing)
Without importing the data into Sql Server.
How, my procedure can refer the 10 MS Access tables as source and put the resultant value into 2 MS Sql Server tables?
Or is there any alternative?Leave a comment:
-
1) I have a ms access 2000 database with tables a, b, c, d, e, f, g, h, i, j (10 tables)
2) I have 2 ms sql server 2000 procedure which retrieves data from all these tables, does some calculations, and insert or updates the rows in ms sql server table x and y
3) I have 2 ms sql server 2000 tables
The procedure works perfectly if these tables are ms sql server table and if I execute those procedures manually (i.e. execute...Leave a comment:
-
Note: Ms Sql Server 2000Leave a comment:
-
Dts (ms Access To Ms Sql Server)
hi,
I have 10 tables in ms access.
currently what i am doing is ...
1) import data into ms sql server, hence creating 10 tables
2) i have 2 procedures which does some calculations (basically consolidation of data) based on 10 tables. And insert data or update data into 2 tables.
Can i automate this etl process..
take data from 10 ms access tables
consolidate and put the data into 2 ms sql... -
thanks ....this worked fasterLeave a comment:
-
Excel to Powerpoint
I have a report output, which is in excel, it looks like this
------------------------
HEADING in a1
SUBHEADING in a2
DATA-LINE1 i.e. from a3:L3
DATA-LINE2 a4 to L4
DATA-LINE3 a5 to L5
DATA-LINE4
DATA-LINE5
DATA-LINE6
.
.
DATA-LINE100
I have written a macro which converts excel to ppt. But i am facing problem in formatting.
... -
thanks...
there is one case in which i have to use cursor
I have to get a unique value y from table x,
insert 10 values for each value of y into table a.
so a procedure with,
a cursor to get the value from table x
cursor1 = select y,z from x
while loop till @@fetch_statu = 0
{
insert into a (b,c) values (values from cursor1,c)
c++
if c = 10
set c=1
...Leave a comment:
-
Improving the Performance (Millions of Records!)
Table1
--------------------------------------------------------
a(varchar) | b(varchar) | c(varchar) | d(float)
---------------------------------------------------------
has value | has value | null | has value
---------------------------------------------------------
There are arround 13 million records in this table.
The combination of a...
No activity results to display
Leave a comment: