Asp.net MS Access to SQL database

Report · Oct 06, 2006

I have been using MS Access for a long time. The last couple of months my sites have really picked up in business (good rankings) and we keep crashing the server (No sites on the server that use MS Access will run) We get the error

System.Data.OleDb.OleDbException: Unspecified error at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) at System.Data.OleDb.OleDbConnection.InitializeProvider()
at System.Data.OleDb.OleDbConnection.Open()
at DreamweaverCtrls.DataSet.DoInit()

Also I am finding out from some of my customers that their sites they can't use at times because of the error but the server hasn't crashed yet because others are up. Well I believe we are exceeding MS Access very badly because it crashes the server daily now and sometimes more then once a day.

So I am going to start moving my MS Access database to SQL but have NO CLUE how where to start etc or use SQL correctly. If people can point me in the right direction that would be very helpful. Everything I find online is people needing help but no solutions that work for me.

My new server is a windows server running ASP.Net 2.0 and to edit my SQL I have "ASP.Net Enterprise Manager" and Plesk for the server.

1. A good book to follow and easy to follow for SQL (connections / how tos) or website

2. Good examples or book on "ASP.Net Enterprise Manager"

3. How to convert access databases into SQL easy (some have over 50,000 listings)

4. how to convert Tab files into SQL easy.

Thank you so much for any help. Also I am using Dreamweaver for most of the edditing and connections. I know its not your favorite but I don't have the time to write everything by hand and it works good for what I do on the websites.

Thanks again,

Rusty

Report · Oct 06, 2006

> 1. A good book to follow and easy to follow for SQL (connections / how
> tos) or
> website

It's pretty much the same as Access with some minor differences in SQL
syntax.

You are using OLEDB connections, so you really shouldn't have to do anything
other than set up a new connection string for your new DB.

> 2. Good examples or book on "ASP.Net Enterprise Manager"

There's not much to Enterprise Manager...I doubt there's a book on it. You
basically just use it to view your database tables in a visual manner.

> 3. How to convert access databases into SQL easy (some have over 50,000
> listings)

I believe that there is an export function in Access and an Import Function
in SQL. This should be fairly easy to do, alas, I've never done it to will
have to defer to someone else.

> 4. how to convert Tab files into SQL easy.

Hmm...that I'm not sure on. It's easy to do the reverse, but not sure how to
import it as such.

> Thank you so much for any help. Also I am using Dreamweaver for most of
> the
> edditing and connections.

FYI, DW does not do ASP.net 2.0. If you're going to switch to ASP.net 2.0,
you might as well switch to Visual Studio.

-Darrel

Report · Oct 06, 2006

"darrel" <notreal@nowhere.com> wrote in message
news:eg5tsl$34h$1@forums.macromedia.com...
>
>> 3. How to convert access databases into SQL easy (some have over 50,000
>> listings)
>
> I believe that there is an export function in Access and an Import
> Function in SQL. This should be fairly easy to do, alas, I've never done
> it to will have to defer to someone else.

Either way, it's extremely simple. If you actually read the screens on the
import wizard, you'll be fine. I've heard the upsize wizard in Access does
a decent job, too. Just don't use "text" as a data type; use VARCHAR
instead. 50000 records is a paltry amount for a real database system, so
don't sweat it there.

>> 4. how to convert Tab files into SQL easy.
>
> Hmm...that I'm not sure on. It's easy to do the reverse, but not sure how
> to import it as such.

Same thing. Read the screens on the import wizard and you can't screw up.
Not unless you really want to.