Windows 10: Not able to create Redshift DSN connection through the Add-OdbcDsn cmdlet

Hello all,When I'm trying to create the DSN connection for Redshift facing the below error, tried many articles, but didn't get proper help, Can you please someone help to close my issue?Articles followed :https://community.spiceworks.com/topic/2107667-powershell-odbc-connection-with-username-password https://learn.microsoft.com/en-us/answers/questions/48993/add-odbcdsn-timeout-with-amazon-redshift-x64-drive.html https://support.jda.com/s/article/How-to-save-password-for-an-ODBC-connection-to-suppress-the-constant-prompting?language=en_US https://social.msdn.microsoft.com/Forums/en-US/27da981

:)

 

Can't create System DSN (ODCB, Microsoft Access Driver)

I have a new pc and I'm trying to configure everything the same as it was on the system it's replacing. I need to create a 2 system dsn in order for my fedex shipping software to grab order data. On my old PC this was extremely straightforward, I would go to create the dsn and from the "drives" drop down, I could choose my existing mapped network drive and select the database that I need.

Both PC's are windows 10 pro. I've configured the mapped network drive, but it's not listed in drives drop down on dsn creation window.

If I instead delete the existing mapped network drive, and click the "network..." button. I can create a mapped network drive and select my accdb file. However in doing so and clicking okay, 1 the mapped network doesn't show up in "this pc" and 2, the dsn I created does NOT show up in the system dsn tab.

If I try to create it again, I do see my mapped network drive int he drives list, which is nice BUT when I click okay after choosing the database, it says "the datasource named "mydsn" already exists. Replace it with this definition?

If I choose Yes, it still doesn't show up in the system DNS list. Nor can my fedex program find it. It MUST be in the list in order for my fedex software to use it.

Incidentally, even on the originally PC, I can no longer create any NEW system DSN using Microsoft Access Driver(*.mdb, *accdb) ACEODBC.DLL.

On both pcs, the only thing that I can successfully create is a Driver do Microsoft Access (*.mdb) ODBCJT32.DLL . Although that will work for one of my needs, the other is an accdb. And while I have tested creating one with this driver and choosing the accdb anyway, fedex can't use it.

 

Can we create DSN on Windows 10 Home Edition

I Have created a DSN in Windows 10 64 bit Home edition , but after creating when I am trying to print page from my application, its not go through. The DSN is successfully connected and test successfully.

Is there is any access issue in Home edition, as I have successfully tested in W 10 Pro 63 and 32 bit both.

 

I .cannot connect to windows exployer because server is connected to dsn. What is DSN

I cannot connect to my Internet Exployer because it is using a DSN server,what is that.