Hi Guffa, Thanks for the help. I resolved the issue.There was some issue with the connection string ;after resolving it my connection is working fine.The take away for me from here is if there is any issue with the connection string this error will happen. Thanks Again for your replies..... Keep up the spirit....

Hi, You may take a look at the following links: Link1[^] Link2[^] Link3[^] Link4[^] Hope this helps :) Regards, John Adams ComponentOne LLC

Learn to use google :| "The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon "Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham

That's because your SMTP server doesn't allow mail relay. The from address has to be an account on the SMTP server, or it won't send. "Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997 ----- "...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001

new2pgrmg wrote: Am getting an error "Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".". Your error is something else. Your linked server configuration has some problem. Does it have data transfer access? new2pgrmg wrote: 1)How cam i know my "SQL server ' is 32bit or 64bit? In management studio, execute @@Version, this will tell you if SQL Server is 32 bit or 64 bit.

Create the tables in SQL then import the data from the MDB. If you have multiple tables with constraints, either import the data in the correct order, or temporarili remove the constraints. A treat for all down voters...[^] "you can't forget something you never knew..." M. Du Toit

So you know in the future. If no one has responded to your question you have the ability to delete the message using the 'Delete' button in the lower right hand corner of the message. Regards, Thomas Stockwell Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. Visit my homepage Oracle Studios[^]

Stop the SQL Server Service, copy the mdf and ldf to a different location and do your reinstall. Once you have the new instance up, you can try attaching the mdf, although I seriously doubt if it'll succeed. It's a gamble you've to take. I did this and am going to reinstall my SQL server 2005.I hope while attaching it will work.Any way at this point i think we have to take that risk since we dont have any other options. I will try this and will post the effects.Please be in this loop. Many Thanks

If you must take it into access: Why not use a text editor, something like gVIM with a :%s/\"/,/g then :%s/,,/,/g command and convert it to a CVS file and do a direct import? Or you could do an indirect import by 1st going into to excel and picking " as your custom split char, but you MUST remember to import as text! Not really a reason to parse this though C# code, as you are just going to make it harder on yourself. Remember the simplest solution is most of the time the better soluiton. The only reason I could see doing this in C# is if you have to process these files many times a day or you wish to learn ADO.NET along the way. The second option doesn't seem viable if you already send Access data into SQL server, so why not modify or fork the program you have to parse the flat file directly into SQL server 2k5? -Spacix All your skynet questions[^] belong to solved

Thank you Mark,I will check this.

Yes, but why? Probably, but I don't have any.

Can you post all of your code so we can try and replicate your error

I doubt it. You could do some javascript to alternate between a textbox and a dropdownlist, but I don't think a HTML drop list is ever editable. Christian Graus - Microsoft MVP - C++ "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

i think you should turn off updating of log TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L %^]*IRXD#@GKCQ`R\^SF_WcHbORY87??6?N8?BcRAV\Z^&SU~%CSWQ@#2 W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN% Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-i?TV.C\y -------------------------------------------------------- 128 bit encrypted signature, crack if you can

I recommend you give this up and buy a basic book on C#, so you can start at the beginning. You're obvioulsy guessing what to do here. obj.ShowDialog will show the open file dialog. Then you check the DialogResult to see if the user clicked OK, and then you have a file selected. Even then, obj.OpenFile is not magically going to open the file in your program. You have a ways to go, take a step back and learn some basics. Christian Graus - Microsoft MVP - C++ "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

You can use the border-radius style, but there'll be a lot of browsers that won't support it.

http://www.devarticles.com/c/a/JavaScript/Building-Rounded-Corners-With-CSS-and-JavaScript/ http://aspnet.4guysfromrolla.com/articles/072804-1.aspx

Sorry for the mistake but the basic idea is correct.As i told you i was trying different methods and when i found that the posted question had a slight mistake i tried to edit but it was not loading. The error will be Could not bulk insert. Unknown version of format file 'C:\myTestSkipCol2.Xml'. Sorry for the mistake Looking for an answer. Also can you tell me how i can find the BCP version? Many Thanks