bb.donnay-software.com

Donnay Software Web Forums
It is currently Thu Jun 04, 2020 1:19 pm

All times are UTC - 7 hours




Post new topic Reply to topic  [ 19 posts ]  Go to page Previous  1, 2
Author Message
PostPosted: Wed Mar 07, 2012 3:21 am 
Offline

Joined: Wed Jan 27, 2010 10:25 pm
Posts: 354
Location: Berlin Germany
Hi,
NEVER create or modify a DBF with Excel, this will corrupt your DBF !!!
Look at Express\bin folder, there you find Rogers xdbu, which can create or edit DBF files.

_________________
_______________________
Best Regards
Wolfgang


Top
 Profile  
 
PostPosted: Wed Mar 07, 2012 5:12 am 
Offline

Joined: Wed Feb 22, 2012 2:55 am
Posts: 27
Wolfgang Ciriack wrote:
Hi,
NEVER create or modify a DBF with Excel, this will corrupt your DBF !!!
Look at Express\bin folder, there you find Rogers xdbu, which can create or edit DBF files.


Roger's xdbu just returns error same as cmd dbu:

Image

That's why I used Excel so you can see what happens
I didn't create nor modify DBF with excel I just use it to look/browse base cause I Double click DBF file and after warning me it opens it either corrupted or not.


Top
 Profile  
 
PostPosted: Wed Mar 07, 2012 8:50 am 
Offline
Site Admin
User avatar

Joined: Wed Jan 27, 2010 6:58 pm
Posts: 4127
Location: Boise, Idaho USA
The reason you are getting a corruption message with DBU is because you are trying to open SENDMAIL.DBF with the DBFNTX driver. The SENDMAIL.DBF file was created in IMSERVER.PRG with the FOXCDX driver. Open IMSERVER.INI and change FOXCDX to DBFCDX, then delete SENDMAIL.DBF and SENDMAIL.CDX so they will be created again.

_________________
The eXpress train is coming - and it has more cars.


Top
 Profile  
 
PostPosted: Thu Mar 08, 2012 12:08 am 
Offline

Joined: Wed Feb 22, 2012 2:55 am
Posts: 27
When I've changed Driver in xdbu it opens it without any problems

Mine IMSERVER.INI (There's no other IMSERVER.INI on my computer) looks like this:

Code:
[IMSERVER]
Port1=8001
;Port2=8080
;Port3=8081
HostAlias=Test
Domain=LocalHost

[MESSAGES]
TimeOut=10000
Days=100


Where should I put that driver preference?

Is the FOXCDX set as default driver? Because I didn't set no driver to creation of mine DBF and it's corrupted as well.
If so how to set driver (I always thought that DBFNTX and FOXCDX are just for Indexing)

BTW what's the difference between FOXCDX and DBFNTX (Why did you use FOXCDX only for SENDMAIL.DBF)


Top
 Profile  
 
PostPosted: Thu Mar 08, 2012 9:29 am 
Offline
Site Admin
User avatar

Joined: Wed Jan 27, 2010 6:58 pm
Posts: 4127
Location: Boise, Idaho USA
Sorry, I thought that the EMAIL group was already in the IMSERVER.INI. If it isn't there, then it is defaulted in the IMSERVER.PRG source code.

Add this to your IMSERVER.INI:

Code:
[EMAIL]
SMTPserver=gmail.com
DatabaseDbe=DBFCDX
UserId=me
Password=pass
Sender=me@gmail.com
Recipient=you@gmail.com
DatabaseName=SENDMAIL.DBF

_________________
The eXpress train is coming - and it has more cars.


Top
 Profile  
 
PostPosted: Fri Mar 09, 2012 2:20 am 
Offline

Joined: Wed Feb 22, 2012 2:55 am
Posts: 27
Now SENDMAIL.DBF is created with DBFCDX and I don't get error that it's corrupted, but now I get this error :P

Image

Djiber wrote:
BTW what's the difference between FOXCDX and DBFNTX (Why did you use FOXCDX only for SENDMAIL.DBF)


Top
 Profile  
 
PostPosted: Fri Mar 09, 2012 4:45 am 
Offline
User avatar

Joined: Thu Jan 28, 2010 12:59 am
Posts: 772
Location: Berlin, Germany
It maybe caused by a typo: There's a double-r in the word "server" in your path. ;)

_________________
Best regards,
Tom

"Did I offend you?"
"No."
"Okay, give me a second chance."


Top
 Profile  
 
PostPosted: Fri Mar 09, 2012 5:26 am 
Offline

Joined: Wed Feb 22, 2012 2:55 am
Posts: 27
Tom wrote:
It maybe caused by a typo: There's a double-r in the word "server" in your path. ;)


I'm afraid it's not typo :( I've just named my folder Serrver cause I didn't want to mess up Roger's files which I've put in Server xD

SENDMAIL.DBF is in the same folder as EXE, and there's no set path (It was working before I've changed driver and it's working when I change it back, but it doesn't work with DBFCDX)

My guess would be that it's set somewhere to browse/open it with FOXCDX, but my incompetence doesn't allow me to find it :(

And I still don't know the difference between drivers :(


Top
 Profile  
 
PostPosted: Fri Mar 09, 2012 5:50 pm 
Offline
Site Admin
User avatar

Joined: Wed Jan 27, 2010 6:58 pm
Posts: 4127
Location: Boise, Idaho USA
Quote:
And I still don't know the difference between drivers


You need to read the Xbase++ documentation about the Database Engine and the different data drivers.

_________________
The eXpress train is coming - and it has more cars.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 19 posts ]  Go to page Previous  1, 2

All times are UTC - 7 hours


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group