RsSQL to MySQL

csdurbin

Member
C
Join Date
Aug 2007
Location
Ohio
Posts
4
Does anyone know of a way to get RSSQL to push records to MySQL? We can get it to talk to MSSQL, but we would rather have it in MySQL.

Thanks!

C Durbin
 
That's part of the issue. I have a ODBC connection (System DSN) setup to connect to my MySQL database. It works correctly and I can connect to the database. There's 2 or 3 other MSSQL conenctions setup as well and RSSQL doesn't see any ODBC connections.

C.Durbin
 
Does RSSQL connect to MS SQL correctly?

If not it may be a connector issue.
I would run through the configuration checklist aand make sure everything is correct.

Another alternative is the OLEDB route.
RSSQL supports this type of connection too.
 
Have you looked at the number of MS Windows Server CALs (Client Access Licenses) required? Is it user based or connection based that you have set up versus what does the software require? I am not an expert but know that stopped me before with SQL databases using connection based licenses.
 
Just as a follow up; we were finally able to get RSSQL talking to MySQL through an ODBC connection. It seems to be working perfectly. It turns out we just had the data connection configured incorrectly.

Thanks for all your help!

C.Durbin
 
We're having a similar problem to the original poster, as we're trying to make RSSQL communicate with our MySQL database. When setting everything up in RSSQL, we are able to see the procedures stored on the MySQL database in the "ODBC Data Object Definition" window within RSSQL, but RSSQL cannot see any of the procedures' parameters. I have a feeling this may be because unlike in MSSQL, parameters in MySQL are not declared using the '@' symbol, but that's only a guess. Any suggestions :(?!
 
We tried getting stored procedures to work as well, but we were never successful. I don't think it's possible, like you said, due to the way parameters are defined.

C.Durbin
 
Albeit that wasn't what I was hoping to hear, thanks for sharing your experiences...makes me feel less incompetent :).
 

Similar Topics

B
RSSQL connetion to Suitelink
Hi, I am currently in need of help with regarding of the ways on how to connect RSSQL to suitelink without using 3rd party driver...your reply is...
Replies
0
Views
1,095
boknoy
B
D
Rssql issues
Hello all I am a student and also very new to PLC's and RSSQL. I have a situation where I am trying to link rslinx classic to ms sql through rssql...
Replies
7
Views
2,288
swayne76
S
B
RSSql string data point
I'm trying to get a string from the plc and store it in a database, but I can only get the first byte, I know there should be an easy solution to...
Replies
0
Views
1,920
benmwagner
B
R
RSSQL validating issue
Hi Everybody, While I am trying to start configure RSSql,I m getting Error(33190)'The service could not validated using specified username and...
Replies
0
Views
3,444
renchypjacob
R
S
RSSql OPC Data Point Setup
Hey all, I am trying to define data points in RSSql and am having some problems. I have a ControlLogix 5555 controller and an OPC topic set-up...
Replies
1
Views
3,944
skyfx
S
Back
Top Bottom