What a nubie! :blush: Solved creating a Veiw against the Linked Server Table

CREATE VIEW XFiles

AS

SELECT [All the field names],

FROM [NAV.RESOURCES.COM]..[NAV_DBA].[NV_VIEW]

The SSMS would remove the square brackets,...

Found an Oracle DBA. He validated that my registry had 2 installations. Caused a criss-cross of tools vs SQL Providers.

So, we deleted both of them and the directories, rebooted.

His approach...

Yes, the 64 bit ODAC, I re-registered the DLL with the WOW-64 as many report the Oracle installer isn't dependable.

The Oracle Net Configuration Assistant and Net Manager both show...

I am back and struggling again. Suspecting there is a step missing before the script is run?

They dropped the server before I could connect. Now, have a new...

Great Points, thanks:

First two every Friday afternoon manually with review of the results.

The Recovery Model is SIMPLE so Log files are not used.

Nightly backups.

Then those are used for a Test Database to insure they actually work

Thanks for the tips!

My Access 2010 application uses DSN-Less linked tables with the SQL Server Native Client 11.0

Just finished a form in Access that creates a new record.

An after update trigger on the...

http://sqlblog.com/blogs/hugo_kornelis/archive/2012/05/20/t-sql-user-defined-functions-the-good-the-bad-and-the-ugly-part-1.aspx

Thanks again! I was on the phone talking to my friend, a very senior SQL programmer who was waiting for his flight.

Was reading the article above and coming...

Yes it is an integer.

What I am attempting to return is a True / False (meta data) - not the actual records.

THANKS!! A function - why didn't I think...

Fantastic point! Thanks.

In this case, the Add New entity is done manually and requires a dozen requirements before the single record can be updated.

However, your example helps with another transaction...

Didn't get any suggestions. This worked fine.

First - created a table - Then create a trigger that after a new record is appended, it takes the latest new Primary key...

http://www.microsoft.com/en-us/download/confirmation.aspx?id=29065

Then expand the Install Instructions - about half way down the SQL Server Native Client 11.0 for 32/64 bit downloads.

Thanks! That doesn't come up with Google or Bing....

My post on SQL Server Native Client 11.0 for MS Access

http://www.access-programmers.co.uk/forums/showthread.php?t=247756

SQL Linked Tables are always much faster than Access linked tables for me.

Here is my short list...

1. http://www.connectionstrings.com/Pro...oledb-provider

Download

OLE DB Provider (SQL Server Native Client 11.0 OLE DB Provider) can be downloaded here (see next step).

2. http://www.microsoft.com/en-us/downl....aspx?id=29065

This downloads the following Text file:

SQL...

Can our client workstation development using SQL Server Native Client 10.0 be upgraded to SQL Server Native Client 11.0?

Where would that download for Native Client 11.0 (32 bit) be found?

Can...