hjælp til ODBC forbindelse til Oracle

Just to make sure I understand the problem.
You sya that if the linked table name contains æ,ø,å then you cant open the table, is that correct?

Have you tried altering the name of the table? What you see in the database windows is just an alias.

It's not possible for me to change the name of the tables, because I'am getting the tables from our oracle datawarehouse. But shouldn't it be possible to get an ODBC connection that can handle æøå?

When you link a table via ODBC you can alter the alias name by right clicking on the name in the database window (in Access) and choosing rename. The ODBC connection should, I would have thought, have no problem with æøå, but its never a good idea to use special characters in object names.

You could also take a look at th efollowing link which may also be the reason for your error.

http://support.microsoft.com/kb/295172

Nothing seems to help, and I know it's a bad idea to use speciel characters, but it's not my choose. Do you have any other ideas? I have seen your link and that didn't seem to be the problem.

did you change the name?

Make a view on the Oracle server and use the view instead of the table.

Whar error do you actually get?

Jeg har klaret den, det viste sig at være en miljøvariabel der ikke var sat rigtig.

Men mange tak Terry for dine inputs


/Vante