ETL and Data Integration tools - Modern ETL software for everyone

Hello All,

I am using DEWizard.dll in my Existing Application for export data from MS SQL Server 2005.

I have used the dll version 3.6.1.3 and read the API Referance pdf and Try to export the data from MS SQL server 2005. But I have got the error that is

"Cannot get list of fields for table Error: SQLConnect Failed: IM002 [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified."

I am used the following Code for the Export data.

DEWizardX1.ParseConnection = False
DEWizardX1.OperationType = otExport
'DEWizardX1.SourceConnectionEnabled = False
'DEWizardX1.TargetConnectionEnabled = False
'DEWizardX1.ShowSqlAfterPage = False
'DEWizardX1.ShowSqlBeforePage = False

DEWizardX1.ExportFileDelimeter = gDelimeter
DEWizardX1.ExportFileQualifier = gTextQualifier

With DEWizardX1
.ExportSourceType = dtSqlServer
.ExportSourceServerName = gServername
.ExportSourceDatabase = gDatabase
.ExportSourceUserName = gUserName
.ExportSourcePassword = gPassword
.ExportSourceTables = gTable
' .LoadFromFile (App.Path & "\myscript.txt")
.SqlBefore = "Select * from tblinvoice " & vbCrLf "go"
.SqlAfter = ""
.ExportDirectory = App.Path
.ExportFile = App.Path & "\myscript.txt"
.Execute
End With

But not export the data and GIve the Error which is written on the above.
Please Give me the step to export using the code. so i can used in my application.

Thanks

Thank you for the feedback
we will double check everything and get back to you.

Peter

Try commenting out those two lines first

.LoadFromFile (App.Path & "\myscript.txt")
.SqlBefore = "Select * from tblinvoice " & vbCrLf "go"

LoadFromFile loads the script with all connection details etc
You do not need it since you are setting everything programmatically
Sqlbefore/After is used to run DML not select statements

.ExportDirectory = App.Path
.ExportFile = App.Path & "\myscript.txt"

export file is the file you are saving the table data.

Mike

Thank To give the reply.

I have tried to give your way and try to load the configuration file that is give below.
=====================================
EXPORT

Datasource

SourceType=ACCESS
Server=
Database=
UserName=
Password=
Port=0
SourceFile=E:\Nikunj\Nikunj Projects\Matrix Solution\Matrix Solution\Database\IMEINumber.mdb
SourceDirectory=
SQL_SEPARATOR=
SourceIsTable=True
SourceTables=SendMessage
UseMask=False
Mask=
ShowSystemTables=False

Datatarget

Delimiter=
Quote=
LineTerminator={CR}+{LF}
ExportFile=
ExportDirectory=C:\Documents and Settings\admin\Desktop

SqlBefore


SqlAfter


=====================================

But it will not able to load the configuration from file. it is give the error: Failed to connect DSN:

Please suggest me for load the configuration from File.

Hello

Can you try version 3.6.4.3 please

If you are still having same problem we can build for you an example using MS Access

Peter

I Have Got the same problem again.

so please send me one example of MSACCESS.


Thanks