Inserting To Db

[Guest DashboardResearch]

i tried a simple query to insert values into a database, i am getting no errors but the script doesn't update the database, i have attached the script please help.

datascript.vgs

[CSI]

I think your issue is the connection string. Granted, I don't use MDB files, I use SQL through ODBC. If you set up a DSN for this connection through, it should work the same.

 

My data source name is the name of the DSN.

The connection string is: ODBC;UID=userid;PWD=password;

[SupportTeam]

See the examples in Help file which show how to connect to various databases.

 

For a simple MS Access connection just specify the filename and leave the 'Connect' string blank.

[Guest DashboardResearch]

How do i connect to SQL server Express Editon 2005

 

is it

DASH3\SQLEXPRESS for the database

 

and

 

Driver={SQL Native Client};Server=DASH3\SQLEXPRESS;Database=Eskom;Trusted_Connection=yes;

 

for the connection string

 

i am trying this and its not working

[SupportTeam]

You should consult the particular database's manual for information on what Connect string the particular database accepts.