Results 1 to 6 of 6

Thread: Switching from Access to SQL5

  1. Apr 5th, 2007, 07:59 PM #1
    longwolf
    longwolf is offline

    Thread Starter
    Frenzied Member longwolf's Avatar
    Join Date
    Oct 2002
    Posts
    1,343

    Switching from Access to SQL5

    I was asked to do a project using VB6 and MS Access.
    But now the client has decided that it needs to be done with SQL5.

    I don't have SQL and have never worked with it.

    Could I write the program on my machine, using Access till I get it debugged, then switch to SQL?
    If so, what kind of changes would need to be made?

    The program will used on several remote computers that will all connect to the same DB on a server.
    Codebank Submissions: Create/Delete Shortcuts including Special Folders like Startup , Custom MsgBox form
    Reply With Quote Reply With Quote
  2. Apr 5th, 2007, 11:21 PM #2
    sagarpassion
    sagarpassion is offline
    Hyperactive Member
    Join Date
    Sep 2006
    Location
    India
    Posts
    310

    Re: Switching from Access to SQL5

    whenever ur migrating database that time u have to take care abt connectionstring. There will not be more changes in queries cause Transact sql queries almost same. But u have to check output of the queries.
    Sagar
    VB6, VB.net,C#,ASP, ASP.net MSSQL, MYSQL
    Reply With Quote Reply With Quote
  3. Apr 5th, 2007, 11:45 PM #3
    longwolf
    longwolf is offline

    Thread Starter
    Frenzied Member longwolf's Avatar
    Join Date
    Oct 2002
    Posts
    1,343

    Re: Switching from Access to SQL5

    I just found out you can download SQL5 express for free.

    So the only difference will be the connection string?
    Can someone show me an example of an SQL connection string?
    Codebank Submissions: Create/Delete Shortcuts including Special Folders like Startup , Custom MsgBox form
    Reply With Quote Reply With Quote
  4. Apr 5th, 2007, 11:50 PM #4
    Xium
    Xium is offline
    Lively Member Xium's Avatar
    Join Date
    Jan 2007
    Posts
    78

    Re: Switching from Access to SQL5

    "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MyDatabase;Data Source=MyServer"
    Hassan Khan
    Reply With Quote Reply With Quote
  6. Apr 6th, 2007, 02:36 AM #5
    sagarpassion
    sagarpassion is offline
    Hyperactive Member
    Join Date
    Sep 2006
    Location
    India
    Posts
    310

    Re: Switching from Access to SQL5

    www.connectionstrings.com
    this will help u.. I have doubt abt queries but Trasact SQL will not affect while changing any database. There will be hardly any differance.
    Sagar
    VB6, VB.net,C#,ASP, ASP.net MSSQL, MYSQL
    Reply With Quote Reply With Quote
  7. Apr 6th, 2007, 10:44 AM #6
    Al42
    Al42 is offline
    PowerPoster
    Join Date
    Feb 2006
    Location
    East of NYC, USA
    Posts
    5,691

    Re: Switching from Access to SQL5

    But there will be differences. Don't ship until you've run it through with the database it's going to be used on.
    The most difficult part of developing a program is understanding the problem.
    The second most difficult part is deciding how you're going to solve the problem.
    Actually writing the program (translating your solution into some computer language) is the easiest part.
    Please indent your code and use [HIGHLIGHT="VB"] [/HIGHLIGHT] tags around it to make it easier to read.
    Please Help Us To Save Ana
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width