View Complete Post
At the time when we try to access a database the followin message is showed: ERROR  [Microsoft][ODBC SQL Server Driver][SQL Server]'Mid' is not a recognized function name.
I created an ODBC and when the database connection is tested there is no problem, the problem is when I try to access since the program.
Have come across a strange scenario and seeking your ideas/thoughts.
I'm using a ssis package to load a txt file. The txt file is text delimited by double quote (") and column delimited by tilde (~). It works fine in most scenarios and strips the enclosing "" from the columns -no problems there. However, in a specific
scenario where the last column has double quote in the data as well being the text delimiter, the package throws the following exception indicating that it's missing a column delimiter
The column delimiter for column "COL_NAME" was not found
This behaviour was not observed when double quotes were present as data in any other column in the file. Was able to workaround by disabled text delimiter only for the last column, but that isn't a perm solution. Also observed that if the " was replaced
by escape sequence /" the file loaded successfully. Wondering if this a known issue ?
I have written two diffirent application using ASP.NET (used C# as server side scripting language in both applications) against Oracle Data base.
In the first applicaton I am going to use Microsoft Library (System.Data.OracleClient) to access Oracle data base.
In the second application I am using ODP.NET. The first application will call the second application with a link on a page then the second applicaton will get control. Both the application having there own web.config files.
By Now both of these applicaton are in the development phase. I want to deploy it on the same server machince.
My question is, is it possible for both of these application to co exists. Will there be any problem/conflict as am using System.Data.OracleClient in the first, where as uses ODP.NET in the second to access the same oracle data base.
I am facing one problem with sql 2005 SSIS while uploading a "||" seperated text file with Data FlowÃÂ in SSIS.Below I am giving the sample data of the text file
data||data||dataÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ
When I uploaded it using sql 2000 DTS it wasÃÂ not giving and it was being uploaded into the tableÃÂ but when I tried with SQL 2005 it is giving the below problem.
"[Flat File Source ] Error: Data conversion failed. The data conversion for column "Column 2" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.". "
I have a 1.5 GB file into a table. I want to read It from server and create a file stream with it for save.
When I use DataAdapter.Fill(DataSet); code OutOfMemoryException occurs.
What should I do for read a hage file from data base?
I have a requirement to output data from two tables, a master table and a detail table, to a text file such that the output looks like the following:
master record 1
detail record 1 1
detail record 1 2
master record 2
detail record 2 1
master record 3
detail record 3 1
detail record 3 2
detail record 3 3
Is this possible in one query? I am sufficiently familiar with the bcp utility to do the output from any of the tables separately but have some difficulty with doing it for the two tables and have the result structured as outlined above.
I have to pull external data from a text file to a SharePoint list on a daily base. Additional column content (e.g. attachments) in SharePoint should be kept during update. There should be RSS feeds, email notifications or workflows on external data change
(so delete all items and import new will not work).
I've found this codeless 3rd party solution with automatic background update (and write-back???):
Any other idea? BDC-based? Thanks.
I have vc++ API project which installes custom tool bar to adobe acrobat. I need to add a text file using this project. when i try to do it it's working in my computer, but when i run this api in another computer, it's giving access denied.
I am using Windows 7 and Visual Studio 8 for this project.
Please can any one give a suggestion or any other method to solve this issue.
Im trying to take a text file I downloaded from the US Census Bureau website and transform it into an XML file. It is what the Census Bureau calls a ZCTA file. The schema of the file I have reposted as follows:
The ZCTA file contains data for all 5 digit ZCTAs in the 50 states,
District of Columbia and Puerto Rico as of Census 2000. The file is
plain ASCII text, one line per record.
Columns 147-157: Longitude (decimal degrees) First character is blank or "-" denoting East or West longitude respectively
All I want to do is produce an XML file with t
Hi friends this is siddiq ,
How can i open sharepoint 2010 lists in access
2010 as tables in 1 data base.I have 2 lists which i want to take into access but both of the lists are creating a seperate database.But i want to take both the lists in one access database
I am New to using the SqlBulkCopy Can any one tell me how to use it and how many rows maximum we can insert using the SqlBulkCopy
how to habdle the exceptions when bulkcopy inserting