Example for connection to MS SQL Server / MacroScheduler 10

[matthiasR]

Hi,

could someone give me an example, how to connect to an MS SQL Server and doing a "select" using the new db feature in MacroScheduler10.

Regards,

Matthias

[Marcus Tettmar]

You just need the appropriate connection string for your MS SQL Server in the DBConnect line. Otherwise everything else is the same. Read your SQL Server manual to see what the connection string is.

Or use Google:

http://www.google.com/search?q=MS+SQL+S ... ion+String

[matthiasR]

Thanks for the hint.

The following script works

Code: Select all

DBConnect>Driver={SQL Server};Server=192.168.168.33;Database=sale;Uid=sa;Pwd=12345;,dbH
DBQuery>dbH,select * from AEL where aranummer =10,rset,NumRecs,NumFields
dbclose>dbH

While the following script does not return any result

Code: Select all

DBConnect>Driver={SQL Server};Server=192.168.168.33;Database=sale;Uid=sa;Pwd=12345;,dbH
DBQuery>dbH,select aranummer, artyp from AEL where aranummer =10,rset,NumRecs,NumFields
dbclose>dbH

It works also with one fieldname after select

Code: Select all

DBQuery>dbH,select aranummer from AEL where aranummer =10,rset,NumRecs,NumFields

The failing select expression works in SQL ServerManagementStudio.

Am i doing something wrong?

Regards,

Matthias

[Marcus Tettmar]

Your SQL has commas in it. So do this:

Code: Select all

DBConnect>Driver={SQL Server};Server=192.168.168.33;Database=sale;Uid=sa;Pwd=12345;,dbH

Let>SQL=select aranummer, artyp from AEL where aranummer =10

DBQuery>dbH,SQL,rset,NumRecs,NumFields

DBClose>dbH

I think it's more readable to put the SQL in a variable anyway.

I have just written a blog post about the new DB commands here:
http://www.mjtnet.com/blog/2008/04/15/u ... functions/

[matthiasR]

I missed the commas in the sql expression. You are absolutely right: Its better to put the sql statement in a variable.

Thanks,

Matthias