Re: Problem with append query - memo field
- From: Rich P <rpng123@xxxxxxx>
- Date: 29 Nov 2007 18:33:53 GMT
I will guess you are connected to the Oracle DB using ODBC. This is the
bottlenect. With ODBC you wont get more than 255 chars. To get around
this limitation you need to connect to the Oracle DB using ADO.
Here is a sample connection string you could try:
Dim cmd As New ADODB.Command, RS As New ADODB.Recordset
cmd.ActiveConnection = "Provider=OraOLEDB.Oracle;Data
Source=MyOracleDB;User Id=myUsername;Password=myPassword;"
Set RS = cmd.Execute("Select * From tblx")
Note that you will have to use PL Sql (Oracle sql) for the ADO command
text. The nice thing about ADO is that it can translate PL Sql,
Transact Sql (ms Sql Server) and Jet Sql.
Rich
*** Sent via Developersdex http://www.developersdex.com ***
.
- Follow-Ups:
- Re: Problem with append query - memo field
- From: nujcharee
- Re: Problem with append query - memo field
- References:
- Problem with append query - memo field
- From: nujcharee
- Problem with append query - memo field
- Prev by Date: Re: query recordset type
- Next by Date: Fastest way to do this?
- Previous by thread: Problem with append query - memo field
- Next by thread: Re: Problem with append query - memo field
- Index(es):
Relevant Pages
|
