Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Help Moving Access DB to SQL Server 7

Author  Topic 

disorder
Starting Member

4 Posts

Posted - 2002-01-30 : 07:33:07
hi,

Can anyone give there input on this i have developed a site using access , but i would like to move it to SQL server 7.0 .
I have tried the import/export function in SQL Server 2000

Thou i still get errors when i try to acces the asp pages from the browser ,


Thank's


robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-01-30 : 07:40:31
Can you post your ASP code, and the EXACT error message you get (and where it occurs)?

Go to Top of Page

Nazim
A custom title

1408 Posts

Posted - 2002-01-30 : 07:41:41
What is the error you get. i think ,you need to change the connection string to appropriately to point to Sql Server Database (if the problem is of connection to the database).

you can post your error and code here, we will try to bail you out.




--------------------------------------------------------------
Dont Tell God how big your Problem is , Tell the Problem how Big your God is
Go to Top of Page

disorder
Starting Member

4 Posts

Posted - 2002-01-30 : 08:26:34
well i have my connection string in an include file,
using ConnString = "dsn=SaharaSQl;"
SaharaSql = Sql Server DSN
and SaharaWeb = Access DSN

the strange thing is when i try to load the main page "index.asp" i dont get any error , all i get is ---
The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be displayed.

--------------------------------------------------------------------------------

Please try the following:

Open the 10.0.1.32 home page, and then look for links to the information you want.
Click the Refresh button, or try again later.

Click Search to look for information on the Internet.
You can also see a list of related sites.




HTTP 500 - Internal server error
Internet Explorer
-----
is there sum way i can trace the error?
i have also checked permissions and added the "IUSR" acc with read permission to the db


Go to Top of Page
   

- Advertisement -