Results 1 to 3 of 3

Thread: SQL Server 6.5 problem

  1. #1
    Michael Synowicz Guest

    SQL Server 6.5 problem

    I created a system DSN that is mapped to a SQL Server 6.5 database that resides on a different network server.

    I've read and tried all the examples and suggestions that I've come across concerning this issue.

    My problem is that when the code is executed nothing appears;
    there are no error messages or anything.

    I think the code is hanging up somewhere in the (mydb.aspDBPro) method because
    no other code gets executed after that statement.

    I am using the pro version.
    I've also tried the pureasp code and the smartdb code and nothing shows up.

    Thanks again.

  2. #2
    John Guest

    SQL Server 6.5 problem (reply)


    Hi Michael,

    If it failes in PUREASP, then it's obviously not an ASP-db problem, but
    rather an ODBC/SQL problem.

    What happens if you run the PUREASP program on that same machine with the
    database? Is it a permission thing (you're specifying the ID/PW)?

    Can you run the Enterprise manager and do the query?

    I'd try the simple DEMO database first and get that working, then move to
    your own app.

    Thanks,
    John


    ------------
    Michael Synowicz at 12/8/99 12:38:35 PM

    I created a system DSN that is mapped to a SQL Server 6.5 database that resides on a different network server.

    I've read and tried all the examples and suggestions that I've come across concerning this issue.

    My problem is that when the code is executed nothing appears;
    there are no error messages or anything.

    I think the code is hanging up somewhere in the (mydb.aspDBPro) method because
    no other code gets executed after that statement.

    I am using the pro version.
    I've also tried the pureasp code and the smartdb code and nothing shows up.

    Thanks again.

  3. #3
    Frank Guest

    SQL Server 6.5 problem (reply)

    Try to make up a system ODBC DSN datatsource. If the remote server info (security, server name etc...) you put in is wrong then you would not be able to complete that. Finally, you must have IIS installed in you W/S in order to do that. Accessing remote MSSQL should be a piece of cake. Acces remote ACCESS is the difficult one !!!

    FK



    ------------
    John at 12/8/99 4:55:00 PM


    Hi Michael,

    If it failes in PUREASP, then it's obviously not an ASP-db problem, but
    rather an ODBC/SQL problem.

    What happens if you run the PUREASP program on that same machine with the
    database? Is it a permission thing (you're specifying the ID/PW)?

    Can you run the Enterprise manager and do the query?

    I'd try the simple DEMO database first and get that working, then move to
    your own app.

    Thanks,
    John


    ------------
    Michael Synowicz at 12/8/99 12:38:35 PM

    I created a system DSN that is mapped to a SQL Server 6.5 database that resides on a different network server.

    I've read and tried all the examples and suggestions that I've come across concerning this issue.

    My problem is that when the code is executed nothing appears;
    there are no error messages or anything.

    I think the code is hanging up somewhere in the (mydb.aspDBPro) method because
    no other code gets executed after that statement.

    I am using the pro version.
    I've also tried the pureasp code and the smartdb code and nothing shows up.

    Thanks again.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •