Re: Problem with append query - memo field
- From: nujcharee@xxxxxxxxxxxxxx
- Date: Fri, 30 Nov 2007 00:23:30 -0800 (PST)
On 29 Nov, 18:33, Rich P <rpng...@xxxxxxx> wrote:
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 Developersdexhttp://www.developersdex.com***
I am not familiar of ADO, only refer to ADO in asp file when I try to
connect to DB. How to do this in MS Access?
Thanks
.
- References:
- Problem with append query - memo field
- From: nujcharee
- Re: Problem with append query - memo field
- From: Rich P
- Problem with append query - memo field
- Prev by Date: Re: SQL to count the number of nulls in a column
- Next by Date: Re: how to print the last page
- Previous by thread: Re: Problem with append query - memo field
- Next by thread: Re: Problem with append query - memo field
- Index(es):
Relevant Pages
|
