I Need code to import data from third party program

  • Thread starter Thread starter moshe via AccessMonster.com
  • Start date Start date
M

moshe via AccessMonster.com

I have a advantage database that runs for a POS system, and I want that my
access database should continuously import data from this database, but I
can't find any way how to do this, I'm completely out of advantage programing.

could any one help me with the code to write, or direct me to a library DLL
that should give me the possibility to do it?
Thanks in advance.
 
Thanks john for your help.
I have downloaded the ODBC Driver for advantage database but when trying to
connect i get a error.
"Unable to load the Advantage ODBC Setup DLL (adsset.dll)."
I searched my computer for adsset.dll and i found that i have it installed
probably in the right folder.
could you please help me set it up? I'm new at ODBC.
Thanks again

John said:
You need to obtain and install an ODBC driver for the Advantage
database.
I have a advantage database that runs for a POS system, and I want that my
access database should continuously import data from this database, but I
Click to expand...
[quoted text clipped - 3 lines]
that should give me the possibility to do it?
Thanks in advance.
Click to expand...
Click to expand...
 
i got the answer so far my self.
i pasted the adsset.dll to system32 and the system folder now i'm getting a
error when trying to view the linked table i'll get back if i'll be unable to
solve it my self.
Thanks john for your help.
I have downloaded the ODBC Driver for advantage database but when trying to
connect i get a error.
"Unable to load the Advantage ODBC Setup DLL (adsset.dll)."
I searched my computer for adsset.dll and i found that i have it installed
probably in the right folder.
could you please help me set it up? I'm new at ODBC.
Thanks again
You need to obtain and install an ODBC driver for the Advantage
database.
Click to expand...
[quoted text clipped - 6 lines]
Click to expand...
 
as i wrote i got the connection but when i try to open the table i got the
following error.
ODBC--call failed

[Extended Systems][Advantage SQL][ASA] Error: 7200: AQA Error: State = 42000;
NativeError =2228; [Extended Systems][Advantage SQL Engine]Invalid viiew
definition: Items. unexpected token after the view statement. (#7200)

there is a help button on the msgbox the help give me the following message.

ODBC – call failed. (Error 3146)

Using an ODBC connection, you tried to perform an operation on data in an
ODBC data source. This error may occur when the ODBC data source is on a
network drive and you are not connected to the network. Make sure the network
is available, and then try the operation again.


the connection is on a network but the network is available i also tryed
creating a database on the network computer but i got there the same error.
if you know what could solve the problam please help thanks.

Thanks john for your help.
I have downloaded the ODBC Driver for advantage database but when trying to
connect i get a error.
"Unable to load the Advantage ODBC Setup DLL (adsset.dll)."
I searched my computer for adsset.dll and i found that i have it installed
probably in the right folder.
could you please help me set it up? I'm new at ODBC.
Thanks again
You need to obtain and install an ODBC driver for the Advantage
database.
Click to expand...
[quoted text clipped - 6 lines]
Click to expand...
 
Sorry, Moshe, I've no experience at all with Advantage and not much
with ODBC drivers. I've checked Carl Prothman's Connection Strings
site (my usual refuge) and there's some information about using
Advantage with OLE DB, but seemingly nothing about the ODBC driver.
Maybe the OLE DB stuff will give you a hint.
(http://www.carlprothman.net/Default.aspx?tabid=81)

One thing I'd try is to access some other data source via ODBC, to
prove that the basic ODBC setup on your computer is working. Assuming
it is, the problem is likely to be in the installation of the
Advantage ODBC driver or in the connection string you're using. For
help on these you'll probably do better to ask in an Advantage forum
than here.

as i wrote i got the connection but when i try to open the table i got the
following error.
ODBC--call failed

[Extended Systems][Advantage SQL][ASA] Error: 7200: AQA Error: State = 42000;
NativeError =2228; [Extended Systems][Advantage SQL Engine]Invalid viiew
definition: Items. unexpected token after the view statement. (#7200)

there is a help button on the msgbox the help give me the following message.

ODBC – call failed. (Error 3146)

Using an ODBC connection, you tried to perform an operation on data in an
ODBC data source. This error may occur when the ODBC data source is on a
network drive and you are not connected to the network. Make sure the network
is available, and then try the operation again.


the connection is on a network but the network is available i also tryed
creating a database on the network computer but i got there the same error.
if you know what could solve the problam please help thanks.

Thanks john for your help.
I have downloaded the ODBC Driver for advantage database but when trying to
connect i get a error.
"Unable to load the Advantage ODBC Setup DLL (adsset.dll)."
I searched my computer for adsset.dll and i found that i have it installed
probably in the right folder.
could you please help me set it up? I'm new at ODBC.
Thanks again
You need to obtain and install an ODBC driver for the Advantage
database.
Click to expand...
[quoted text clipped - 6 lines]
Click to expand...
Click to expand...
 
thanks and I'll take it from there.
while waiting for an answer I tried a different table not the one I need and
I got it working correctly so I guess I just don't know how to set it up good.
hope I'll get on track soon
thanks again

John said:
Sorry, Moshe, I've no experience at all with Advantage and not much
with ODBC drivers. I've checked Carl Prothman's Connection Strings
site (my usual refuge) and there's some information about using
Advantage with OLE DB, but seemingly nothing about the ODBC driver.
Maybe the OLE DB stuff will give you a hint.
(http://www.carlprothman.net/Default.aspx?tabid=81)

One thing I'd try is to access some other data source via ODBC, to
prove that the basic ODBC setup on your computer is working. Assuming
it is, the problem is likely to be in the installation of the
Advantage ODBC driver or in the connection string you're using. For
help on these you'll probably do better to ask in an Advantage forum
than here.
as i wrote i got the connection but when i try to open the table i got the
following error.
Click to expand...
[quoted text clipped - 31 lines]
Click to expand...
 
Back
Top