Hello,

I was wondering if it was possible to create a ASP webpage and connect it to the DBtextworks database??

Rich

Rich:

This is in fact quite possible. I create most of my own web interfaces to DBtextworks via asp pages. You connect to the DB pretty much the same as you would with any other database. If there are any specific details that you are after or are having difficulties, please let me know.

Dave

Hey Dave,

Thank you for replying to my post.

So I was looking through Inmagics website, do I need to download an ODBC piece to make everything work??

Do you have any sample code of connecting to the database??

Again thank you for you help... really appreciate it!!

Rich

Rich:

Yes, you will need to get the ODBC driver in order to connect with database.

Here's a sample of some of the code I've used:

  
Dim connectionToDatabase
Set connectionToDatabase = Server.CreateObject("ADODB.Connection")
connectionToDatabase.ConnectionString = "DSN=LibraryTextbases"
connectionToDatabase.Open

Dim sqlStatement
sqlStatement = "SELECT * FROM TEXTBASE WHERE ID = '"& ID &"'"

Set recordCollection = connectionToDatabase.Execute(sqlStatement)