Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Help, Oledb connection to Access database

Reply
Thread Tools

Help, Oledb connection to Access database

 
 
Randy
Guest
Posts: n/a
 
      05-14-2007
Hi,all
I met a strange problem, I connected to access database using oledb
connection, connection string like

"Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=\\Server\Public\QAD\MDB\QADData.mdb;User
ID='apiprogram';Password='35msaccessAPI';
Jet OLEDBatabase Password='1';Jet OLEDB:System
database=\\Server\Public\QAD\MDB\TFSC_BJ.mdw;
Mode=1"

In access database, there exist tables linked to antother data server
throught ODBC.

When exeucting program, I found if there is less records,for example
less than 1000, the data read without problem, but if there was large scale
records count, the program prompt "odbc error".
Why? if I should increase the ODBC Command Time Out or Max Locks Per
File properties liking in ADO connection.
But in ADO.Net, it does not support this manner, so what shall I do?


 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
DataBase DataBase DataBase DataBase scott93727@gmail.com Computer Information 0 09-26-2012 09:40 AM
OleDB Connection Problem to Access DB... =?Utf-8?B?VGltOjouLg==?= ASP .Net 0 06-15-2006 11:14 AM
MS Access OLEDB connection problem =?Utf-8?B?Uk1M?= ASP .Net 6 07-24-2004 04:18 PM
OLEDB database connection from ASP.NET Louise Hadley ASP .Net 2 04-16-2004 11:47 PM
asp.net ms-access oledb connection open error Mathew Vording ASP .Net 2 08-15-2003 05:37 PM



Advertisments
 



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57