Format of the initialization string does not conform to specification...

[gloria]

I am trying to load data from a flatfile into a dataset, but I get the
following errror: "Couldn't connect: Format of the initialization
string does not conform to specification starting at index 170."

What am I doing wrong?

--gloria

--------------------------
schema.ini:
[861D_NI_03082005001.txt]
ColNameHeader=False
Format=TabDelimited
CharacterSet=ANSI
--------------------------
string filename = "861D_NI_03082005001.txt";
string fullfilename = @"\\asean-test2\sdc\" + filename;

string connectionStr = "Provider=MediaCatalogMergedDB OLE DB Provider;"
+
"Persist Security Info=False;Data Source=" + fullfilename +
";Mode=Read" +
"Extended Properties=\"Text;HDR=NO;\"";


string loaddtlStr = "select * from " + filename;

try
{
OleDbConnection loaddtlCN = new OleDbConnection(connectionStr);
loaddtlCN.Open();
porerrorClass.WriteLine(3,CurrentFunction,"Connection is open.");

OleDbDataAdapter loaddtlDA = new
OleDbDataAdapter(loaddtlStr,loaddtlCN);
DataSet loaddtlDS = new DataSet("LoadedDtl");
loaddtlDA.Fill(loaddtlDS);

int rowcnt = loaddtlDS.Tables[0].Rows.Count;

porerrorClass.WriteLine(3,CurrentFunction,"Rows loaded: " + rowcnt);

loaddtlCN.Close();
}
catch (Exception ex)
{
porerrorClass.WriteLine(3,CurrentFunction,"Couldn't connect: " +
ex.Message);
}

 

[Val Mazur \(MVP\)]

Hi,

Do you get this error when you open connection? If yes, Have you tried to
use Jet 4.0 OLEDB provider?
If it is during selection of the data it is possible that provider cannot
predict proper number of the columns it needs to create for the result and
it fails.

 

[gloria]

Investigation has shown that I don't have Microsoft.Jet.40.OLEDB as a
valid provider. Jet comes with Access, which I don't have a license
for. I will look into getting this.

Thanks for your help!

--gloria

 

[Val Mazur \(MVP\)]

Hi,

You do not need to install Access and buy license for it to install Jet 4.0
OLEDB provider. It is free and you could download it from here

http://www.microsoft.com/downloads/results.aspx?productID=&freetext=jet+4.0+sp8&DisplayLang=en

 

[gloria]

Hey Val,

I figured out what I needed to do. I posted on another thread:
http://groups-beta.google.com/group...76c7912c21f/428600d718a46035#428600d718a46035

Thanks for your help!

--gloria