Hi,

I have to use VB.NET to call API to get Deleted Accounts.

Can somone please help me with the code?

I'm new to VB.NET and salesforce.com API.

Thanks,

Omshi.

Hi,

I'm newbie to salesforce.com.

I'm trying to export data from salesforce.com to SQL Server 2005 through

the Apex Data Loader.

When I run the process through command line I get this error:

FATAL [databaseExportAccountVeryShort] controller.Controller createDao (Controller.java:186) - Error creating data access object

Here is my database-conf.xml:

<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
  <bean id="dbDataSource"
      class="org.apache.commons.dbcp.BasicDataSource"
      destroy-method="close">
    <property name="driverClassName" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
    <property name="url" value="jdbc:sqlserver://Localhost:1433;databaseName=MyDatabase;"/>
    <property name="username" value="MyUser"/>
    <property name="password" value="MyPassword"/>
  </bean>
  <bean id="Account_DataLoader"
      class="com.salesforce.lexiloader.dao.database.DatabaseConfig"
      singleton="true">
    <property name="sqlConfig" ref="insertAccountVeryShort"/>
    <property name="dataSource" ref="dbDataSource"/>
  </bean>
  <bean id="insertAccountVeryShort"
      class="com.salesforce.lexiloader.dao.database.SqlConfig" singleton="true">
    <property name="sqlString">
        <value>
            INSERT INTO dbo.Account_DataLoader (Id,Account_Open_Date__c)
            VALUES (@Id@, @Account_Open_Date__c@)
        </value>
    </property>
    <property name="sqlParams">
        <map>
            <entry key="Id" value="java.lang.String"/>
            <entry key="Account_Open_Date__c"  value="java.lang.String"/>
        </map>
    </property>
  </bean>
</beans>

I have a matching part in process-conf.xml with dataAccess.type=databaseWrite

and in my command line the process name is insertAccountVeryShort.

Can anyone help me with that?

Thanks,

Omshi.