plugin truble

[vook]

Please, tell me how to use plugin sqllink.exe with ms access.

in the "Control Panel->Performance and Maintenance->Administrative

Tools->Data Sources (ODBC) i add dsn AC with ms access driver

and browse database db1 with table tb1

in IVM: SQLLink.exe AC insert into tb1 in db1 (oper,number,summ)

values (%oper%,%number%,%summ%)

SQLLink.exe will return either 'Error'

if i write SQLLink.exe Ac select number date from tb1

system get error messege and shutdown sqllink.exe

 

My system Win NT 5.1 build 2600

i think its very simply, but i dont know how to use this plugin and sql

requests.

[chinoy]

Please, tell me how to use plugin sqllink.exe with ms access.

in the "Control Panel->Performance and Maintenance->Administrative

Tools->Data Sources (ODBC) i add dsn AC with ms access driver

and browse database db1 with table tb1

in IVM: SQLLink.exe AC insert into tb1 in db1 (oper,number,summ)

values (%oper%,%number%,%summ%)

SQLLink.exe will return either 'Error'

if i write SQLLink.exe Ac select number date from tb1

system get error messege and shutdown sqllink.exe

 

My system Win NT 5.1 build 2600

i think its very simply, but i dont know how to use this plugin and sql

requests.

<{POST_SNAPBACK}>

Not sure if you got your answer...

To get this plugin to work, you'll have to specify the name and path of the sqllink.exe in the RUN EXE section

In the With Arguments Section:

1. enter the dsn name (in your case AC)

2. Type the sql query

 

It works for me, though I don't do any inserts

[Guest Guest]

Not sure if you got your answer...

To get this plugin to work, you'll have to specify the name and path of the sqllink.exe in the RUN EXE section

In the With Arguments Section:

1. enter the dsn name (in your case AC)

2. Type the sql query

 

It works for me, though I don't do any inserts

<{POST_SNAPBACK}>

 

Make sure you separate the dsn from the sql statement. I found the iunstruction on had put them on the same aurgument line. put them on separate lines.