Ok..I successfully synchronize access and sql server. Follow this step: 1.OPen your access database. 2. Go to file>get external data>link tables 3. At Files Of Type, 'choose ODBC Databases()' 4. Click new and choose 'SQL Server'. Click advanced and enter this 'DRIVER={SQL Server} DATABASE=yoursqldatabasename'. then click ok and next. 5. Enter your own datasource name ok then finish. 6. Then create datasource window will popup. choose server that locate your sql server database.Click Next 7. You can choose windows authentication or insert sql server authentication login id 8. Change default database to targeted database. Next and finish. 9. OK until popup link tables window. Choose which table you want to synchronize. 10. try update,insert and delete. Make sure both table in access and sql server update accordingly. :cool:

Hi guys, Any 1 got ideas about how to synchronize Ms Access and SQL Server (Express Edition) database. the scenario is I Create a database and a table containing a single text column for both MsAccess as well as SQL Express (DB and table name to be similar). By performing insert / update / delete on SQL Express (Source) and I must ensure that the data is updated accordingly on the database in Ms Access (Destination) as well. Vise versa. So did I need to create 2 connectionstrings , which 1 is OLEDB and another is SQL? As i know we can use same sql statement,just need to be cautious with reserve word for database command such as OLEDBCONNECTION and SQLCONNECTION.

Yup..this is web application..nvm I already issue this to my software engineer..ask him to install the correct windows version..I still did not understand y he install image windows 64bit on 32 bit machine..zzzz..thanks for your reply..=)

So mean that I need to create deployment package and install it for each user's PC..Is it problem cause by 64bit machine? Because crystal report did not support some of 64bit machine? How about If I try to add merge modules into the project?

Any 1 got solution for this error?

File or assembly name CrystalKeyCodeLib, or one of its dependencies, was not found.

Currently I try to deploy a system to 64bit machine..the system looks fine except for the crystal report. I'm using cystal report version Version=9.1.5000.0. I've googled and found some suggestion but it also cant help me..The crystal report already installed..any1 have idea for this issue?need your help ASAP.

Try this but the code is in vb,get the idea and convert to C#(if you use C#)

Private Function CheckID(ByVal strID As String)
Dim strSQL As String
Dim conn As New OracleConnection
Dim reader As System.Data.OracleClient.OracleDataReader

strSQL = "Select ID From Where ID = '" & strID & "'"
Dim cmd = New OracleCommand(strSQL , conn)
reader = cmd.ExecuteReader()
If reader.Read() Then
If reader.HasRows Then
Return True
Else
Return False
End If
Return ""
End IF

In your page load or load complete,call CheckID() and insert ID into it.

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

If CheckID("") = True Then
Response.Redirect("newpage.aspx")
Else
Response.Write("Error. There is no page ID in our database"
End If

In your form load complete(it's mean after all process has been done), you can set which checkbox that you want to focus. For example:

Protected Sub Page_LoadComplete(ByVal sender As Object, ByVal e As System.EventArgs) Handles LoadComplete

If (your condition) Then
chkExample.Focus()
ElseIf (your condition) Then
chkExample2.Focus()
End If

Good Luck..=)

Try this link..http://lmgtfy.com/?q=Ajax+Control+Toolkit+Sample+Site[^]..=D

I have no problem with either download or creating the pdf file. The problem is method that i used. I used this code to call dldata.php after i create it.

$pdf = new PDF();
// Column headings
$header = array('Product ID', 'Product No', 'Product Description', 'Subtotal#39;);
// Data load from the file and it will be=>1;#13,21321;Pencil;$1.00
$data = $pdf->LoadData('dldata.php');

I followed tutorial based on fpdf official website. Tutorial: http://www.fpdf.org/en/tutorial/tuto5.htm[^] Example for dldata.php shape of data: http://www.fpdf.org/en/tutorial/countries.txt[^] After load back to the createquotation.php,I destroy dldata.php file. I'm afraid, it will be issue if more than 2 user do this process at the same time. It will be last in,first out. Only The last data store will be appear. Can I just use dldata.php without delete it and call the data without any user can access it by type the url.

Did you google it 1st before asking here?

Maybe because of you used iframe,that's why your pop up alert at behind of the browser. At code behind after finish insert the data, create session and in successfully page,try to check session in page load and popup alert if session exist.Example: insertpage.aspx.vb

'after insert statement,create session
Session("success")="anything"

successfulinsert.aspx.vb

If Session("success") <> "" Then
Response.Write("alert(""Successfully Insert the data"")")
Session.Remove("success")
End If

Maybe my code got error because I simply write it without debug or test it 1st but that's the idea.

Crystal Reports maybe can help you..google it,dude.

Try this:

For Each r1 As GridViewRow In GridView1.Rows
txtEmpName = DirectCast(r1.FindControl("txtEmpName"), TextBox)
Next

Good luck,=).

Why not you call that asp page by using ? e.g: <iframe height="%100" width="%100" src="http://yourserver/yourfile.aspx">. But if really want to use your own method,you need to setup your http.conf and install asp extension for apache. Below are the step to run asp on your apache: 1.install Mod_AspDotNet 2.

Add at the end of C:\Program Files\Apache Group\Apache2\conf\httpd.conf the following lines
#asp.net
LoadModule aspdotnet_module "modules/mod_aspdotnet.so"
AddHandler asp.net asax ascx ashx asmx aspx axd config cs csproj licx rem resources resx soap vb vbproj vsdisco webinfo

<IfModule mod_aspdotnet.cpp>

Mount the ASP.NET /asp application

AspNetMount /SampleASP "c:/SampleASP"
#/SampleASP is the alias name for asp.net to execute
#"c:/SampleASP" is the actual execution of files/folders in that location

Map all requests for /asp to the application files

Alias /SampleASP "c:/SampleASP"
#maps /SampleASP request to "c:/SampleASP"
#now to get to the /SampleASP type http://localhost/SampleASP
#It'll redirect http://localhost/SampleASP to "c:/SampleASP"

Allow asp.net scripts to be executed in the /SampleASP example

<Directory "c:/SampleASP">
Options FollowSymlinks ExecCGI
Order allow,deny
Allow from all
DirectoryIndex index.htm index.aspx
#default the index page to .htm and .aspx
</Directory>

For all virtual ASP.NET webs, we need the aspnet_client files

to serve the client-side helper scripts.

AliasMatch /aspnet_client/system_web/(\d+)_(\d+)_(\d+)_(\d+)/(.*) "C:/Windows/Microsoft.NET/Framework/v$1.$2.$3/ASP.NETClientFiles/$4"
<Directory "C:/Windows/Microsoft.NET/Framework/v*/ASP.NETClientFiles">
Options FollowSymlinks
Order allow,deny
Allow from all
</Directory>
</IfModule>
#asp.net

3. Test it by create your index.aspx and restart apache.

Currently I'm develop an application same as CRM. To generate report in PDF,i'm using FPDF as my tools. The problem is, to retrieve the data from database,I create temporary file e.g:dldata.php and call that page in my pdf viewer file. U can access the data and easily view the actual data(if you know the address).By using explode(),I retrieve the data and display it on my pdf viewer page. The dldata.php will be delete (using unlink()) after user load the quotation form. Below are the flow to create quotation in pdf: fill form data(createquotation.php)->insert data to database->create session,dldata.php & write data into it from mysql->redirect page to viewquotation.php(here I call dldata.php)->click print quotation or back to createquotation.php & destroy dldata.php. Anyone that have experience using FPDF to advise me about this issue. I'm afraid the conflict arise when 2 or more users doing the same process at the same time. TQ. :)