I have a need to know ...

[Guest_imported]

I created database and its objects (tables etc),
wrote an asp code, tested it and everything works.
I uploaded the code to our site but now I can't retrieve information from our database.
How do I hit the database have the ability to store records in it and retrieve records from it?
Thanks in advance

 

[TWillard]

You say you uploaded the code to your site? I am assuming that you are uploading your code to a server computer. Have you checked your database connection? Are you using an OLEDB or an ODBC connection? What is the os of your server computer? Is the host computer setup with the same ODBC data source? A few more details would be helpful. What kind of dataconnection are you using locally on your computer?

 

[Guest_imported]

thanks TWillard!
I uploaded the the computer server, not the site sorry.
I tested the asp connection to the database and it works fine from my local computer.
I am using an ODBC connection.
The os is win2000 pro.
The database is Oracle.
> Is the host computer setup with the same ODBC data
source?
I say no here because I don't know how to set up host with odbc data source.
I do know that I created a virtual directory, I don't know if this means anything to this issue.
I have been an oracle person.
I am just tip-toeing into this new territory.
So any help/suggestion on how to deploy your code to the web and make it talk to the database will be greatly appreciated.
I brought this on myself by asking to be allowed to do this.
I will be more than happy to provide additional info.

 

[TWillard]

Check out this faq about how your are connecting to the database: ODBC vs OLE

faq333-178

Also, check out this article on setting up an ODBC Conection:

http://www.earthetc.com/sampleiws/db_instructions.htm

Take a look at the current code and read the first faq. Try and discover how you are connecting to the database. If you are using an odbc, you will need to get into the server computers control pannel to check its settings. If you are working with an OLE connection, I am probably not the best person to guide you. I would then suggest posting another question here with specifics regarding OLE. I hope this can get you started.

 

[Guest_imported]

Thansk TWillard!
It still does not address my problem.
I have set up my odbc properly and have tested my asp code and it is connecting to the database.
My problem is trying to retrieve info from my database from a remote location.
If for instance, I log into my company's website and try to do a search, it is not working because the asp is not connecting to the database to retrieve the data that I want.
My question becomes, do I need to do something special for that to happen?

 

[CDN]

[tt] Would not having a DSN ring a bell ??[/tt]

 

[Guest_imported]

it sure rings a bell but security is of paramount concern to us.

 

[Guest_imported]

I think I know what the problem is!
I am trying to run the asp code on bellsouth's personal web site. It is not cgi-enabled!!!!