Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Making my SQL-Server based app MS Access compatible

Reply
Thread Tools

Making my SQL-Server based app MS Access compatible

 
 
Bucko
Guest
Posts: n/a
 
      11-02-2003
Hi guys,


I have an app that, right now, uses a SQL Server database and very
simple, universal SQL commands. I use SqlCommand, SqlDataReader and
SqlDataAdapter objects. I use web.config to store my database connection
string.

I want to make this MS-Access compatible. Please let me know if this is
correct and all that is needed to make my software work with Access:

1. Change connection string to reflect the Access database

2.Use "OleDb" counterparts to all SqlCommand, SqlDataReader and
SqlDataAdapter object declarations

3. Ensure I use universal SQL commands in my SQL statements (which I
have done)

4. Ensure Access database has equivelent field names and types


Is there anything else? Thanks very much for all help,

Buck

 
Reply With Quote
 
 
 
 
Steve C. Orr [MVP, MCSD]
Guest
Posts: n/a
 
      11-03-2003
Yes, that all sounds good, and I'd add this step too:

5. Test with both Access and SQL Server to make sure you've done steps 1
through 4 correctly.

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
Hire top-notch developers at http://www.able-consulting.com




"Bucko" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> Hi guys,
>
>
> I have an app that, right now, uses a SQL Server database and very
> simple, universal SQL commands. I use SqlCommand, SqlDataReader and
> SqlDataAdapter objects. I use web.config to store my database connection
> string.
>
> I want to make this MS-Access compatible. Please let me know if this is
> correct and all that is needed to make my software work with Access:
>
> 1. Change connection string to reflect the Access database
>
> 2.Use "OleDb" counterparts to all SqlCommand, SqlDataReader and
> SqlDataAdapter object declarations
>
> 3. Ensure I use universal SQL commands in my SQL statements (which I
> have done)
>
> 4. Ensure Access database has equivelent field names and types
>
>
> Is there anything else? Thanks very much for all help,
>
> Buck
>



 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
class-based access control VS instance-based access control xz C++ 9 01-08-2008 11:20 AM
Making a multithread app that runs several instances of whatever the app did before olbion@gmail.com Python 1 08-15-2006 10:17 AM
making ie compatible code firefox compatible using Greasemonkey? pantagruel Javascript 0 02-17-2006 02:26 PM
windows app vs web based app Robert Lie ASP .Net 2 12-20-2005 03:55 PM
what in this value is making an app.config crash an app? Chris Kimmel ASP .Net Security 2 06-16-2004 01:54 PM



Advertisments