I just installed TeamViewer on the server for Joel to look at a DGLux configuration, maybe we can figure out a plan for you to connect the same way. Thanks!

Jordan

Thanks for the reply! My apologies, I had already changed it to column based and back again in testing. Changing it to column based didn't get me any data point values either.

I decided to test connecting to a local MySQL database to simplify things. I believe I found a bug with having multiple SQL data sources, I can extrapolate on that if you wish but that's outside of this conversation. Connecting to my local MySQL database yields the same effects- the test "Excecute" function in the data source setup screen gives me results, but the test data point that I set up doesn't ever get a value.

Please see the updated screenshots and advise if you have any ideas. The local database is the one that we're interested in connecting to ultimately. Thanks,

Jordan

Attachment: download link

Hi Matt-

I tried the row-based query and the data point still doesn't read the value in the database. I'm wondering if there's a timeout for requesting the value because the database I'm testing against is pretty slow. It might take a couple of minutes to return a query response. See my setup in the attachments, they show that we can get a test execution and are connected to the database. The data point hasn't generated any values in the weeks that I've had it set up. Can you spot any problems in the way the data point is configured? Thanks,

Jordan

Attachment: download link

Hi Matt, thanks for the reply. I tried the row-based query and am still not seeing data. Does the "Update statement" section need to have a select statement even if it isn't updating (inserting to) the database? I tried it both with and without a select statement in the update statement box and didn't get data either way.

If the answer is in documentation, can you point me to the right section? See the attached screenshot for the execute test returning results but the same query in the "Update statement" section of the data point not getting anything. Let me know if you have any ideas. Thanks,

Jordan

Attachment: download link

Hi all-

I'm trying to get a sample of data from an SQL data source with a query that works in the execute test on the data source screen, but the same query in the data point settings doesn't get a value.

Take a look at the attached screenshots, the update time is 5 min but after waiting 30 minutes with the data point enabled no values write to the point history. Has the current version of M2M2 been tested with the SQL data source module? Might this be a configuration or script issue? Thanks,

Jordan

Attachment: download link

Hi all-

I'm trying to get a sample of data from an SQL data source with a query that works in the execute test on the data source screen, but the same query in the data point settings doesn't get a value.

Take a look at the attached screenshots, the update time is 5 min but after waiting 30 minutes with the data point enabled no values write to the point history. Has the current version of M2M2 been tested with the SQL data source module? Might this be a configuration or script issue? Thanks,

Jordan

The information in your link appears to have allowed me to connect with a slight change. I had to change integratedSecurity to false, when it was true I got the error com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication.

For others out there who may be attempting to connect to a MS SQL (in this case 2008), here are the settings that worked for me.

Driver class name: com.microsoft.sqlserver.jdbc.SQLServerDriver
Connection string: jdbc:sqlserver://10.165.3.192;database=ExternalLog;integratedSecurity=false;
Username: database login UID
Password: database login PW

Of course, you'll have to customize the connection string to your database server name/IP and database name.

Thanks Matt!

Thanks Matt! That allowed the software to get past the driver class loading. It now generates an error for the next line, connection string.

10:59:46: 'VISU': java.sql.SQLException: No suitable driver found for Server=10.165.3.192;Database=ExternalLog;User Id=dcstats;Password=xxxxxx;

I also tried the trusted connection string example, Server=10.165.3.192;Database=ExternalLog;Trusted_Connection=True; and it generated a similar error.

11:07:32: 'VISU': java.sql.SQLException: No suitable driver found for Server=10.165.3.192;Database=ExternalLog;Trusted_Connection=True;

I got the connection string from this [url=http://www.connectionstrings.com/sql-server-2008]SQL connection string example page.
Is there a different connection string I should be using? Thanks for your help,

Jordan

Hi all-

I'm attempting to use an MS SQL database as a data source in Mango M2M2. Normally to connect to SQL using a database browser I only need the servername/IP, userid and password. Mango has a couple of other properties that I'm not certain as to what needs to be entered or if additional setup is required to use SQL as a data source.

For the driver class name, I'm using the standard com.microsoft.jdbc.sqlserver.SQLServerDriver. For the connection string I have Server=10.165.3.192;Database=ExternalLog;User Id=dcstats;Password=xxxxxx;

When I start the data source, I get this error: 10:35:30: 'VISU': java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver

What does the classnotfound exception mean? Am I missing something in the java setup? Thanks,

Jordan

Hi all-

I'm attempting to use an MS SQL database as a data source in Mango M2M2. Normally to connect to SQL using a database browser I only need the servername/IP, userid and password. Mango has a couple of other properties that I'm not certain as to what needs to be entered or if additional setup is required to use SQL as a data source.

For the driver class name, I'm using the standard com.microsoft.jdbc.sqlserver.SQLServerDriver. For the connection string I have Server=10.165.3.192;Database=ExternalLog;User Id=dcstats;Password=xxxxxx;

When I start the data source, I get this error: 10:35:30: 'VISU': java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver

What does the classnotfound exception mean? Am I missing something in the java setup? Thanks,

Jordan