[Oledb-dev] pgOleDb

Alessandro Lima alessandro at ligaone.com.br
Mon Apr 10 12:37:34 GMT 2006


Konstantin,
    Here is the code.
Dim objRecordset As New ADODB.Recordset
Dim objConnection As New ADODB.Connection

objConnection.Open "Provider=PostgreSQL OLE DB Provider; Data Source=localhost; Location= MyDb", "postgres", "123456"
objRecordset.Open "SELECT * FROM pg_shadow", objConnection, , adOpenStatic, adLockReadOnly
msgbox objRecordset.AbsolutePage '// returns -1
msgbox objRecordset.PageCount '// returns -1
'// AbsolutePosition, PageSize

Alessandro - Liga One Sistemas Ltda
Rua Marins Alvarino, 150, Itararé, Vitória - ES 
CEP: 29.047-660 Tel (27)3324-4097 R 210
alessandro at ligaone.com.br
www.ligaone.com.br
  ----- Original Message ----- 
  From: Konstantin Izmailov 
  To: alessandro at ligaone.com.br 
  Sent: Monday, April 10, 2006 5:26 AM
  Subject: pgOleDb


  Hi Alessandro,
  I found your message on pgOleDB forum (about AbsolutePage, RecordCount, etc.) Could you send us a code sample in VB6 (or other language) to reproduce issues you had with the Provider?

  Thanks
  Konstantin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/oledb-devel/attachments/20060410/67f8b9e1/attachment.html 


More information about the Oledb-devel mailing list