473,549 Members | 2,584 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

ODBC--call failed error when trying to view a report

7 New Member
I am trying to view my reports based on a linked table database. However both the reports and the queries they're based on give me a "odbc--call failed" error. When I click on help it cites error 3146 and suggests that either the data source is on a network drive or that I am not connected to the network. I am not sure what either means but I am able to view the linked tables and access the database through data sources (ODBC) in administrative tools.

I am running a linked table database on Access 2000 on a Windows XP machine.

Any suggestions would be most appreciated.
Sep 4 '07 #1
5 6832
puppydogbuddy
1,923 Recognized Expert Top Contributor
I am trying to view my reports based on a linked table database. However both the reports and the queries they're based on give me a "odbc--call failed" error. When I click on help it cites error 3146 and suggests that either the data source is on a network drive or that I am not connected to the network. I am not sure what either means but I am able to view the linked tables and access the database through data sources (ODBC) in administrative tools.

I am running a linked table database on Access 2000 on a Windows XP machine.

Any suggestions would be most appreciated.
If you are trying to connect Access to a back end server via an ODBC connection, I would check with server db administrator to see if you have the proper security permissions to do so.

If that is not the answer, then I would verify that your ODBC driver you are using is not outdated.
Sep 4 '07 #2
kchang
7 New Member
If you are trying to connect Access to a back end server via an ODBC connection, I would check with server db administrator to see if you have the proper security permissions to do so.

If that is not the answer, then I would verify that your ODBC driver you are using is not outdated.
Checked the drivers and they appear to be the latest ones. I would like to think that I have the permissions to connect to the server via an ODBC connection. Like I said I can view the linked tables and connect to the server via a data link. Would having to login to the SQL Server using a password affect the reports and queries on Microsoft Access?
Sep 6 '07 #3
puppydogbuddy
1,923 Recognized Expert Top Contributor
Checked the drivers and they appear to be the latest ones. I would like to think that I have the permissions to connect to the server via an ODBC connection. Like I said I can view the linked tables and connect to the server via a data link. Would having to login to the SQL Server using a password affect the reports and queries on Microsoft Access?
Yes. The reports use the queries as the data source. The queries, in turn, access data from the tables in the Back End. Therefore, you must have a logon password with the proper permissions to connect via ODBC. See this link regarding the logon process.

http://support.microsoft.com/kb/q245587/

As stated in the article: In Microsoft Access, when you first link (attach) an external table using an ODBC driver, you have the option to store the User ID and password for the table locally........ ..(this means also that you must have a login ID and password with the proper permissions).
Sep 6 '07 #4
kchang
7 New Member
Yes. The reports use the queries as the data source. The queries, in turn, access data from the tables in the Back End. Therefore, you must have a logon password with the proper permissions to connect via ODBC. See this link regarding the logon process.

http://support.microsoft.com/kb/q245587/

As stated in the article: In Microsoft Access, when you first link (attach) an external table using an ODBC driver, you have the option to store the User ID and password for the table locally........ ..(this means also that you must have a login ID and password with the proper permissions).
I checked out the link and tried relinking my tables with the "Save Password" box checked, but I'm still receiving the error. I also looked at the third option listed: pre-authenticating the login, but I'm not entirely sure how to go about doing that as I am not very familiar with vb.
Sep 6 '07 #5
puppydogbuddy
1,923 Recognized Expert Top Contributor
I checked out the link and tried relinking my tables with the "Save Password" box checked, but I'm still receiving the error. I also looked at the third option listed: pre-authenticating the login, but I'm not entirely sure how to go about doing that as I am not very familiar with vb.
Does your password have permissions to access the back end tables via ODBC?

The link I gave you has sample code for pre-authenticating the login. Did you see it? As instructed, place the code behind a button and execute it by clicking the button dring the login, Replace the sample's parameters in the code with yours, where applicable. If you don't know how to do this, you need to talk to the dba for your server machine.
Sep 7 '07 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

2
2200
by: Debbie | last post by:
Hi I have developed an application that access an SQL database and installed it on a different machine The installation is successful but when I try to run the application I get the following error Application has generated an exception that could not be handled Process id = 0x610 (1552), Thread id=0x1d0(464)
1
1885
by: Jeff Thur | last post by:
I am getting this error when trying to run a stored procedure: Microsoft.VisualBasic.CompilerServices.LateBinding.LateInd exGet(Object o, Object args, String paramnames) +1361 ASP.Baldwin41_aspx.Button1_Click(Object sender, EventArgs e) +66 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +83
1
3765
by: Ghanashyam | last post by:
Dotnet Framework 1.1 is installed on my computer running on Windows 2000 Professional.Visual Studio >net 2003 is installed.When I try to create an ASP.NET project I get following error. The web server reported the following error when attempting to create or open the web project located at the following 'URL://Localhost/WebApplication1'...
5
3612
by: snicks | last post by:
I'm trying to exec a program external to my ASP.NET app using the following code. The external app is a VB.NET application. Dim sPPTOut As String sPPTOut = MDEPDirStr + sID + ".ppt" Dim p As New System.Diagnostics.Process 'p.Start(MDEPDirStr & "macrun.exe", sPPTOut) p.Start("C:\WINDOWS\SYSTEM32\CALC.EXE")...
1
2406
by: dipesh | last post by:
I am getting error when trying to Add Web Reference in Visual Studio 2005. "Some of the files required for web references are not installed"
2
2213
by: ticars | last post by:
I'm getting a weird error when trying to access a user control from within a base page during runtime. Here's what I have: I have a master page with a user control on it. I then have a few webforms that provide content to the master page. All of these webforms inherit from the same basepage which I created. Within that base page I'm...
3
4213
by: LRI41 | last post by:
I googled an error message and it came up with two posts on your forum and when I got there it said I needed to register to post my question, I am not sure whether is this the correct place to post it or not. I did read the FAQ's but did not find them enlightening. The two post that showed up on Google were the same question but with...
5
6616
by: Martin | last post by:
I get below error when trying to write unicode xml to a zipfile. zip.writestr('content.xml', content.toxml()) File "/usr/lib/python2.4/zipfile.py", line 460, in writestr zinfo.CRC = binascii.crc32(bytes) # CRC-32 checksum UnicodeEncodeError: 'ascii' codec can't encode character u'\u25cf' in position 2848: ordinal not in range(128) ...
1
2501
by: jonny | last post by:
Went from using Visual Web Develop express to Visual Studio 2005 and getting error when trying to open project. Error message: "One or more projects in the solution could not be loaded for the following reason(s): The project file or web has been moved, renamed or is not on your computer.
0
7459
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7726
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
7967
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
6052
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
5097
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3505
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3488
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1064
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
772
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.