Problem with connection string while creating linked tables

ramesh.elapakur

Registered User.
Local time
Tomorrow, 02:06
Joined
Mar 12, 2007
Messages
10
Hi All,

I'm new to this group and new to access also. I come across an error message "Connection string is too Long" while creating tabledef in Access using VB.
The actual procedure is to create a linked tables of Oracle in Access in locally and use the mdb fr report generation. In this porcess, while I'm trying to create a table I met that error, and i saw the connection string length , its of 256 characters, but i don't know how to come out of this problem.
One morething we're running this report from VB using the run command(macro).

Pl help me in this regard.

Ramesh
 
Break you connectionion string in to several parts (valiables) which are then concantenated.
 
the problem occurs when we say ReportDb.Append tabledef

where ReportDb is Dabase object.

Ramesh
 
PHP:
ReportDb.Append tabledef
is not valid Access syntax.
 
Sorry, it is


ReportDb.TableDef.Append tdf

before this we link connect to the ODBC database using tdf.Connect property

the code looks as follows

tdf.connect=con_str
tdf.Sourcetablename=tname
ReportDb.TableDef.Append tdf

where reportdb is Database object of jet Engine,TableDef is Table object of that Database and tdf is actual table.

Ramesh
 
ReportDb.TableDefs.Append tdf

assumes that you have appended fields to the tdf definition. Have You?

Note the missing "s" in the Access line.
 
Thanks for reply.

The problem occurs at times not always and its with connection string. Is there is any way to aviod this by reducing the connection string.

Ramesh
 
Again

PHP:
Break connection string in to several parts (variables) which are then concantenated.

It might help if you'd post your connection string.
 
Hi,

I found the reason to my problem, but need help in solving this problem.How to break the connection string of Linkeddatabase table in MSAccess.

To get the connection string of Linked database table we use the following syntax

Database.tabledef("Tablename").Connect

The above connect property has more than 255 chars,so its failing while connecting to another Access db.The main database is oracle.

Thanks in Advance

Ramesh
 
Can we break the connection string and I want to use only some part of the connection string, can we?

The connection string is as follows:
ODBC;DRIVER={Oracle in OraDb10g_home1};SERVER=new;UID=mvspcse;DBQ=new;DBA=W;APA=T;EXC=F;XSM=Default;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;GDE=F;FRL=Lo;BAM=IfAllSuccessful;NUM=NLS;DPM=F;MTS=T;MDI=Me;CSR=F;FWC=F;FBS=60000;TLO=O;;TABLE=MVSPCSE.PARTDATA

it is more than 255 characters


Ramesh
 

Users who are viewing this thread

Back
Top Bottom