UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Error Connection SQL Odbc, Access 2013    
 
   
carlo
post Nov 8 2017, 12:15 PM
Post#1



Posts: 86
Joined: 12-February 15



Hi

i have problem with connection odbc on my server SQL, this code VBA in my computer with so windows 7 it work, it's OK, but same procedure on other pc with so windows 10 i have this error when connect table

this is a string

dim strConnectionString as string

strConnectionString = "ODBC;DRIVER=SQL Server; " & _
"SERVER=server\EVIN;DATABASE=CONTABILE;UID=SA;pwd="

DoCmd.RunSQL "drop table " & "dbo_listino"
DoCmd.TransferDatabase acLink, "ODBC Database", _
strConnectionString, acTable, "listino", "dbo_listino"


this is error

SQLSTATE :"S1000"
ERROR SQL:0
IMPOSSIBLE CONTEST SSPI


I Have tried odbc SQL server driver 13 for SQL server but have same problem...


Thank
Carlo
Go to the top of the page
 
Daniel_Stokley
post Nov 8 2017, 01:43 PM
Post#2



Posts: 246
Joined: 22-December 14
From: Grand Junction, CO, USA


Hello,

It might be an ODBC connection problem, then again, maybe not.
In your DoCmd.RunSQL statement, you refer to a table named "dbo_listino". Should that be "dbo.listino"?

I ask because typically in SQL Server, the separation character between the schema and table name is a period, not an underscore.
Go to the top of the page
 
BruceM
post Nov 9 2017, 08:21 AM
Post#3


UtterAccess VIP
Posts: 7,022
Joined: 24-May 10
From: Downeast Maine


When you link to SQL Server tables, "dbo_" is added as a prefix, which is the name you would use when, for instance, using the table in a local Access query (unless you changed the linked table name, of course). However, when working directly with SQL Server tables it would be dbo.TableName.

I'm new to SQL Server, so I'm not sure if that has anything to do with the problem, so I won't say any more about that, but I would like to mention that the techniques described in this article by Doug Steele, which describes setting up a DSN-less connection, has been invaluable to me.
Go to the top of the page
 
carlo
post Nov 10 2017, 03:28 AM
Post#4



Posts: 86
Joined: 12-February 15



Hi

Same program code in the computer with so Windows 7 it's ok

i think the problem depend on the operating system...

I do tests and I let you know

Thank
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    18th December 2017 - 05:42 AM