jpserra3 (6/15/2015)

---

I am getting an error (number -2147217887, error message "ODBC--call failed.") when I try to execute an rst.Update. I have an MS Access 2013 application using an ODBC connection...

Create LOGIN [ClarkKent] WITH PASSWORD='NotTheRealPassword'

USE [WHATEVER]

Create USER [ClarkKent] FOR LOGIN [ClarkKent]

well here's a fully tested prototype that returns two for the value

any issues you have woudl be details...the data doesn't exist, usin the wrong data types, wrong column, etc.

IF OBJECT_ID('[dbo].[member_score]')...

my quick Google-Fu tells me it's a local instance on the installed server; all i need to do is login locally to that machine and start my investigation.

http://www.sql-questions.com/microsoft/SQL-Server/32646564/cheftec-dbnetlibconnectionopen-connect.aspx

from there, i'd...

you don't put quotes around the parameter; it's already the right datatype.

your real function probably raises an error, sicne you have two variables:@tbl and @source_tbl, but only one is...

I've seen this if you copied an existing ReportServer and ReportServerTemp db from one instance and restored them on another, ie copying a backup from Production To Test OR QA.

If...

there's 86400 seconds in the day.

anything prior to exactly half that, (12:00:00) , or 43200 seconds, is AM, else PM

so a CASE WHEN seconds <43200 THEN 'AM' ELSE 'PM'...

there's multiple ways to connect ot SQL; you can see that whenever you look at the SQL configuration manager.

as i understand it, shared memory is always loca, since it's local...

wouldn't NULL be normal if the connection was over named pipes, and not TCP/IP?

i'd think that that is probably what you are seeing.

can you check within your script?

SELECT net_transport

FROM...

No.

the point is there is no need to have SSMS on the server.

you already have it local, installed...

sqlcmd.exe only? you should know better.

you can use your local SSMS GUI to connect to any version of SQL, including a remote SQL Server Core instance.

SSMS doesn't care if the...

you can kind of infer the last tiem a table was updated from the index stats, but you cannot tell what was updated, or by who.

to have that, you need...

yes, it's a firewall issue.

the firewall needs to be told that public traffic from an external ip , that is targeted to port 80, needs to go to your internal...

i think the case you have, where it's a high volume of calls to a specific proc, and it's intermittent, relaly makes me think connection pooling is the culprit, so...

the easiest fix is a simple change in the application call, so that it explicitly uses DatabaseName.SchemaName.ObjectName.

that resolves any possibilities of ambiguity where the query engine tries it's best to...