 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server CE / June 2008How to connect SQL CE with Delphi 7
Hi, all, I installed the latest SQL CE3.5 and could create table with SSMSE, but Delphi 7 could not find the database driver at all, although I could connect to the database file through creating an OLE object rather than drop an ADO component, but those data-aware components could not use this connection. Is there any way to connect SQL CE 3.5 with non .Net application? Thanks, Jack Zhong Jack, You can use OleDb to connection to SQL Compact from non-.NET apps. Ginny Caughey Device Application Development MVP > Hi, all, > [quoted text clipped - 9 lines] > > Jack Zhong Hi, Ginny, > You can use OleDb to connection to SQL Compact from non-.NET apps. I could not get table name through this connection, if possible, could you please give some sample codes? Jack Jack, Are you able to connect successfully in general? If so, you can get the table names by using Select * from Information_Schema.Tables. This will give you all the table names in the database. Ginny > Hi, Ginny, > [quoted text clipped - 4 lines] > > Jack .. thanks' every body where can find the oledb driver for delphi7? > Jack, > [quoted text clipped - 12 lines] > > > > Jack The OleDb driver for SQL Compact is part of the SQL Compact download. Ginny Caughey Device Application Development MVP > .. thanks' every body > where can find the oledb driver for delphi7? [quoted text clipped - 17 lines] >> > >> > Jack can give me a download link? i down SQL Server Compat 3.5 and SQL CE 2.0 install on my computer but not find the provider thank's ! > The OleDb driver for SQL Compact is part of the SQL Compact download. > [quoted text clipped - 22 lines] > >> > > >> > Jack i use " SQL Server Data Access Components " conenct sql compact thank's every one > can give me a download link? > i down SQL Server Compat 3.5 and SQL CE 2.0 install on my computer [quoted text clipped - 28 lines] > > >> > > > >> > Jack |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.