Connection Wizard or Hardcoding datasource


Author
Message
Mike Thomas
Mike Thomas
StrataFrame Beginner (36 reputation)StrataFrame Beginner (36 reputation)StrataFrame Beginner (36 reputation)StrataFrame Beginner (36 reputation)StrataFrame Beginner (36 reputation)StrataFrame Beginner (36 reputation)StrataFrame Beginner (36 reputation)StrataFrame Beginner (36 reputation)StrataFrame Beginner (36 reputation)
Group: Forum Members
Posts: 26, Visits: 82
i am using sql server ce 3.5  my oledb provider is Microsoft.SQLSERVER.CE.OLEDB.3.5.  how do i modify appmain.vb to use this?  i don't think the connection wizard handles this but i could be wrong.  can someone step this beginner through whats necessary to hook my app up to the compact edition? 

Thanks in advance!

Mike

Replies
Ivan George Borges
Ivan George Borges
Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)
Group: StrataFrame MVPs
Posts: 1.9K, Visits: 21K
Hey Mike.

Try the following:

  1. Close down all Visual Studio Instances
  2. Open two Explorer Windows.  Navigate one to the "C:\Program Files\MicroFour\StrataFrame Source Code\MicroFour StrataFrame Base\bin" folder and the other to the "C:\Windows\Assembly" folder.
  3. select the "MicroFour StrataFrame Base.dll" from the bin folder
  4. Drag the selected file into the "c:\windows\assembly" folder (GAC)
  5. Also copy the "MicroFour StrataFrame Base.dll" and the "microfour strataframe base.xml" to the "c:\program files\common files\microfour\strataframe" folder
  6. Your assemblies will now be on the latest build.
  7. Go back into Visual Studio

Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 7K
PS - Cowboys 21 - Eagles 30 Monday night

Well...you know, the other day Charles Hankey sent me something prior to the Browns game...and well, we know how that turned out.  So I will wait until next Tuesday before I say too much...but when the Boys win w00t ... then I will have more to say BigGrin

Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 7K
Oh...and Ivan's suggestions look good, Mike BigGrin
Mike Thomas
Mike Thomas
StrataFrame Beginner (36 reputation)StrataFrame Beginner (36 reputation)StrataFrame Beginner (36 reputation)StrataFrame Beginner (36 reputation)StrataFrame Beginner (36 reputation)StrataFrame Beginner (36 reputation)StrataFrame Beginner (36 reputation)StrataFrame Beginner (36 reputation)StrataFrame Beginner (36 reputation)
Group: Forum Members
Posts: 26, Visits: 82
Thank you will try. 

Do you know if by getting that error that anything was rebuilt?  do i need to take out the post build event out to get it to rebuild successfully first?

Thanks again everyone!

Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 7K
Well, Ivan was telling you how to get back to ground zero.  The AfterBuild.bat file is actually distributed with the source code, but the PostBuild event is just looking for it on the c:\ folder.  So you can copy the AfterBuild.bat to the c:\ and then it will work from that point forward.

Secondly, you should not be changing the SF source code, which it sounds like you are doing.  You should create your DbDataSourceItem in one of your assemblied, not the SF base assembly.  You NEVER want to change the SF source if you plan to ever receive another update.  This is why you want to create your own base assembly which references the SF Base and then either inherit and override logic or create your SF inherited classes there so that when you get a new version of SF it doesn't wipe out your code and require you to go back and keep putting things in.

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
Mike Thomas - 18 Years Ago
Trent L. Taylor - 18 Years Ago
Mike Thomas - 18 Years Ago
Greg McGuffey - 18 Years Ago
Mike Thomas - 18 Years Ago
                         I just searched through the object browser and I don't find this...
Greg McGuffey - 18 Years Ago
                             Thanks. I hope Trent can clarify for us.
Mike Thomas - 18 Years Ago
Keith Chisarik - 18 Years Ago
Keith Chisarik - 18 Years Ago
             I hope someone can help soon:) :)
Mike Thomas - 18 Years Ago
Keith Chisarik - 18 Years Ago
Mike Thomas - 18 Years Ago
Ivan George Borges - 18 Years Ago
                         [quote]PS - Cowboys 21 - Eagles 30 Monday night [/quote] Well...you...
Trent L. Taylor - 18 Years Ago
                             Oh...and Ivan's suggestions look good, Mike:D
Trent L. Taylor - 18 Years Ago
                             Thank you will try. Do you know if by getting that error that...
Mike Thomas - 18 Years Ago
                                 Well, Ivan was telling you how to get back to ground zero. The...
Trent L. Taylor - 18 Years Ago
Trent L. Taylor - 18 Years Ago
Mike Thomas - 18 Years Ago
Ivan George Borges - 18 Years Ago
                         Two apps i have in mind...one is for the home market and I was...
Mike Thomas - 18 Years Ago
                             Distributing SQL Express is extremely easy. In fact, if you use a tool...
Trent L. Taylor - 18 Years Ago
Trent L. Taylor - 18 Years Ago
Keith Chisarik - 18 Years Ago
Trent L. Taylor - 18 Years Ago
Keith Chisarik - 18 Years Ago
Keith Chisarik - 18 Years Ago
Mike Thomas - 18 Years Ago
Keith Chisarik - 18 Years Ago
Keith Chisarik - 18 Years Ago
Trent L. Taylor - 18 Years Ago
Mike Thomas - 18 Years Ago
Keith Chisarik - 18 Years Ago
Keith Chisarik - 18 Years Ago
Trent L. Taylor - 18 Years Ago
Marcelo Blank - 13 Years Ago
StrataFrame Team - 13 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search