I want to import data into IB 6.5 from a text file but I always get the
error message above.

I am using IB console 1.0.1 that comes with D7 (IB 6.5)

Can anyone help me?

Bill Todd wrote:
> Talk about poor page design. I scrolled down until I came to more 
> advertising and quit there. Thanks Kostas.
> 

Yes indeed! If they did it on purpose this is a rather silly "phishing" 
method!
But, I think this is irrelevant to the initial topic, so I'll  stop here.

Talk about poor page design. I scrolled down until I came to more 
advertising and quit there. Thanks Kostas.

-- 
Bill Todd (TeamB)
TeamB cannot answer questions received via email

That is strange. I have been to that site before and I can never see the 
answer to anything. IAC, thanks for explaining what you see there.

-- 
Bill Todd (TeamB)
TeamB cannot answer questions received via email

Just scroll the page down, don't click on the link

Bill Todd wrote:
> Interesting. When I click the link in your message I am taken to a page 
> at Experts Exchange with the following.
> ----------------------------------------
> Solution Title: How to insert & Update a blob from Vb
> asked by password on 06/09/2004 06:41AM PDT
> 
> 
> Column Name & there type
> Id = Numberic
> Notes = Blob Type Text
> 
> Insert into table (id,Notes) Values (1,"aaaaaaaaaaa")
> I get a error "Conversion error from string"
> 
> Please give a sample code
> Thanks
> 
> 
> Sign Up to See This Solution
> -----------------------------------------
> 
> When I click the "Sign Up to See This Solution" link I am taken to a 
> page with the price list for signing up.
> 

Strange because I see the full screen with all answers but I haven't any
account there:-)

Anyway the all answers from this link here (bad formatted because I pasted
from clipboard):
***************************************
Comment from BAlexandrov
Date: 06/10/2004 12:18AM PDT
 Comment

In Interebase you cannot pass string to Blob, in Firebird you can.
Correct handling of blobs is through parametrized query and passing the blob
with parameter.
more info here:
http://www.volny.cz/iprenosil/interbase/ip_ib_strings.htm

How you connect to IB from VB?

Bojidar Alexandrov

Comment from password
Date: 06/10/2004 12:55AM PDT
 Author Comment

Correct handling of blobs is through parametrized query and passing the blob
with parameter, how ?

Please give a example.
You can connect Ib using Zstyle Ibole Provider.

Accepted Answer from BAlexandrov
Date: 06/10/2004 01:41AM PDT
Grade: A
 Accepted Answer

Is this OLEDB Provider?

Something like:
Make command object with SQL text

Insert into table (id,Notes) Values (?,?)
command.parameters(0).value = 1
command.parameters(1).value = myblobvariable
command.execute();

Administrative Comment from kacor
Date: 07/01/2004 05:35AM PDT
 Administrative Comment


No comment has been added to this question in more than 21 days, so it is
now classified as abandoned.

I will leave the following recommendation for this question in the Cleanup
topic area:
   Accept: BAlexandrov {http:#11277217}

Any objections should be posted here in the next 4 days. After that time,
the question will be closed.

kacor
EE Cleanup Volunteer

Administrative Comment from modulo
Date: 07/05/2004 02:35PM PDT
 Administrative Comment

Forced accept

modulo
Community Support Moderator

Comment from password
Date: 07/16/2004 03:50AM PDT
 Author Comment

Hi,
Sorry for not replaying.
I was busy with my personnal problem.
As far as blob is concered, it has been solved.
thanks for you example.
***************************************
--
With best regards, Mike Shkolnik
EMail: mshkolnik@scalabium.com
http://www.scalabium.com

"Bill Todd"  wrote in message
news:4239a84f@newsgroups.borland.com...
> Interesting. When I click the link in your message I am taken to a page at
> Experts Exchange with the following.
> ----------------------------------------
> Solution Title: How to insert & Update a blob from Vb
> asked by password on 06/09/2004 06:41AM PDT
>
>
> Column Name & there type
> Id = Numberic
> Notes = Blob Type Text
>
> Insert into table (id,Notes) Values (1,"aaaaaaaaaaa")
> I get a error "Conversion error from string"
>
> Please give a sample code
> Thanks
>
>
> Sign Up to See This Solution
> -----------------------------------------
>
> When I click the "Sign Up to See This Solution" link I am taken to a page
> with the price list for signing up.
>
> --
> Bill Todd (TeamB)
> TeamB cannot answer questions received via email
>
> Mike Shkolnik wrote:
>
> > Bill,
> >
> > link opened for me without any payment. I found this link in Google...
> > So what do you mean?
> >
> > --
> > With best regards, Mike Shkolnik
> > EMail: mshkolnik@scalabium.com
> > http://www.scalabium.com
> >
> > "Bill Todd"  wrote in message
> > news:423992ae$1@newsgroups.borland.com...
> > > Posting a link that someone must pay to see is not very helpful. :)
> > >
> > > --
> > > Bill Todd (TeamB)
> > > TeamB cannot answer questions received via email
> > >
> > > Mike Shkolnik wrote:
> > >
> > > > http://www.experts-exchange.com/Databases/Interbase/Q_21018999.html

Interesting. When I click the link in your message I am taken to a page at 
Experts Exchange with the following.
----------------------------------------
Solution Title: How to insert & Update a blob from Vb
asked by password on 06/09/2004 06:41AM PDT


Column Name & there type
Id = Numberic
Notes = Blob Type Text

Insert into table (id,Notes) Values (1,"aaaaaaaaaaa")
I get a error "Conversion error from string"

Please give a sample code
Thanks


Sign Up to See This Solution
-----------------------------------------

When I click the "Sign Up to See This Solution" link I am taken to a page 
with the price list for signing up.

-- 
Bill Todd (TeamB)
TeamB cannot answer questions received via email

Mike Shkolnik wrote:

> Bill,
>
> link opened for me without any payment. I found this link in Google...
> So what do you mean?
>
> --
> With best regards, Mike Shkolnik
> EMail: mshkolnik@scalabium.com
> http://www.scalabium.com
>
> "Bill Todd"  wrote in message
> news:423992ae$1@newsgroups.borland.com...
> > Posting a link that someone must pay to see is not very helpful. :)
> >
> > --
> > Bill Todd (TeamB)
> > TeamB cannot answer questions received via email
> >
> > Mike Shkolnik wrote:
> >
> > > http://www.experts-exchange.com/Databases/Interbase/Q_21018999.html

Bill,

link opened for me without any payment. I found this link in Google...
So what do you mean?

--
With best regards, Mike Shkolnik
EMail: mshkolnik@scalabium.com
http://www.scalabium.com

"Bill Todd"  wrote in message
news:423992ae$1@newsgroups.borland.com...
> Posting a link that someone must pay to see is not very helpful. :)
>
> --
> Bill Todd (TeamB)
> TeamB cannot answer questions received via email
>
> Mike Shkolnik wrote:
>
> > http://www.experts-exchange.com/Databases/Interbase/Q_21018999.html

Posting a link that someone must pay to see is not very helpful. :)

-- 
Bill Todd (TeamB)
TeamB cannot answer questions received via email

Mike Shkolnik wrote:

> http://www.experts-exchange.com/Databases/Interbase/Q_21018999.html

See the answer:
http://www.experts-exchange.com/Databases/Interbase/Q_21018999.html

--
With best regards, Mike Shkolnik
EMail: mshkolnik@scalabium.com
http://www.scalabium.com

"Dave Roberge"  wrote in message
news:42386d7a$1@newsgroups.borland.com...
> I want to import data into IB 6.5 from a text file but I always get the
> error message above.
>
> I am using IB console 1.0.1 that comes with D7 (IB 6.5)
>
> Can anyone help me?
>
>

Is the text file fixed length or delimited? If the file is delimited what 
is the delimiter and what is the quote character?

How are you trying to import the file?

A much more detailed explanation of what you are doing to produce the 
error would be very helpful.

-- 
Bill Todd (TeamB)
TeamB cannot answer questions received via email