Hi
I have an application that connects to a SQl database on my computer
via an ADODB connection:
ADODB.Connection Conn = new ADODB.Connection();
Conn.ConnectionString = ("Driver={SQL
Server};Server=4P-12.Leighton.local;Database=HD;Uid=l0073;Pwd=cheese ");
Conn.Open(dbconnection, "", "", -1);
ADODB.Recordset rs = new ADODB.Recordset();
rs.Open("SELECT * from [HD-Users]", Conn,
ADODB.CursorTypeEnum.adOpenStatic,
ADODB.LockTypeEnum.adLockBatchOptimistic, 1);
This works fine when running from the code, or even deploying it and
installing on my machine.
However whenever i install it on someone elses machine, it installs
fine, but when it gets to the part where it connects to the DB it fails
and says "Invalid connection string attribute"
Ive been looking about the net and all i really found was that in
c:\windows\assembly i have something called ADODB, but this isnt
present on the other machines ive installed it on.
Any ideas?