Notices
Computer & Technology Related Post here for help and discussion of computing and related technology. Internet, TVs, phones, consoles, computers, tablets and any other gadgets.

ODBC Problems . . .

Thread Tools
 
Search this Thread
 
Old 06 September 2004, 04:23 PM
  #1  
DJ Dunk
Moderator
Support Scoobynet!
Thread Starter
iTrader: (5)
 
DJ Dunk's Avatar
 
Join Date: Nov 2001
Location: Not all those who wander are lost
Posts: 17,863
Received 0 Likes on 0 Posts
Default ODBC Problems . . .

This is driving me insane

OS: Windows 2000
Software: Zebra Bar-One v5
Hardware: Zebra 90XiII Printer

I'm trying to print my barcodes from a list created orignally in Excel. I have tried text, various Excel revisions, MS Access, and DBF. The problem is that its not reading my list correctly.

For example it should print: 1, 2, 3, 4, 5, 1, 2, 3, 4, 5
But its printing (randomly): 1, 2, 2, 4, 5, 1, 1, 1, 1, 1, 1

Its totally getting on my tats now. Anyone have any suggestions before I insert my foot rapidly into the side panel ?

Thanks,
Dunk
Old 06 September 2004, 04:31 PM
  #2  
GaryK
Scooby Regular
 
GaryK's Avatar
 
Join Date: Sep 1999
Location: Bedfordshire
Posts: 4,037
Likes: 0
Received 0 Likes on 0 Posts
Default

Dunk,

Difficult to say without seeing the file (you can PM me it if you like) and can then try and determine which driver is best for the job

cheers

Gary
Old 06 September 2004, 04:40 PM
  #3  
DJ Dunk
Moderator
Support Scoobynet!
Thread Starter
iTrader: (5)
 
DJ Dunk's Avatar
 
Join Date: Nov 2001
Location: Not all those who wander are lost
Posts: 17,863
Received 0 Likes on 0 Posts
Default

Originally Posted by GaryK
Dunk,

Difficult to say without seeing the file (you can PM me it if you like) and can then try and determine which driver is best for the job

cheers

Gary
Thanks Gary.

Its a very straightforward file. It looks like:

BARCODES
AB01AAZ001
AB01AAZ002
AB01AAZ003
AB01AAZ004
AB01AAZ005
AB01ABZ001
AB01ABZ002
AB01ABZ003
AB01ABZ004
AB01ABZ005
etc . . .

. . . and has just 590 rows. It used to work on my NT4 machine using the DBFIII driver, but on my new one it just won't have it.

Let me know if you need any more info.

Many thanks,
Dunk.
Old 06 September 2004, 04:52 PM
  #4  
GaryK
Scooby Regular
 
GaryK's Avatar
 
Join Date: Sep 1999
Location: Bedfordshire
Posts: 4,037
Likes: 0
Received 0 Likes on 0 Posts
Default

Dunk,

Are you using excel to view it? Trouble is with excel it tries to be too clever, on many occassions a humble CSV file in notepad appears totally different in excel. I would need to see the file if thats possible, a DBase 3 file should be able to be read in excel even using a DB4 driver.

cheers

Gary
Old 06 September 2004, 04:58 PM
  #5  
DJ Dunk
Moderator
Support Scoobynet!
Thread Starter
iTrader: (5)
 
DJ Dunk's Avatar
 
Join Date: Nov 2001
Location: Not all those who wander are lost
Posts: 17,863
Received 0 Likes on 0 Posts
Default

I created it originally in Excel, then saved it as text. Viewed in Notepad, looks fine.
Also tried saving from Excel to DBF.

I'm calling the file from Zebra Bar-One, but I suspect that its ODBC that causing the probs.

I'll drop you a PM to mail the file over.

Thanks for your help,
Dunk
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
Abx
Subaru
22
09 January 2016 05:42 PM
PetrolHeadKid
Driving Dynamics
10
05 October 2015 05:19 PM
T.K
General Technical
10
02 October 2015 11:35 AM
the shreksta
Other Marques
26
01 October 2015 02:30 PM
minguela
Wheels And Tyres For Sale
0
29 September 2015 11:28 AM



Quick Reply: ODBC Problems . . .



All times are GMT +1. The time now is 12:12 AM.