Empty Error Message when trying to pull Database with RDA

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello,

I try to pull some tables from the SQL Server 2000 to the SQL Mobile Server 2005.

Everything works fine with the first 6 Tables, but I can not pull the last Table.

I do not have any idea about what could be wrong. Are there any restrictions to the Server? I look at the Table but can not find any special Column or Key or something. The Table has 700 rows.

I use Visual Studio 2005 (VB.net) and the OS of the handheld is WinCE5.0.

After pull the last Table an exception is thrown.

Here are the Exception-Informations :
Errors
Count: 1
item (0):
Message: ""
NativeError: 0
ErrorParameters: "" (3 Times)
NumericErrorParameters: 0(3 Times)
Source: "Microsoft SQL Server 2005 Mobile Edition"

As you can see, there are no Error Messages. As above said the code that I used is working fine with 6 other Tables.

Here is the code:

Public Function RDAPull(ByVal URL As String, _
ByVal Login As String, ByVal Password As String, _
ByVal LocalConn As String, ByVal LocalTable As String, _
ByVal SQL As String, ByVal ServerConn As String, _
ByVal TrackOption As System.Data.SqlServerCe.RdaTrackOption, _
ByVal ErrorTable As String) As String
Dim res As String = ""
Dim rda As New System.Data.SqlServerCe.SqlCeRemoteDataAccess(URL, _
Login, Password, LocalConn)
Try
rda.Pull(LocalTable, SQL, ServerConn, TrackOption, ErrorTable)
Catch sqlex As System.Data.SqlServerCe.SqlCeException
res = sqlex.Errors(0).Message.ToString
Catch ex As Exception
res = ex.Message
Finally
rda.Dispose()
End Try
Return res
End Function

'-> this works fine
RDAPull(Einstellungen.GetRDAInternetUrl, "", "", _
Einstellungen.GetLocalConnectionString, "SD_ArtStamm", _
"SELECT * FROM dbo.SD_ArtStamm", _
Einstellungen.GetOLEDBConnectionString, _
Data.SqlServerCe.RdaTrackOption.TrackingOff, _
"rda_SD_ArtStamm_Errors")

'-> this don't work
RDAPull(Einstellungen.GetRDAInternetUrl, "", "", _
Einstellungen.GetLocalConnectionString, "SD_ArtZusatz", _
"SELECT * FROM dbo.SD_ArtZusatz", _
Einstellungen.GetOLEDBConnectionString, _
Data.SqlServerCe.RdaTrackOption.TrackingOff, _
"rda_SD_ArtZusatz_Errors")

I don't know what to do. Can anybody help me?

Thank you,

Christian Herzog
.

Relevant Pages

  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Web Part and Access database
    ... I dont know if it is possible to connect to access,but you can download SQL ... Server Error in '/Webparts' Application. ... The connection string specifies a local Sql Server Express instance ... String user, String password, Boolean trusted, String connectionString) ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: SQL 2000 and MSDE/Express/Compact edition..
    ... What is does is downloads .Net Framework and SQL Server Express if they are not installed and then configures SQL Server as a subscriber. ... string DotNetFramework2Location = ... LogMe("Creation of Replication Account failed."); ...
    (microsoft.public.sqlserver.replication)
  • Using ASP.NET to login to SQL Server 2005 Database
    ... Windows Server 2003 Enterprise Edition SP2 ... When I click the login box, I want asp.net to check the SQL ... useFailoverPartner, Boolean& failoverDemandDone, String host, String ...
    (comp.databases.ms-sqlserver)
  • Re: Executing SQL DTS Package from Access
    ... Does the DTS package run correctly when you run it manually through SQL ... Microsoft OLE DB Provider for SQL Server ... Dim oPKG As DTS.Package, oStep As DTS.step ... Dim sServer As String, sUsername As String, sPassword As String ...
    (microsoft.public.access.formscoding)