First off, forgive me if this is being posted in the wrong forum. Results 1 to 6 of 6 Thread: Just create everything inside the method. Any help would be greatly appreciated. This is an error in the Query being used. Results 1 to 6 of 6.

Uploader: Golar
Date Added: 16 April 2007
File Size: 38.36 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 43677
Price: Free* [*Free Regsitration Required]

Problem connecting to CSV file? (PLEASE HELP) | The Forums

Methods performs actions so their names should generally be micfosoft. You may have to register before you can post: Make sure the column names are referenced correctly within the query since SmartConnect removes the spaces when displaying the data. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. If using a query that is more advanced, the will return the following error when testing the ODCB Connection: Remove From My Forums.

An invalid odbc query syntax will generate a generic error regarding parameters or missing command.

IQ Excel ODBC Integration Troubleshooting

This window will appear, and the ODBC Table Name, as entered in thewill be the same as the one defined in this window. While SmartConnect uses ODBC for connecting mcirosoft many different data sources the drivers required for those connections are going to be specific to the environment and may even differ per user machine and server.

If the file does not exist the folder specified, the error will point to the missing file name. Like ironic said in the answer the table doesn’t exists. Make sure the object exists and that you spell its name and the path name correctly.


Thursday, August 10, 3: For example, the column names in the above region would be named Name and PhoneNumber. Sign up using Facebook.

Here’s the pertinent code from my form’s code-behind fuImport is the FileUpload control: One of the most common methods of integrating data using SmartConnect are Microsoft Excel Files or flat files such as micosoft or tab delimited. Using this method, the ODBC Connection should work as it does locally most likely provided that both computers are on the same domain, and that the user is logged on that domain.

You’re problem presently isn’t opening the file, but finding the file. That error message should give you – and us – an idea of what the issue is.

This compensation may impact how and where products appear on this site including, for example, the order in which they appear. The first step on fixing this issue is to determine what connection is being made and then determine which ODBC driver oxbc install or valid on the current machine or machine that is producing the error.

For example, if you are currently editing the spreadsheet, and testing it in the UI, it will fail, and give the following error message: As an example, how does the name “connection” provide a succinct description of what that method does?

Welcome Guest Login Register. NET Managed Providers https: Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. Move the file to the correct location. Why is my data not saved to my database? As I would expect. By clicking “Post Your Answer”, you acknowledge that you have micorsoft our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies.


It is already opened exclusively by another user, or you need permission to view its data.

Troubleshooting ODBC Data Source Errors in SmartConnect

You can use this file on a machine that is running SmartConnect successfully to compare it with a list from a non-working client machine.

I have used the following code: If an exception is thrown then there’s an error message. The content you requested has been removed.

Each workstation where SmartConnect is running will have its own set of ODBC Drivers installed so while a map pointing to Excel on one machine works, it is possible that another machine does not have the same set of drivers loaded and the connection cannot be made.