| Author |
 Topic  |
|
|
kreta
Slovenia
9 Posts |
 Posted - 05/14/2015 : 05:23:01 AM
|
Origin Ver 8.1
Operating System:Windows 7
I'm trying to import data from microsoft access database.
First I trid my database and it didn't work, then I tried stars database that comes with origin, using the procedure shown in your video.
Everytime I'm getting an error:
ADODB.Connection, err = 11C
Would you please tell me what should I do to solve it?
|
Edited by - kreta on 05/14/2015 06:12:53 AM |
|
|
lkb0221
China
497 Posts |
Posted - 05/14/2015 : 10:36:10 AM
|
| Please try it in 32-bit and see if the problem still exists. |
 |
|
|
kreta
Slovenia
9 Posts |
Posted - 05/14/2015 : 10:38:44 AM
|
Thanks but
How can I try it in 32-bit ?
|
|
|
|
lkb0221
China
497 Posts |
Posted - 05/14/2015 : 10:45:32 AM
|
Oh, you are running 8.1Origin. Sorry.
So you are trying to import mdb or accdb? |
|
|
|
kreta
Slovenia
9 Posts |
Posted - 05/14/2015 : 10:49:25 AM
|
mdb it's not possible to import accdb in this version.
I tried to use the method described in the video here http://cloud.originlab.com/ftp/mm_tutorials/mp4/Database_Accessing.mp4
but it didn't work, and I get the error message: ADODB.Connection, err = 11C
It's my first time to try importing database to origin.
|
Edited by - kreta on 05/14/2015 1:24:18 PM |
|
|
|
ukash
Turkey
1 Posts |
Posted - 05/15/2015 : 8:19:37 PM
|
i have the same problem and not resolve...
are you resolve ?
thanks
|
|
|
|
lkb0221
China
497 Posts |
Posted - 05/18/2015 : 11:29:28 AM
|
Hi, Kreta
Sorry but we cannot reproduce the error you described. Would you mind try on a different PC?
Zheng
OriginLab |
|
|
|
kreta
Slovenia
9 Posts |
Posted - 05/19/2015 : 09:48:04 AM
|
I already tried on 3 PCs and I don't know where's the problem.
I have access installed on all of them.
I can open the database, to make sure the file is not corrupted.
on each machine I'm getting the same error.
ADODB.Connection, err = 11C
Do you think the problem could be with the ODBC?
One more note: I noticed in Query Builder window, Setting>> Use ODBC is inactive.
the connection string is:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Instalations\OriginLab\Origin81\Samples\Import and Export\stars.mdb;Persist Security Info=False
|
|
|
|
ZanHUNG
20 Posts |
Posted - 05/21/2015 : 04:16:20 AM
|
Looks like this happened when oConn.Open(strConn), where oConn = CreateObject("ADODB.Connection"), and strConn is Data Source.
- Open Windows PowerShell
Click the Start menu of Windows 7, type "powershell" and search. You may see "Windows PowerShell (x86)", and "Windows PowerShell" if it's a 64-bit OS.
- Try the following in "Windows PowerShell (x86)".
-
$conn = New-Object -ComObj ADODB.Connection
-
$conn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Instalations\OriginLab\Origin81\Samples\Import and Export\stars.mdb;Persist Security Info=False")
-
$conn
- If "Windows PowerShell" is found in Step 1, try the code in Step 2 as well.
Now see what the result is in PowerShell.
Further more, you may remove the any try-catch in Origin81\OriginC\originlab\datasource.C, and see what will be dumped to the output. For example, change the
try
{
SetStatusBarText("DB:openning connection...");
oConn.Open(strConn);
}
catch(int nError)
{
printf("ADODB.Connection, err = %X\n", nError);
return ADO_ERROR_OPEN_CONN;
}
to
SetStatusBarText("DB:openning connection...");
oConn.Open(strConn); |
|
|
|
kreta
Slovenia
9 Posts |
Posted - 05/21/2015 : 5:22:49 PM
|
I tried the first method and got this reply in this image with no error
then tried the second method and got this error
I never used C in origin so I don't know how to follow the next step |
|
|
|
a00b
Iran
2 Posts |
Posted - 05/01/2016 : 6:34:00 PM
|
Hello
Sometimes when opening an Access file will not be given permission to edit . How can this problem be resolved . How will this feature be disabled . Thanks.
www.a00b.com |
|
|
| |
Topic |
|
Import database