Copy error?

[stricknyn]

Hello all,

I am using the ado.net advantage provider to access a Advantage .adt file. The file is very large (about 2.5 gigs) and is called log.adt. Here is my code:

Dim conn As New AdsConnection("data source = \\Lombard13\TestSystems\Cobracs\; ServerType=local; TableType=ADT")
        'Dim conn As New AdsConnection("data source = C:\VistaCobra\; ServerType=local; TableType=ADT")
        Dim cmd As AdsCommand
        Dim reader As AdsDataReader
        'Dim iField As Integer
        Dim counter As Integer = 0

        Try

            'make the connection to the server 
            conn.Open()

            'create a command object 
            cmd = conn.CreateCommand()

            cmd.CommandText = "SELECT Log.* " & _
            "FROM Log " & _
            "INNER JOIN Co_Mast ON Log.Co_Code = Co_Mast.CO_CODE " & _
            "WHERE Co_Mast.CO_STATUS =  1"

            cmd.CommandTimeout = 800

            'execute the statement and create a reader to read the results 
            reader = cmd.ExecuteReader()

            'dump the results of the query to the console 
            While reader.Read()

                For iField = 0 To reader.FieldCount - 1
                    Console.WriteLine(reader.GetValue(iField))
                Next
                counter += 1
                Console.WriteLine(reader.Item(0))
            End While

            reader.Close()
            conn.Close()

        Catch ex As AdsException

            'print the exception message 
            Stop
            Console.WriteLine(ex.Message.ToString)
        End Try

When accessing over the file server (Dim conn As New AdsConnection("data source = \\Lombard13\TestSystems\Cobracs\; ServerType=local; TableType=ADT")) I can access it just fine and read it through the datareader object.

However, if I copy the file to my local machine and run the exact same process using its new location I get an exception:
{"Error 7200: AQE Error: State = HY000; NativeError = 7008; [iAnywhere Solutions][Advantage SQL][ASA] Error 7008: The specified table, memo file, or index file was unable to be opened. Table name: Log AdsCommand query execution failed."}

If I attempt to manually open the file on my local machine it fails saying
"An unknown error occured trying to access Log.adt" This leads me to believe it may be some issue when I copy the file over. I can open the one on the file server manually just fine.

Not sure if this issue occurs when I copy the file over, but is there maybe some other way I should copy this large file to my local PC?

Thanks,

Strick

[techgnome]

Are there any other files in the folder (the remote one, not your local copy) besides the adt file? The error seems to indicate that there is somekind of supporting file that's missing when you make the copy. It's also possible that there are extra files that are in a different directory on the server that also need to be copied over.

-tg

[stricknyn]

I thought this could be the case too. But there are other .adt files that are local that my code can access just fine. It's just this one file. The only real difference between this file and the others are the size.

Right now, I'm doing a very inefficient workaround which dramatically slows down the process. Since I'm able to read the file on the file share, I'm accessing it that way and getting the data. But Due to that location being in another state with a very thin bandwidth tunnel, it's 3 times as slow since I'm reading the file across the network.

My goal was to copy the file local and process it locally, but I can only open it on the file share.

Thanks,

Strick