Recent need to use pb connection sqlce database (SDF), check a lot of information are not found suitable connection methods,

Anyone knows, please show it, use the ODBC connection or oledb connection can,

thank you

CodePudding user response:

I use a PB9.0.3 8836

CodePudding user response:

You go to find the ODBC driver should be ok for database vendors

CodePudding user response:

In the search into the sqlce odbc can find many solutions

CodePudding user response:

Checked the, did not check the sqlce using odbc method,

Want to use the oledb connection, also provides sqlceoledb30 sqlce. DLL for oledb connection, and seemed to use in the visual studio is the oledb connection way, but I don't know how to set up in the pb oledb connection mode, in the database profile no slqce oledb driver, don't know how to sqlceoledb30. The DLL is registered,

CodePudding user response:

UPUP, calling for help

CodePudding user response:

These two days have been check related information, all have no,

Which have been familiar with the database connection, try to help, thank you

CodePudding user response:

Ok, take a look at you, the next database study

CodePudding user response:

A quote

Sql Server 2005, Sql Server Management Studio, select the database when the connection type for Sql Server Mobile, you need to select the database file column. SDF files,

Speaking of SqlCe installation, to say I'm a little embarrassed, why? Since I just learning to use the.net Companct Framework, to come into contact with the SqlCe, at that time, there are two problems, one is the SqlCe installation, is a program package, of course I said only that the installation of the SqlCe my cough up today,
In fact also nothing, SqlCe installation is very simple, because the installation package is SqlCe an Agent, the Agent is used to set up the SQL Server and SqlCe communications on a Server Agent, the following figure (from SqlCe Book Online)

In principle, installation is called a Server Ce Server Agent management platform, the platform provides a from SQL Server SqlCe an HTTP connection to the equipment, used for data interaction,
Briefly introduce the inside of the first Point:
1, SQL Server CE Database Engine (the Database Engine)
SQL CE database engine management store in SQL Server data based on Windows CE devices, in the case of a small amount of the change of the data records, the database engine can insert, update, delete to maintain the consistency of database, by using two kinds of connection scheme to realize data synchronization function and the
2, SQL Server CE customers agency end
SQL Server CE customers agency end is a device used to connect the basic components, maintains the following several objects: duplicate objects, remote data access (RDA) and engine object, through the use of these objects, the program can programming control these SQL Server connection,
3, SQL Server CE Server agent side
SQL Server CE Server agent is responsible for dealing with customers, the HTTP request from the agent side program after the request, the client proxy client send you the request to the Server via HTTP proxy, Server proxy client connect to the SQL Server, and sent via HTTP result set to the agent, in the picture above shows no add-on also included in this process, these components are running on IIS running machine,
Merge replication (RDA) and use different methods to deal with an HTTP request, also in IIS running on the machine to use a different SQL Server connection components,
I'm a Web blind, so some concepts are not very familiar with, such as virtual directory, snapshot, HTTP transport, etc.,
Hurry back to the thesis of this article, install SqlCe the first step is to install the Server Agent, and the installation of this Agent depends on its version with essentially a version, such as your SqlServer2000 version is SP3, so you must use a SqlCeSP3 this version, SqlServer2000 is SP4 version, then you must use SqlCeSP4 this version; To be called SqlServer2000 SP3, SP4 was done by patching, about the SP3, SP4 patch on the MSDN web site under; And the installation of this patch has two parts, such as SqlServer2000 SP4, the installer will first unzip the installation file to a local directory, and then find the local directory SQL2KSP4, run inside of a batch file setup. The bat, and according to the installation steps to continue ok, oh, by the way, also must have a premise is that you have installed the IIS, because SqlCe and essentially a transmission transmitted via HTTP, now you know the importance of installing IIS,
Normally after installing the SqlCe goes straight to the SQL Server CE Connectivity Management configuration, the connection configuration Management platform is to make the Server 2000 and communications equipment, respectively to SQL Server CE Server Agent (sscesa20. DLL) to create virtual directory, the determination of HTTP authentication is NTFS permissions configuration, the configuration and configuration of the Web has a lot of similarities, is actually an HTTP connection configuration, if you are familiar with Web then you will be very easy to understand the main points of the these actions, the last one of the more important is called a Set NTFS permissions for the SQL Server the snapshot folder. The option, this option is necessary in that it can provide data transmission between Server and SqlCe a snapshot, but the snapshot is very necessary and practical operation is simple, but it is the key, as long as you are in C disk directory to create a folder and modify the folder it is ok to make its Web sharing, thus to provide equipment permission to access this snapshot file,
Here you have completely, so the installation and configuration steps are you going to do now is in the browser type http://172.0.0.101/sqlce/sscesa20.dll this path, if there is a SQL Server CE Server Agent, you can access on the equipment, of course, you want to use your own IP and virtual directory name,
Now you can use remote data access (RDA) on equipment and merge replication; Using merge replication, of course, also need some configuration, but this is beyond the scope of today's discussion,

Actually SQLCE installation is not very complex, but a more detailed description or very be necessary, this understanding Server2000 interactions with the data of the SQLCE has a lot of help,
Article source: http://www.diybl.com/course/3_program/jdkf/2007113/83116.html

CodePudding user response:

This is a mobile database, is essentially a Agent, doubt might not connect with odbc, you try the ole db

CodePudding user response:

Ha ha, thanks for your reply,

And check the along while sqlce database connection, on the sqlce English BBS see along while, look very tired, still not solve the problem,

Should be using ole db interfaces to connect, in visual studio is also using the oledb connection,

But the problem is that after installed the sqlce drive, the provider in the pb oledb connection list should have the driver interface, but no, it felt like sqlce driver did not write the registry, so cannot be used in the pb,

I check again on the Internet, Microsoft do bad things,

CodePudding user response:

5 commonly used method of SDF database operation in mobile collection
For Windows mobile SDF file of SQL, many friends will be used, method is simple, with PC operation of SQL server, Oracle etc. About the same,
Sharing a SDF operation under the database file of a class, for Mobile reference introduction to the development of new friends, welcome to leave a message to communicate,

Before using this code, need to using System. Data. SqlServerCe;



The class CESql
. {
Public void ConnOpen (SqlCeConnection Conn)
. {
If (Conn. State. The ToString (). The Trim () Equals (" Open "))
. {
Conn. Close ();
}
Conn. The Open ();
}
Public void ConnClose (SqlCeConnection Conn)
. {
If (Conn. State. The ToString (). The Trim () Equals (" Open "))
. {
Conn. Close ();
}
}

Public void the ExecuteSql (string SQL, SqlCeConnection Conn)
. {
SqlCeCommand MyCommand=new SqlCeCommand (SQL, Conn);
MyCommand. ExecuteNonQuery ();
Conn. Close ();
}

Public SqlCeDataReader GetDataReader (string strCMD, SqlCeConnection Conn)
. {
SqlCeDataReader myReader;
SqlCeCommand mycommand=new SqlCeCommand ();
Mycommand.Com mandText=strCMD;
Mycommand. Connection=Conn;
MyReader=mycommand. ExecuteReader ();
Return myReader;

}
}

CodePudding user response:

Refer to the

nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull