×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

.Net and interbase connection

.Net and interbase connection

.Net and interbase connection

(OP)
Hi all,
I have a c#.net form that opens a dialog box to enable a user to point to an interbase .gdb. Sadly this OpenFile() action seems to create a lock on the .gdb file causing a log error
SQLCODE=-902
Error while trying to open file
unknown win32 error 32
ibcode=isc_io_error

when my app goes on to process the file. The process sends a path variable (path/file user selects in dialog) to a sql2000 DTS package which uses LCPI_Provider (full version) to copy Interbase gdb to sql2000. The dialog box object is destroyed after assigning the path name to string var and before the DTS package attempts to access the gdb. Also tried openning readonly.

I've done a bit of research into this and things seem to point to a readonly flag being set somewhere when the openfile dialog is used. This problem NEVER occurs when you type the path into the text field on the form, only when you select it with the openfile dialog. I even harcoded path literals into the app, used the fileopen dialog (which was just a dummy call) and it falls over. I must stress that the dialog box works for other file types such as .txt or .dat when importing csv files. Only the gdb files.

I found two web sources (1 french) that cite similar problems but with no solution, although one mentioned using an alias but didn't elaborate.

I have checked ibserver license and that is ok. 6 users.
The players
Ibserver 5.0
Sql Server 2000
LCPI_Provider in conjunction with DTS
.Net framework 1.1.4322.0
vs.NET 2003 Enterprise

As I said the app/process does as it's supposed to do only when the openfile dialog is NOT used. I've checked the path name, returned by openfile dialog,  and the path is exactly as it should be.

I was wondering if anyone one had similar experiences and whether there was a work around. I can use an .ini file to store the path or just hard code it but I'd like to make the app a bit more versatile.

Many thanks for your efforts. Tek-Tips is brilliant!
regards
Anthony Lawrence

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close