Skip to main content
 
developerWorks
AIX and UNIX
Information Mgmt
Lotus
New to Lotus
Products
How to buy
Downloads
Live demos
Technical library
Training
Support
Forums & community
Events
Rational
Tivoli
WebSphere
Java™ technology
Linux
Open source
SOA and Web services
Web development
XML
My developerWorks
About dW
Submit content
Feedback



developerWorks  >  Lotus  >  Forums & community  >  Notes/Domino 4 and 5 Forum

Notes/Domino 4 and 5 Forum

developerWorks

  


NotesSQL (ODBC) in ASP.NET / VB.NET
Terje Nygard 21.Jun.05 08:24 AM a Web browser
Lotus Tools -- Other All Releases All Platforms

Hi there :)

Hope indeed someone can help me out with this bugger of a problem :

----------SYSTEM----------
Server : IIS
OS : XP SP2
Lotus Notes installations on PC : Client, Designer
Lotus User rights : Administrator
Platform : .NET 2.0 (ASP.NET / VB.NET / ADO.NET)
NotesSQL version : 3.02
--------------------------

-----------TASK-----------
Create a ASP.NET / VB.NET / ADO.NET Web-app which uses NotesSQL ODBC driver to connect to a Notes database to get data from it.
--------------------------

------MY CODE (ASPX)------
Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)

Dim connString As String = "Driver={Lotus NotesSQL 3.02 (32-bit) ODBC DRIVER (*.nsf)}; Server=database; Database=FELLES\ansatt.nsf; Uid=Terje Nygård; Pwd=xxxxxxxx"
' /REM/ Dim connString As String = "DSN=personalsys"
Dim strSQL As String = "SELECT Bid,Tilgang,Dato,Author FROM ADMIN"

Dim myConnection As New OdbcConnection(connString)
Dim myCommand As New OdbcCommand(strSQL, myConnection)

myConnection.Open()

Dim myDataReader As OdbcDataReader = myCommand.ExecuteReader

Dim counter As Integer

While myDataReader.Read
Dim s As String = myDataReader.GetString(0)
counter = counter + 1
End While

Response.Write(counter)

End Sub
---------------------------------

-------ERROR 1 (WITH DSN)--------
ERROR [IM005] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on
SQL_HANDLE_DBC failed ERROR [01000] [Microsoft][ODBC Driver Manager] The
driver doesn't support the version of ODBC behavior that the application
requested (see SQLSetEnvAttr).
----------------------------------

-------ERROR 2 (W.O. DSN)---------
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found
and no default driver specified
----------------------------------

Soo... this was a long and detailed question, but it's the only way i can do this :)

I see that lots of people have had trouble with this, but... i have seen people do it, and i think it's possible too..

Anyone can assist me on this and tell me what i could do to make this work ?

Referring to this post which i have studied too :
http://www-10.lotus.com/ldd/46dom.nsf/55c38d716d632d9b8525689b005ba1c0/b2df362dfd1dff0f85256a8d006f4015?OpenDocument

A digital-beer for the one that can help me with this :)

Best regards
Terje Nygård




NotesSQL (ODBC) in ASP.NET / VB.NET... (Terje Nygard 21.Jun.05)
. . RE: NotesSQL (ODBC) in ASP.NET / VB... (Ronald Wilkins 21.Jun.05)
. . . . RE: NotesSQL (ODBC) in ASP.NET / VB... (Terje Nygard 21.Jun.05)
. . . . . . RE: NotesSQL (ODBC) in ASP.NET / VB... (Ronald Wilkins 22.Jun.05)
. . . . . . . . RE: NotesSQL (ODBC) in ASP.NET / VB... (Terje Nygard 22.Jun.05)
. . . . . . . . RE: NotesSQL (ODBC) in ASP.NET / VB... (Terje Nygard 22.Jun.05)
. . . . . . . . . . RE: NotesSQL (ODBC) in ASP.NET / VB... (Ronald Wilkins 22.Jun.05)
. . . . . . . . . . . . RE: NotesSQL (ODBC) in ASP.NET / VB... (Terje Nygard 23.Jun.05)
. . RE: NotesSQL (ODBC) in ASP.NET / VB... (Stephen Walch 22.Jun.05)
. . . . RE: NotesSQL (ODBC) in ASP.NET / VB... (Terje Nygard 22.Jun.05)






  Document options
Print this pagePrint this page

 Search this forum

  Forum views and search
Date (threaded)
Date (flat)
With excerpt
Author
Category
Platform
Release
Advanced search


 RSS feedsRSS
All forum posts RSS
All main topics RSS
More Lotus RSS feeds

 Resources
Forum use and etiquette
Native Notes Access
Web site Feedback

  Lotus Support
Lotus Support
Product support pages index
Search knowledge base (Technotes)
Search support downloads
Lotus Support RSS

 Wikis
IBM Composite Applications
IBM Mashup Center
IBM Connections
IBM Docs
IBM Forms
IBM Mobile Connect
IBM Sametime
IBM SmartCloud for Social Business
IBM Web Experience Factory
Lotus Domino
Lotus Domino Designer
Lotus Expeditor
Lotus Foundations
Lotus iNotes
Lotus Instructor Community Courseware
Lotus Notes
Lotus Notes & Domino Application Development
Lotus Notes Traveler
Lotus Protector
Lotus Quickr
Lotus Symphony
IBM Web Content Manager
WebSphere Portal

 Lotus Forums
Notes/Domino 9.0
Notes/Domino 8.5 + Traveler
Notes/Domino XPages development forum
Notes/Domino 8
Notes/Domino 6 and 7
Notes/Domino 4 and 5
IBM Connections
IBM Forms
IBM Mobile Connect
IBM Sametime
IBM SmartCloud Notes
IBM SmartCloud Meetings
IBM Web Content Manager
Lotus Domino Document Manager
Lotus e-learning
Lotus Enterprise Integration
Lotus Expeditor
Lotus Protector
Lotus Quickr
Lotus SmartSuite
Lotus Symphony
Lotus Symphony Developer Toolkit Support
Lotus Workflow