Unable to access ODBC data source...

dboyko

Member
D
Join Date
Apr 2008
Location
URUGUAY
Posts
17
The task is: I want to redirect FactoryTalk log to ODBC.

All Rockwell software at one computer. And SQL Server at another computer. (Don't use domain or IP Sec. Policy.)
I have access SQL Server by the Rockwell Diagnostics Setup Utility and have created table "Diagnostic" (). So it is OK.
But FactoryTalk Diagnostics Viewer gives messages are:

1. Unable to access ODBC data source hmilog; SQL Server not exists or access denied. ConnectionOpen(Connect()).

2. The Log Export Server was unable to connect to the database 'hmilog'.

(Note: 1. hmilog is the name of data source 2. We have the access form this computer and from Rockwell Diagnostics Setup Utility)
 
Last edited:
I found the same problem but without any answers...

I found the same problem but without answer...


After SQL server on the secondary computer, I double-clicked the Data Source in Administrative Tools. When Data Sources opened, I clicked on the "System DSN" tab and there is a new data source named, localserver. I changed the name and clicked finish. Clicked on "Test Data Source..." on the next pop-up and it was successful.

Then I created a new data source(same name as the secondary computer) on the primary computer. Entered the secondary computer name (WS2) for Server: field. After that, I clicked "Test Data Source..." However, it failed on primary computer. The error message was
"Attempting connection.
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied."

The computers are in a workgroup. Could this be a problem? Also the SQL Server is a Personal Edition. Could this be the problem? The reason I use personal edition is the operating is Windows XP. I have the Standard Edition, but it does not work with Windows XP.
Click to expand...
 

Similar Topics

D
Unable to Access ODBC Data source
Hello guys! Good day Everyone! We have a problem on the FTView Studio DataLog. I've created two different Bit of Data source (ODBC) which are the...
Replies
2
Views
5,458
DarrenG
D
A
Unable to access 1769 AENTR card through 1783 NATR Card
Dear All, If you could please help me with the following issue it would be very helpful. Trying to solve this for the last week. I've a L33ERM...
Replies
3
Views
1,240
aawilliams85
A
M
FTV Unable to access alarm configuration for server due to security access violation
Title pretty much says it all. Just when you think you've hit every FTView landmine, bam. Using V10 SE Local Station. When I create a Tag Alarm...
Replies
5
Views
7,100
Kalai_h4
K
A
Unable to access runtime in GE Funac system
Hi, I am using a Versamax PLC with Proficy Machine Edition 5.90. I have successfully downloaded a logic in the controller without any errors and...
Replies
6
Views
4,310
Jake0360
J
P
Unable to access only Read write addresses of AB Micrologix 1400 from OPC server.
I have been using dotnet and OPC servers (NI and Kepware) to communicate with Allen Bradley Micrologix 1400 PLC on different environmental...
Replies
2
Views
5,786
paul56
P
Back
Top Bottom