MS Access and OE 10.2B Error

trmrahim

New Member
I need MS Access 2010 database to connect with 10.2B SP04 to migrate the MS Access tables (structure and data) to Progress. At the last step, it gives the following error.

---------------------------
Error
---------------------------
S0002: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Access database engine cannot find the input

table or query '.TestTabl'. Make sure it exists and that its name is spelled correctly.
---------------------------
OK
---------------------------

I have one table in MS Access "TestTable" (testing purpose)

ODBC Driver path: C:\Windows\SysWOW64\odbcad32.exe
OS : Windows Server 2008

Could somebody help me to solve this issue. If this is not the correct way let me know what are the steps need to follow.
Thanks in advance.
 

TomBascom

Curmudgeon
The leading dot suggests to me that you need to provide the name of the schema.
 

trmrahim

New Member
The leading dot suggests to me that you need to provide the name of the schema.
What should I provide as schema ?
 

Cringer

ProgressTalk.com Moderator
Staff member
You say the table is called TestTable, but the error message is referring to '.TestTabl' My first thought would be why is it being truncated.
 

trmrahim

New Member
You say the table is called TestTable, but the error message is referring to '.TestTabl' My first thought would be why is it being truncated.
Usually when we dump a progress table even dump table value will be part/full name of the table. Hence I think this is not an Issue
If we consider that point what I need to do?
 

Stefan

Active Member
Support for MS Access via DataServer for ODBC DataServer was dropped in OpenEdge 10 - has what you are trying to do ever worked?
 

TomBascom

Curmudgeon
My guess would be the dbname
 

trmrahim

New Member
My guess would be the dbname
I tried with the dbname but does not work. I doubt something wrong with drivers?
I tried with owner PUB/Admin too.
 

TomBascom

Curmudgeon
It's a mystery to me.

OpenEdge 10 and MS Access are both ancient, obsolete and unsupported. I think your time would be better spent upgrading to tools that will make your efforts more productive.
 

trmrahim

New Member
MS Access extension .accdb does not support. I had to change it to .mdb format
 
Top