Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Using SQL server 2005 instead of Access database with VB6 Application

Posted on 2007-08-04
4
Medium Priority
?
205 Views
Last Modified: 2010-03-19
hi;
I'm using VB6 with Access database and I was working though this connection :
con.Open "Driver={SQL Native Client};Server=IT-professional\sqlexpress;Database=WH;Uid=sa;Pwd=Admin_1Nt4"

to sue it through the data base by this way:
RF.Open " Select Cust_Code From Customers ", con, adOpenKeyset, adLockPessimistic

and it was working 100% but now I switched to SQL Express 2005 but I want to know are I have to change the SQL statments I was using for Access or can work with SQL server.  

thanks  

Mostafa
0
Comment
Question by:Mostafa_ElSadek
  • 2
  • 2
4 Comments
 
LVL 33

Expert Comment

by:hongjun
ID: 19633392
Basically there's not much to worry.

But there's a difference between SQL Server and Access when it comes to dates.
In SQL Server, we use single quotes as delimiter around date values but in Access, we use #.

hongjun
0
 

Author Comment

by:Mostafa_ElSadek
ID: 19633844
ok man I'll start to change it in my application but would you please advice are the SQL Express 2005 slower than Access database for data processing.

thanks  

Mostafa
0
 
LVL 33

Accepted Solution

by:
hongjun earned 2000 total points
ID: 19633859
It's in fact faster.
It's more scalable as well.

hongjun
0
 

Author Comment

by:Mostafa_ElSadek
ID: 19633864
ok man thanks for help it is realy helped so much
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question