'Insufficient base table information' using ADP's connectionstring

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ocliff - 21 Feb 2006 13:21 GMT

Hi,

I'm adding and updating some rows in my ADP. I get an error on rs.Update...
(ADODB)

Does anyone know why I get the 'Insufficient base table information'-error
when I use the ADP's connectionstring? (Only when I use a client side cursor.)

CurrentProject.Connection.Connectionstring:

Provider=Microsoft.Access.OLEDB.10.0;Persist Security Info=True;Data
Source=SERVER\INSTANCE;Integrated Security=SSPI;Initial Catalog=DATABASE;Data
Provider=SQLOLEDB.1

This one works:
Provider=sqloledb;Data Source=SERVER\INSTANCE;Initial
Catalog=DATABASE;Integrated Security=SSPI;

Just curious, I would really like to know!

Reply to this Message

Sylvain Lafontaine - 21 Feb 2006 17:31 GMT

Are you trying to set the connection string directly or if you are calling
CurrentProject.CloseConnection() followed by a call to
CurrentProject.OpenConnection(strConnect, user, password)?

CurrentProject.CloseConnection
CurrentProject.OpenConnection connectionString, user, password

And when opening the connection, don't use the version with the
Microsoft.Access.OLEDB.10.0 provider; as this will be set up automatically
by Access. Access (or ADP) opens three connections (and sometimes more)
when connecting to the SQL-Server and it is possible that with your method,
all these connections aren't set up correctly.

More info:
http://support.microsoft.com/kb/q240293/

http://support.microsoft.com/kb/281784/

Signature

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

> Hi,
>
[quoted text clipped - 18 lines]
>
> Just curious, I would really like to know!

Reply to this Message