Claus,
If you have set up your config file correctly (looks ok, did you use the
horrible UCI Config editor to make sure it is saved in the right place ?)
your connection string should just read:
"Provider=IBM.UniOLEDB.1;Persist Security Info=False;Data
Source=TESTFAMIS;Password={your_password_here}"
To test this outside of Delphi, try the following bit of VBScript
(open notepad, paste in and save as test.vbs. That extension should be
associated with WSCRIPT.EXE ...)
Dim dbConn
Dim dbCmd
Dim dbRS
Set dbConn = CreateObject("ADODB.Connection")
dbConn.ConnectionString="Provider=IBM.UniOLEDB.1;Persist Security
Info=False;Data Source=TESTFAMIS;Password={your_password_here}"
dbConn.Open
Set dbCmd = CreateObject("ADODB.Command")
Set dbCmd.ActiveConnection = dbConn
dbCmd.CommandText = "SELECT * FROM {your_test_table_here}"
Set dbRS = dbCmd.Execute
dbRS.MoveFirst
Msgbox dbRS.Fields(1)
Not the best VBScript in the world but it should fall over quickly if there
are errors <grin>
Brian
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
