ODBC Error 7748

Yahoo Archive
1
Steven,

Thanks a ton. This took care of the problem.



Tim Dines

Information Technology

Steel Parts Manufacturing, Inc.

801 Berryman Pike

Tipton, IN 46072

Direct: 765-675-5201

Cell: 765-437-1402



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Steven Gotschall
Sent: Wednesday, February 10, 2010 11:40 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] ODBC Error 7748





This is an Access problem which requires a registry entry to fix, start regedit and goto:

HKEY_LOCAL_MACHINE
+ Software
+ ODBC
+ODBC.ini

Select the Data Source that you are using.
Right mouse click and select New, String Value (the name is case sensitive) Call it WorkArounds2.
Then select the WorkArounds2 and select Modify, give this a Value of 40960.

That will create the String Value of WorkArounds2=40960 Then attempt the link to the table.

Another way to deal with this is to manually create the cpnncetion string in Access.
ODBC;DSN=vntg8; HOST=Vantage8; PORT=8350; DB=mfgsys; UID=SYSPROGRESS; PWD=sysprogress

________________________________
From: "timdines@... <mailto:timdines%40ymail.com> " <tdines@... <mailto:tdines%40steelparts.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Wed, February 10, 2010 11:11:17 AM
Subject: [Vantage] ODBC Error 7748


I get this error message any time that I tried to get external data in Access from my Vantage database. I have no problem using the ODBC connection with Excel. Can anyone suggest a solution?

Thanks,
Tim Dines
Steel Parts Manufacturing

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
2
I get this error message any time that I tried to get external data in Access from my Vantage database. I have no problem using the ODBC connection with Excel. Can anyone suggest a solution?

Thanks,
Tim Dines
Steel Parts Manufacturing
3
This is an Access problem which requires a registry entry to fix, start regedit and goto:

HKEY_LOCAL_MACHINE
+ Software
+ ODBC
+ODBC.ini

Select the Data Source that you are using.Â
Right mouse click and select New, String Value (the name is case sensitive) Call it WorkArounds2.
Then select the WorkArounds2 and select Modify, give this a Value of  40960.

That will create the String Value of WorkArounds2=40960 Then attempt the link to the table.

Another way to deal with this is to manually create the cpnncetion string in Access.
ODBC;DSN=vntg8; HOST=Vantage8; PORT=8350; DB=mfgsys; UID=SYSPROGRESS; PWD=sysprogress


________________________________
From: "timdines@..." <tdines@...>
To: vantage@yahoogroups.com
Sent: Wed, February 10, 2010 11:11:17 AM
Subject: [Vantage] ODBC Error 7748

Â
I get this error message any time that I tried to get external data in Access from my Vantage database. I have no problem using the ODBC connection with Excel. Can anyone suggest a solution?

Thanks,
Tim Dines
Steel Parts Manufacturing







[Non-text portions of this message have been removed]