|
|
|
|
|
| | |
| |
vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Re: Adding records |
|
From: |
Harlan |
|
Date: |
3/22/1999 9:00:31 AM |
|
IP: |
206.222.20.2 |
I'm not sure what your doing, but you probably shouldn't be using a file dsn, you should more then likely be using a system dsn. So, after you get that changed.. your code will look something like this (Assuming your db is access, cus this isn't gonna work with any other db the way you have your dsn string setup).
Set connDB = Server.CreateObject ("ADODB.Connection")
cstDSN = "DSN=System_DSN_Name_Here"
connDB.Open cstDSN
set rsOne = Server.CreateObject ("ADODB.Recordset")
rsOne.Open "table1",connDB,adOpenKeyset ,adLockPessimistic
note: the naming changes I made are only changes to standard nameing convention, and not really required. The only real code changes I made is to the constant dsn string you had. I would also suggest you add comments ;) |
Previous Message
Follow Up - Re: Adding records - Chris Williams 3/22/1999 10:06:11 AM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
