pana la urma incerc sa fac apeland o procedura stocata:
CREATE
PROCEDURE [dbo].[Insert_DBF]
(
@Fisier varchar(10))
AS
DECLARE
@SqlToRun NVARCHAR(MAX)
SET
@SqlToRun = N'INSERT INTO TableTest
(contract
,titular
,data_incas
,nr_rata
,data_scad
,total
,anuitate
,rata
,dobinda
,penaliz
,bon
,avans
,rezerva
,restanta
,integral)
SELECT
convert(varchar(20),convert(numeric(26,0),contract))
,titular
,data_incas
,nr_rata
,data_scad
,total
,anuitate
,rata
,dobinda
,penaliz
,bon
,avans
,rezerva
,restanta
,integral
FROM OPENROWSET(
''MSDASQL'',
''Driver={Microsoft dBase Driver (*.dbf)};DBQ=C:\TMP\'',
''SELECT * FROM '
+ @Fisier + ''')'
exec
(@SqlToRun)
go
si o execut astfel:
exec Insert_DBF_to_CREDISSON_PMT 'R0680507'
la mine local merge f bine fara nici o problema dar cand rulez pe live
primesc eroarea:
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "MSDASQL" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)".
chiar nu-mi dau seama de la ce poate fi,vreun sfat?
multumesc.
alex.