General information
Category:
COM/DCOM and OLE Automation
And why you are talking about OLEDB? In this sample you are using an ODBC connection.
>I am trying to access data in an Access Database using OLEDB. I am not sure I understand how this works. Once I establish a connection can I open multiple views using that connection, or do I have to establish a connection for each view that I open. I am using the following form:
>
>lnConnectionStr="Driver={Microsoft Access Driver (*.mdb)} Dbq=path and mdb name Uid=Admin Pwd="
>
>If that succeeds can I then open multiple tables using this format:
>LnTable1=SQLSTRINGCONNECT(lnConnectionStr)
>LnTable2=SQLSTRINGCONNECT(lnConnectionStr)
>r=SQLEXEC(lnTable1,"some sql stmt","tablename")
>s=SQLEXEC(lnTable2,"some sql stmt","tablename")
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only