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 "Jack Zhong" wrote in message news:eTxfBiruIHA.4848@TK2MSFTNGP05.phx.gbl... > 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
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 "Jack Zhong" wrote in message news:406EF40E-958F-422D-A691-E5AA25D22087@microsoft.com... > 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
.. thanks' every body where can find the oledb driver for delphi7? "Ginny Caughey MVP" wrote: > 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 > > "Jack Zhong" wrote in message > news:406EF40E-958F-422D-A691-E5AA25D22087@microsoft.com... > > 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 >
The OleDb driver for SQL Compact is part of the SQL Compact download. Ginny Caughey Device Application Development MVP "UniVAN" wrote in message news:A4D65303-EE1C-46F0-ADE0-8CB9FB2B26C2@microsoft.com... > .. thanks' every body > where can find the oledb driver for delphi7? > > > "Ginny Caughey MVP" wrote: > >> 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 >> >> "Jack Zhong" wrote in message >> news:406EF40E-958F-422D-A691-E5AA25D22087@microsoft.com... >> > 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 >>
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 ! "Ginny Caughey MVP" wrote: > The OleDb driver for SQL Compact is part of the SQL Compact download. > > Ginny Caughey > Device Application Development MVP > > "UniVAN" wrote in message > news:A4D65303-EE1C-46F0-ADE0-8CB9FB2B26C2@microsoft.com... > > .. thanks' every body > > where can find the oledb driver for delphi7? > > > > > > "Ginny Caughey MVP" wrote: > > > >> 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 > >> > >> "Jack Zhong" wrote in message > >> news:406EF40E-958F-422D-A691-E5AA25D22087@microsoft.com... > >> > 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 > >> >
i use " SQL Server Data Access Components " conenct sql compact thank's every one "UniVAN" wrote: > 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 ! > > "Ginny Caughey MVP" wrote: > > > The OleDb driver for SQL Compact is part of the SQL Compact download. > > > > Ginny Caughey > > Device Application Development MVP > > > > "UniVAN" wrote in message > > news:A4D65303-EE1C-46F0-ADE0-8CB9FB2B26C2@microsoft.com... > > > .. thanks' every body > > > where can find the oledb driver for delphi7? > > > > > > > > > "Ginny Caughey MVP" wrote: > > > > > >> 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 > > >> > > >> "Jack Zhong" wrote in message > > >> news:406EF40E-958F-422D-A691-E5AA25D22087@microsoft.com... > > >> > 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 > > >> > >
