[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.dotnet.framework.odbcnet

Re: Creating a Dataset

Jim Brent

9/9/2002 11:49:00 PM


"Jim Brent" <jim.brent@kingwoodcable.com> wrote in message news:...
> Attached is the access db. I am actually connecting to the TransData view
> (Query)
>
> My connect string is:
> OleDbConnection1.ConnectionString =
> "Provider=Microsoft.Jet.OLEDB.4.0;Password="""";User ID=Admin;Data
> Source=C:\Demo\Da" & _
>
> "ta\NewMasterDataDDD.mdb;Mode=Share Deny None;Extended Properties="""";Jet
> OLEDB:Syste" & _
>
> "m database="""";Jet OLEDB:Registry Path="""";Jet OLEDB:Database
> Password="""";Jet OLED" & _
>
> "B:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global
Partial
> Bulk " & _
>
> "Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database
> Password="""";Je" & _
>
> "t OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet
> OLEDB:" & _
>
> "Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica
> Repair=Fals" & _
>
> "e;Jet OLEDB:SFP=False"
>
> and the command string is :
>
> OleDbSelectCommand1.CommandText = "SELECT Transdata.* from transdata"
>
> Having said all that, the error occurs when the program compiles not
> executes so it is not the Access db that is causing the problem. If you
> look in the DataSet1.vb file posted with the original posting, and search
> for "'" (comment lines) you will find that the offending code was
generated
> by the IDE before the code was even compiled.
>
> "Hussein Abuthuraya(MSFT)" <HussAbOnline@microsoft.com> wrote in message
> news:mPLNCmEVCHA.1804@cpmsftngxa10...
> > Jim,
> >
> > Thanks for sending this information. I built a new table in Access
using
> your table structure. I used the exact names and data types (except
instead
> of string I used Text). I
> > was getting E_Fail error when building the DataSet because you were
using
> some reserved words as field names. The offending names are:
> >
> > System and Language.
> >
> > I changed the names to oSystem and oLanguage and I built the dataset
> successfully. Then I bound the dataset to a datagrid and I had no
problems
> running the project.
> >
> > It looks like you are doing something different either in your table or
> project. Would you like to send me your mdb file to test it here?
> >
> >
> > Thanks,
> > Hussein Abuthuraya
> > Microsoft Developer Support
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > Are you secure? For information about the Microsoft Strategic Technology
> Protection Program and to order your FREE Security Tool Kit, please visit
> > http://www.microsoft.co....
> >
> >
>
>