|
|
|
|
|
| | |
| |
Active Server Pages ASP ASP.NET .aspx .ascx Web HTML Developer Internet Microsoft Web Services Visual Studio .NET CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
DNS-less cursor settings |
|
From: |
Edison |
|
Date: |
6/24/1999 8:43:03 AM |
|
IP: |
193.133.140.50 |
I want to create a static DNS-less connection so I have access to the RecordCount, but Im having trouble. Can any one give me some pointers as to how it should be done?
Set MyConn=server.createobject("ADODB.connection")
MyPath="DBQ=" & server.mappath("\temp\testfile.mdb")
MyConn.Open "DRIVER=[Microsoft Access Driver(*.mdb)}; " & MyPath, 3 This is my guess as it how to do it.
Set MyRS=MyConn.execute("SELECT * FROM MyTable")
Thanks |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
