VBA code calling a VB6 dll method under regular account gets ODBC Driver error but works when run as AdministratorCan not Open ODBC connection for MSAceess in Windows7 64bitData source name not found and no default driver specified (VS & Access)Getting [ODBC Driver Manager] Data source name not found error after deploymentHow can i connect to local advantage database using pyodbc in python?Connect Python script to PostgreSQL databaseADO .addnew with ODBC for mariadb: ErrorData source name not found and no default driver specified java.sql.SQLExceptiontally odbc connection with php and fetch dataPyodbc IM002 database connection
Number of academics in various EU countries
Why does a sticker slowly peel off, but if it is pulled quickly it tears?
How many birds in the bush?
What are the occurences of total war in the Native Americans?
Can Orcus use Multiattack with any melee weapon?
Retroactively modifying humans for Earth?
Cooking Scrambled Eggs
What stops you from using fixed income in developing countries?
Can an Arcane Focus be embedded in one's body?
If the Shillelagh cantrip is applied to a club with non-standard damage dice, what is the resulting damage dice?
How long do you think advanced cybernetic implants would plausibly last?
Rent contract say that pets are not allowed. Possible repercussions if bringing the pet anyway?
Billiard balls collision
Estimate number of digits of 333!
How can I download a file from a host I can only SSH to through another host?
How do I feed my black hole?
Disk usage of integer column vs boolean column in Postgres
Sum array of arrays (matrix) vertically
Is one hour layover sufficient at Singapore Changi Airport (Indian citizen travelling from US to India)?
Why is getting a PhD considered "financially irresponsible"?
How do you capitalize agile costs with less mature teams?
Unlock your Lock
Adoption records in 1871 based on census info
Is it bad for SEO have the same site on a .gr and a .com with both English and Greek content?
VBA code calling a VB6 dll method under regular account gets ODBC Driver error but works when run as Administrator
Can not Open ODBC connection for MSAceess in Windows7 64bitData source name not found and no default driver specified (VS & Access)Getting [ODBC Driver Manager] Data source name not found error after deploymentHow can i connect to local advantage database using pyodbc in python?Connect Python script to PostgreSQL databaseADO .addnew with ODBC for mariadb: ErrorData source name not found and no default driver specified java.sql.SQLExceptiontally odbc connection with php and fetch dataPyodbc IM002 database connection
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I have a Word template (.dot) open in Word 2016 that references a VB6 dll. When I run the VBA code with my regular user account I receive an error message. When I run it under my Admin account, I do not get the error. The error occurs on the referenced objects "Load()" method call:
Dim m_Manager As New PrefixService.Manager
Call m_Manager.Load(subjectID, ClientID)
The exact error is:
Run-time error '-2147467259 (80004005)':
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
I have done some research but am in unfamiliar territory. I keep reading things about the registry and ODBC. There is an entry in the registry for PrefixService.Manager and users have read access to it. As for the ODBC Data Source Administrator, I am not sure what to look for but search results mention connection strings and Microsoft Access a lot even though I am not sure what they have to do with me referencing a dll and executing code from it. Microsoft Access 2016 is installed. I have run the Windows Sysinternals ListDlls command on the WINWORD process and saw that the dll was never loaded, however, under my Admin account, I can see the dll gets loaded. While in ODBC Data Source Administrator, I ran a trace, but unfortunately I do not speak ODBC and find it difficult to understand.I believe the following section contains the information about the issue:
o "u" 1260-ca4 ENTER SQLDriverConnectW
HDBC 0x0BA01850
HWND 0x00000000
WCHAR * 0x5A768B34 [ -3] "****** 0"
SWORD -3
WCHAR * 0x5A768B34
SWORD -3
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
o "u" 1260-ca4 EXIT SQLDriverConnectW with return code -1 (SQL_ERROR)
HDBC 0x0BA01850
HWND 0x00000000
WCHAR * 0x5A768B34 [ -3] "****** 0"
SWORD -3
WCHAR * 0x5A768B34
SWORD -3
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
DIAG [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0)
o "u" 1260-ca4 ENTER SQLGetDiagRecW
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 0x0BA01850
SQLSMALLINT 1
SQLWCHAR * 0x0036E93C
SQLINTEGER * 0x0036E514
SQLWCHAR * 0x0036E53C
SQLSMALLINT 512
SQLSMALLINT * 0x0036E524
o "u" 1260-ca4 EXIT SQLGetDiagRecW with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 0x0BA01850
SQLSMALLINT 1
SQLWCHAR * 0x0036E93C [ 5] "IM002"
SQLINTEGER * 0x0036E514 (0)
SQLWCHAR * 0x0036E53C [ 91] "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"
SQLSMALLINT 512
SQLSMALLINT * 0x0036E524 (91)
I am now at a loss other than it appears to be permissions based. Oh and the OS is Windows 7 Enterprise
registry dll odbc vb6
asked Mar 27 at 19:39
Kyle PiersonKyle Pierson
384 bronze badges
migrated from superuser.com Mar 27 at 20:01
This question came from our site for computer enthusiasts and power users.
|
show 2 more comments
I have a Word template (.dot) open in Word 2016 that references a VB6 dll. When I run the VBA code with my regular user account I receive an error message. When I run it under my Admin account, I do not get the error. The error occurs on the referenced objects "Load()" method call:
Dim m_Manager As New PrefixService.Manager
Call m_Manager.Load(subjectID, ClientID)
The exact error is:
Run-time error '-2147467259 (80004005)':
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
I have done some research but am in unfamiliar territory. I keep reading things about the registry and ODBC. There is an entry in the registry for PrefixService.Manager and users have read access to it. As for the ODBC Data Source Administrator, I am not sure what to look for but search results mention connection strings and Microsoft Access a lot even though I am not sure what they have to do with me referencing a dll and executing code from it. Microsoft Access 2016 is installed. I have run the Windows Sysinternals ListDlls command on the WINWORD process and saw that the dll was never loaded, however, under my Admin account, I can see the dll gets loaded. While in ODBC Data Source Administrator, I ran a trace, but unfortunately I do not speak ODBC and find it difficult to understand.I believe the following section contains the information about the issue:
o "u" 1260-ca4 ENTER SQLDriverConnectW
HDBC 0x0BA01850
HWND 0x00000000
WCHAR * 0x5A768B34 [ -3] "****** 0"
SWORD -3
WCHAR * 0x5A768B34
SWORD -3
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
o "u" 1260-ca4 EXIT SQLDriverConnectW with return code -1 (SQL_ERROR)
HDBC 0x0BA01850
HWND 0x00000000
WCHAR * 0x5A768B34 [ -3] "****** 0"
SWORD -3
WCHAR * 0x5A768B34
SWORD -3
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
DIAG [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0)
o "u" 1260-ca4 ENTER SQLGetDiagRecW
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 0x0BA01850
SQLSMALLINT 1
SQLWCHAR * 0x0036E93C
SQLINTEGER * 0x0036E514
SQLWCHAR * 0x0036E53C
SQLSMALLINT 512
SQLSMALLINT * 0x0036E524
o "u" 1260-ca4 EXIT SQLGetDiagRecW with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 0x0BA01850
SQLSMALLINT 1
SQLWCHAR * 0x0036E93C [ 5] "IM002"
SQLINTEGER * 0x0036E514 (0)
SQLWCHAR * 0x0036E53C [ 91] "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"
SQLSMALLINT 512
SQLSMALLINT * 0x0036E524 (91)
I am now at a loss other than it appears to be permissions based. Oh and the OS is Windows 7 Enterprise
registry dll odbc vb6
asked Mar 27 at 19:39
Kyle PiersonKyle Pierson
384 bronze badges
migrated from superuser.com Mar 27 at 20:01
This question came from our site for computer enthusiasts and power users.
As admin try right clicking on DLL and checking the permissions on the security tab.
– Brian
Mar 27 at 21:19
"Users" had "Read & Execute" and "Read" permissions on the dll. Just for testing purposes, I changed permissions on it to "Full Control" and ran it and received the same error. Thanks for the suggestion though
– Kyle Pierson
Mar 27 at 22:58
It might be that the ODBC DSN has been set up as a user DSN under your administrator account. Try running odbcad32 as both your normal user account and your admin account and see what is listed under the User DSN and System DSN. If you have something under the admin one that isn't under the normal user one then you could try copying the settings across.
– OldBoyCoder
Mar 28 at 8:17
I appreciate the help. The entries on both the User DSN and and System DSN tabs have the exact same entries and the same settings within the Configure window
– Kyle Pierson
Mar 28 at 15:34
This is going to be tricky to help remotely but you've done well so far what what you've found.To answer one of your questions, I suspect the Load method in the VB6 DLL is accessing a database to retrieve the values it is loading. It is using ODBC to access the database. The ODBC function SQLDriverConnect is used to connect to a database. One of the parameters to that is shown as 'WCHAR * 0x5A768B34 [ -3] "****** 0"' in your trace. This parameter contains the details of how to connect to the database. (cont...)
– OldBoyCoder
Mar 28 at 18:44
|
show 2 more comments
I have a Word template (.dot) open in Word 2016 that references a VB6 dll. When I run the VBA code with my regular user account I receive an error message. When I run it under my Admin account, I do not get the error. The error occurs on the referenced objects "Load()" method call:
Dim m_Manager As New PrefixService.Manager
Call m_Manager.Load(subjectID, ClientID)
The exact error is:
Run-time error '-2147467259 (80004005)':
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
I have done some research but am in unfamiliar territory. I keep reading things about the registry and ODBC. There is an entry in the registry for PrefixService.Manager and users have read access to it. As for the ODBC Data Source Administrator, I am not sure what to look for but search results mention connection strings and Microsoft Access a lot even though I am not sure what they have to do with me referencing a dll and executing code from it. Microsoft Access 2016 is installed. I have run the Windows Sysinternals ListDlls command on the WINWORD process and saw that the dll was never loaded, however, under my Admin account, I can see the dll gets loaded. While in ODBC Data Source Administrator, I ran a trace, but unfortunately I do not speak ODBC and find it difficult to understand.I believe the following section contains the information about the issue:
o "u" 1260-ca4 ENTER SQLDriverConnectW
HDBC 0x0BA01850
HWND 0x00000000
WCHAR * 0x5A768B34 [ -3] "****** 0"
SWORD -3
WCHAR * 0x5A768B34
SWORD -3
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
o "u" 1260-ca4 EXIT SQLDriverConnectW with return code -1 (SQL_ERROR)
HDBC 0x0BA01850
HWND 0x00000000
WCHAR * 0x5A768B34 [ -3] "****** 0"
SWORD -3
WCHAR * 0x5A768B34
SWORD -3
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
DIAG [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0)
o "u" 1260-ca4 ENTER SQLGetDiagRecW
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 0x0BA01850
SQLSMALLINT 1
SQLWCHAR * 0x0036E93C
SQLINTEGER * 0x0036E514
SQLWCHAR * 0x0036E53C
SQLSMALLINT 512
SQLSMALLINT * 0x0036E524
o "u" 1260-ca4 EXIT SQLGetDiagRecW with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 0x0BA01850
SQLSMALLINT 1
SQLWCHAR * 0x0036E93C [ 5] "IM002"
SQLINTEGER * 0x0036E514 (0)
SQLWCHAR * 0x0036E53C [ 91] "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"
SQLSMALLINT 512
SQLSMALLINT * 0x0036E524 (91)
I am now at a loss other than it appears to be permissions based. Oh and the OS is Windows 7 Enterprise
registry dll odbc vb6
asked Mar 27 at 19:39
Kyle PiersonKyle Pierson
384 bronze badges
I have a Word template (.dot) open in Word 2016 that references a VB6 dll. When I run the VBA code with my regular user account I receive an error message. When I run it under my Admin account, I do not get the error. The error occurs on the referenced objects "Load()" method call:
Dim m_Manager As New PrefixService.Manager
Call m_Manager.Load(subjectID, ClientID)
The exact error is:
Run-time error '-2147467259 (80004005)':
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
I have done some research but am in unfamiliar territory. I keep reading things about the registry and ODBC. There is an entry in the registry for PrefixService.Manager and users have read access to it. As for the ODBC Data Source Administrator, I am not sure what to look for but search results mention connection strings and Microsoft Access a lot even though I am not sure what they have to do with me referencing a dll and executing code from it. Microsoft Access 2016 is installed. I have run the Windows Sysinternals ListDlls command on the WINWORD process and saw that the dll was never loaded, however, under my Admin account, I can see the dll gets loaded. While in ODBC Data Source Administrator, I ran a trace, but unfortunately I do not speak ODBC and find it difficult to understand.I believe the following section contains the information about the issue:
o "u" 1260-ca4 ENTER SQLDriverConnectW
HDBC 0x0BA01850
HWND 0x00000000
WCHAR * 0x5A768B34 [ -3] "****** 0"
SWORD -3
WCHAR * 0x5A768B34
SWORD -3
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
o "u" 1260-ca4 EXIT SQLDriverConnectW with return code -1 (SQL_ERROR)
HDBC 0x0BA01850
HWND 0x00000000
WCHAR * 0x5A768B34 [ -3] "****** 0"
SWORD -3
WCHAR * 0x5A768B34
SWORD -3
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
DIAG [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0)
o "u" 1260-ca4 ENTER SQLGetDiagRecW
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 0x0BA01850
SQLSMALLINT 1
SQLWCHAR * 0x0036E93C
SQLINTEGER * 0x0036E514
SQLWCHAR * 0x0036E53C
SQLSMALLINT 512
SQLSMALLINT * 0x0036E524
o "u" 1260-ca4 EXIT SQLGetDiagRecW with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 0x0BA01850
SQLSMALLINT 1
SQLWCHAR * 0x0036E93C [ 5] "IM002"
SQLINTEGER * 0x0036E514 (0)
SQLWCHAR * 0x0036E53C [ 91] "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"
SQLSMALLINT 512
SQLSMALLINT * 0x0036E524 (91)
I am now at a loss other than it appears to be permissions based. Oh and the OS is Windows 7 Enterprise
registry dll odbc vb6
registry dll odbc vb6
asked Mar 27 at 19:39
Kyle PiersonKyle Pierson
384 bronze badges
asked Mar 27 at 19:39
Kyle PiersonKyle Pierson
384 bronze badges
asked Mar 27 at 19:39
Kyle PiersonKyle Pierson
384 bronze badges
asked Mar 27 at 19:39
Kyle PiersonKyle Pierson
384 bronze badges
asked Mar 27 at 19:39
Kyle PiersonKyle Pierson
384 bronze badges
384 bronze badges
migrated from superuser.com Mar 27 at 20:01
This question came from our site for computer enthusiasts and power users.
migrated from superuser.com Mar 27 at 20:01
This question came from our site for computer enthusiasts and power users.
migrated from superuser.com Mar 27 at 20:01
This question came from our site for computer enthusiasts and power users.
As admin try right clicking on DLL and checking the permissions on the security tab.
– Brian
Mar 27 at 21:19
"Users" had "Read & Execute" and "Read" permissions on the dll. Just for testing purposes, I changed permissions on it to "Full Control" and ran it and received the same error. Thanks for the suggestion though
– Kyle Pierson
Mar 27 at 22:58
It might be that the ODBC DSN has been set up as a user DSN under your administrator account. Try running odbcad32 as both your normal user account and your admin account and see what is listed under the User DSN and System DSN. If you have something under the admin one that isn't under the normal user one then you could try copying the settings across.
– OldBoyCoder
Mar 28 at 8:17
I appreciate the help. The entries on both the User DSN and and System DSN tabs have the exact same entries and the same settings within the Configure window
– Kyle Pierson
Mar 28 at 15:34
This is going to be tricky to help remotely but you've done well so far what what you've found.To answer one of your questions, I suspect the Load method in the VB6 DLL is accessing a database to retrieve the values it is loading. It is using ODBC to access the database. The ODBC function SQLDriverConnect is used to connect to a database. One of the parameters to that is shown as 'WCHAR * 0x5A768B34 [ -3] "****** 0"' in your trace. This parameter contains the details of how to connect to the database. (cont...)
– OldBoyCoder
Mar 28 at 18:44
|
show 2 more comments
As admin try right clicking on DLL and checking the permissions on the security tab.
– Brian
Mar 27 at 21:19
"Users" had "Read & Execute" and "Read" permissions on the dll. Just for testing purposes, I changed permissions on it to "Full Control" and ran it and received the same error. Thanks for the suggestion though
– Kyle Pierson
Mar 27 at 22:58
It might be that the ODBC DSN has been set up as a user DSN under your administrator account. Try running odbcad32 as both your normal user account and your admin account and see what is listed under the User DSN and System DSN. If you have something under the admin one that isn't under the normal user one then you could try copying the settings across.
– OldBoyCoder
Mar 28 at 8:17
I appreciate the help. The entries on both the User DSN and and System DSN tabs have the exact same entries and the same settings within the Configure window
– Kyle Pierson
Mar 28 at 15:34
This is going to be tricky to help remotely but you've done well so far what what you've found.To answer one of your questions, I suspect the Load method in the VB6 DLL is accessing a database to retrieve the values it is loading. It is using ODBC to access the database. The ODBC function SQLDriverConnect is used to connect to a database. One of the parameters to that is shown as 'WCHAR * 0x5A768B34 [ -3] "****** 0"' in your trace. This parameter contains the details of how to connect to the database. (cont...)
– OldBoyCoder
Mar 28 at 18:44
As admin try right clicking on DLL and checking the permissions on the security tab.
– Brian
Mar 27 at 21:19
As admin try right clicking on DLL and checking the permissions on the security tab.
– Brian
Mar 27 at 21:19
"Users" had "Read & Execute" and "Read" permissions on the dll. Just for testing purposes, I changed permissions on it to "Full Control" and ran it and received the same error. Thanks for the suggestion though
– Kyle Pierson
Mar 27 at 22:58
"Users" had "Read & Execute" and "Read" permissions on the dll. Just for testing purposes, I changed permissions on it to "Full Control" and ran it and received the same error. Thanks for the suggestion though
– Kyle Pierson
Mar 27 at 22:58
It might be that the ODBC DSN has been set up as a user DSN under your administrator account. Try running odbcad32 as both your normal user account and your admin account and see what is listed under the User DSN and System DSN. If you have something under the admin one that isn't under the normal user one then you could try copying the settings across.
– OldBoyCoder
Mar 28 at 8:17
It might be that the ODBC DSN has been set up as a user DSN under your administrator account. Try running odbcad32 as both your normal user account and your admin account and see what is listed under the User DSN and System DSN. If you have something under the admin one that isn't under the normal user one then you could try copying the settings across.
– OldBoyCoder
Mar 28 at 8:17
I appreciate the help. The entries on both the User DSN and and System DSN tabs have the exact same entries and the same settings within the Configure window
– Kyle Pierson
Mar 28 at 15:34
I appreciate the help. The entries on both the User DSN and and System DSN tabs have the exact same entries and the same settings within the Configure window
– Kyle Pierson
Mar 28 at 15:34
This is going to be tricky to help remotely but you've done well so far what what you've found.To answer one of your questions, I suspect the Load method in the VB6 DLL is accessing a database to retrieve the values it is loading. It is using ODBC to access the database. The ODBC function SQLDriverConnect is used to connect to a database. One of the parameters to that is shown as 'WCHAR * 0x5A768B34 [ -3] "****** 0"' in your trace. This parameter contains the details of how to connect to the database. (cont...)
– OldBoyCoder
Mar 28 at 18:44
This is going to be tricky to help remotely but you've done well so far what what you've found.To answer one of your questions, I suspect the Load method in the VB6 DLL is accessing a database to retrieve the values it is loading. It is using ODBC to access the database. The ODBC function SQLDriverConnect is used to connect to a database. One of the parameters to that is shown as 'WCHAR * 0x5A768B34 [ -3] "****** 0"' in your trace. This parameter contains the details of how to connect to the database. (cont...)
– OldBoyCoder
Mar 28 at 18:44
|
show 2 more comments
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55385551%2fvba-code-calling-a-vb6-dll-method-under-regular-account-gets-odbc-driver-error-b%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Is this question similar to what you get asked at work? Learn more about asking and sharing private information with your coworkers using Stack Overflow for Teams.
Is this question similar to what you get asked at work? Learn more about asking and sharing private information with your coworkers using Stack Overflow for Teams.
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55385551%2fvba-code-calling-a-vb6-dll-method-under-regular-account-gets-odbc-driver-error-b%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
As admin try right clicking on DLL and checking the permissions on the security tab.
– Brian
Mar 27 at 21:19
"Users" had "Read & Execute" and "Read" permissions on the dll. Just for testing purposes, I changed permissions on it to "Full Control" and ran it and received the same error. Thanks for the suggestion though
– Kyle Pierson
Mar 27 at 22:58
It might be that the ODBC DSN has been set up as a user DSN under your administrator account. Try running odbcad32 as both your normal user account and your admin account and see what is listed under the User DSN and System DSN. If you have something under the admin one that isn't under the normal user one then you could try copying the settings across.
– OldBoyCoder
Mar 28 at 8:17
I appreciate the help. The entries on both the User DSN and and System DSN tabs have the exact same entries and the same settings within the Configure window
– Kyle Pierson
Mar 28 at 15:34
This is going to be tricky to help remotely but you've done well so far what what you've found.To answer one of your questions, I suspect the Load method in the VB6 DLL is accessing a database to retrieve the values it is loading. It is using ODBC to access the database. The ODBC function SQLDriverConnect is used to connect to a database. One of the parameters to that is shown as 'WCHAR * 0x5A768B34 [ -3] "****** 0"' in your trace. This parameter contains the details of how to connect to the database. (cont...)
– OldBoyCoder
Mar 28 at 18:44