Re: Reviewing my code. Displaying a BLOB image through a browser

Ok I made that change and now I get this error message in my browser.

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax
near '='.
/ben/bam3.asp, line 14

Ben


Bob Barrows [MVP] wrote:
bfiser@xxxxxxxxx wrote:
· Error Type:
Server object, ASP 0177 (0x800401F3)
Invalid class string

Set objConn = Server.CreateObject("ODBC.Connection")

I don't know of a class called "ODBC". You need to replace "ODBC" with
"adodb" in this and the other CreateObject lines that follow.

objConn.Open "DSN=AsureIDc51Test", "xx", "xxxxx" ß username and
password removed for security

Don't use ODBC if you have the choice:
http://www.aspfaq.com/show.asp?id=2126


--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

.

Relevant Pages

  • Re: linked tables
    ... Yes, when I try to access the linked table, I get this error message: ... Microsoft OLE DB Provider for ODBC Drivers ... I don't know whether your SQL Server database requires a user ID and password for access, ...
    (microsoft.public.vb.database.ado)
  • Re: SQL Injection ASP + SQL Server (problem) ?!
    ... First Thkz for help and attention. ... Microsoft OLE DB Provider for ODBC Drivers ...
    (Pen-Test)
  • VSS Errors using NTBackup
    ... Microsoft OLE DB Provider for SQL Server ... Error message: ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL
    ... what drivers are you using to access the DBF file? ... ODBC drivers which result in this error the first time they are initialised. ... The fact that you error message mentions Paradox is a little weird, ...
    (microsoft.public.vb.database.dao)
  • Re: mdb access to names containing ""
    ... references to myname since there are subsequent queries. ... >Microsoft OLE DB Provider for ODBC Drivers ...
    (microsoft.public.frontpage.programming)