yep .

finally i have created a third sql server database , imported data into from the linked firebird database,

than run tablediff with the two SqlServer dbs .

and it seems to...

finally i have used ibprovider, i didn't know that there is a "lite" free version . (maybe and hopefully it's enough for me)

first try and everything work like expected...

i am not using the ibprovider but the ODBC provider from here

http://www.firebirdsql.org/en/odbc-driver

and everything is 64bits

so i have created an odbc datasource with odbcad32 which is in SysWOW64...

Fixed !

after a "second" reboot the server start without problem .....

didn't understand why

thanks you very very match

already tried, but i will try one more time

i will be back !

okaya okay

ps : i am a beginer on sql server

here the content of the errorlog file

2012-11-26 14:49:03.61 Server Microsoft SQL Server 2008 (SP1) -...

yes i want to use this in a web application used by many users

so each user is on his machine/browser ...

an important thing to add,

i want to use the temp...

thanks guys !

i think that i have found what was wrong in my script

the date format was DD.MM.YYYY , it should be MM.DD.YYYY

so date like 01.01.1984 was insert fine unlike dates like...

this script is executed only one time to populate a large table ,

so if i understand the body of the stored procedure may look like :

try

execute the large number of...

i will tell you the whole story :

i have a desktop application that use firebird

i am migrating some parts of this application to the web using sql-server database since i...

this thing want to kill me !

i have created a table with the exact SP output parameter

then i tried this :

INSERT INTO tmp_spvisana

EXEC SPVISANA

convert(datetime, 'Jul 1 2011 11:29AM',...

thanks bill,

i will try and keep you informed

can you clarify...

the udf is inside a dll and probably written in c++ or delphi ... lol