thats cleared it up for me.

Thanks

Danny

Sorry, its works in the editor but the same error from Excel for both drivers.

Thanks

Danny

I tried the MS driver and get the same error.

Thanks

Danny

Just tried the Microsoft driver and get the same error (with the space aswell).

Thanks

Danny

It works in SQL editor with the space. Not keen on changing the driver, will be my last resort.

Thanks

Danny

Yes it did.

Thanks

Danny

That did'nt work. Different error, "Could not add the table 'ORACLECONNECTION.'."

Thanks

Danny

The query is exactly the same as the one thats runs in SQL Server Management Studio (all upper case).

Cheers

Danny

Hi Vj

Yes I was intending to join the Oracle and SQL Server tables.

Thanks

Danny

I am only talking hypothetically. Lets assume a domain controller has been compromised. A domain admin could then access the SQL box. If the SQL box was not part of...

I can see your point and would follow policy on a new install (this has just been introduced). The problem is SQL Server is installed on the system drive with...

I always place the user data and log files on a seperate disk. I may start doing this for the system databases aswell. But I think I will keep the...

SQL was installed on the d drive on another server by a third party. Our network administrator seems to think it is best practice to do so. For consistency he...

Just the user databases.

Regards

Danny

Greg,

Thanks. Enabling the package logs revealed a permissions error reading an sql table with the asp.net account.

Thanks again

Danny