MS SQL Server load error

gomez · Post by **gomez** » Fri Nov 03, 2006 12:37 pm

Hi
I am trying to use MS Bulk Load stage to load 6 million plus records from a sequential file. Underlying database is SQL Server 2000 on a different server machine than the DataStage Server.
I have created a DSN with SQL server driver and passed it to the properties
I get the following error
Internal error: IDBInitialize->Initialize() failed.
Please help
Thanks

gomez · Post by **gomez** » Fri Nov 03, 2006 5:54 pm

I tested the DSN connection to the SQL server database using odbcping and it connected successfully. So there is no problem with the DSN configuration.
Any pointers please?

satyakunta · Post by **satyakunta** » Fri Nov 10, 2006 1:21 pm

gomez wrote:I tested the DSN connection to the SQL server database using odbcping and it connected successfully. So there is no problem with the DSN configuration.
Any pointers please?

Try hardcoding the properties.Dont use DSN
Server Name: XXXX (Physical Server Name)
Database Name:XXXX (DB name on the server)
user Name:XXXXX
Password:XXXXX

gomez · Post by **gomez** » Mon Jan 08, 2007 4:06 pm

Thanks Satyakunta
I tried the same. It works. Thanks for the help

gomez · Post by **gomez** » Mon Jan 08, 2007 4:09 pm

Another observation on this. I had to provide A SQL Server Authentication in order to make MS SQL Server Bulk Load work. Windows NT Authentication credentials did not work with this stage