Ask a new question

64 bit ODBC driver not connecting to load csv data

Hi,

I am using C# application, trying to connect csv file and load the data to datatable, i am using windows 10 64 bit OS, and i have installed 64 bit ODBC driver from  below link

https://www.microsoft.com/en-us/download/confirmation.aspx?id=13255

connection string used is: 

Driver=Microsoft Access Text Driver (*.txt; *.csv);Dbq=<

I am getting an error on connection: 

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.

but, one thing noticed is, i have created system DSN, and changed the connection string as below and it works.

DSN=CSVDS;Dbq=<

but, i need to fix for the above issue, i cannot use system DSN, can someone please help what i am missing? its urgent.

Regards,

Hemal Kotak


Go back into Control Panel > Administrative Tools and observe there are two ODBC Data Sources applets, for 32 and 64-bit. Double-check that you created the system dns in the 64-bit version. My guess is you used the 32-bit one.
-Tom.
Microsoft Access MVP
Phoenix, AZ

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hi Tom,

Thanks for the replying, as u suggested i checked and confirmed that i was using 64-bit version only, not 32 bit driver.

I could able to see the DSN Created in 64 bit ODBC Data source Administrator, in 32 bit also, but it shows Platform as 64-bit and can not remove or modify in 32-bit odbc administrator, as  i have created in 64-bit.

My main question is why i am not able to connect using Connection string?, what wrong i am doing?

i am applying correct 64 bit ODBC connection string, which i am referring from website https://www.connectionstrings.com/microsoft-text-odbc-driver/

Standard:

=======

Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=c:\txtFilesFolder\;
Extensions=asc,csv,tab,txt;

64 bit:

====

Driver=Microsoft Access Text Driver (*.txt, *.csv);Dbq=c:\txtFilesFolder\;
Extensions=asc,csv,tab,txt;

Could you please help me with using 64 bit ODBC driver connection to text files, using connection string only.


Hems

2 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Problem is solved thanks.
Hems

2 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated February 7, 2025 Views 7,901 Applies to: