RE: Getting data from ODBC or Access

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

RE: Getting data from ODBC or Access

Logged in as: Guest

arrSession:exec spGetSession 2,2,59134

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> WSH & Client Side VBScript >> RE: Getting data from ODBC or Access
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: << < prev 1 [2]

Message

<< Older Topic Newer Topic >>

RE: Getting data from ODBC or Access - 4/16/2008 1:55:54 AM

markmcrobie

Posts: 314
Score: 0
Joined: 12/12/2006
Status: offline

Also, out of interest, why was it so bad to go through Access?

(in reply to markmcrobie)

Post #: 21

RE: Getting data from ODBC or Access - 4/16/2008 1:56:32 AM

ebgreen

Posts: 4972
Score: 31
Joined: 7/12/2005
Status: offline

1) adOpenStatic : http://www.microsoft.com/technet/scriptcenter/guide/sas_ent_cwja.mspx?mfr=true I doubt that it would matter
adLockOptimistic : http://www.microsoft.com/technet/scriptcenter/guide/sas_ent_cwja.mspx?mfr=true I doubt that this would matter either

2) Not positive, but I would think that you could remove the DSN

3) Yes

_____________________________

"... when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick
Goog places to start:http://www.visualbasicscript.com/m_24727/tm.htm
http://www.visualbasicscript.com/m_47117/tm.htm

(in reply to markmcrobie)

Post #: 22

RE: Getting data from ODBC or Access - 4/16/2008 2:05:13 AM

markmcrobie

Posts: 314
Score: 0
Joined: 12/12/2006
Status: offline

I did remove the DSN, and it still works ok.

(in reply to ebgreen)

Post #: 23

RE: Getting data from ODBC or Access - 4/16/2008 2:06:52 AM

ebgreen

Posts: 4972
Score: 31
Joined: 7/12/2005
Status: offline

Truthfully considering how you were using access you could probably gone for years with no problem. Access has a bad habit of mangling data if it is used in anything approaching a real production environment. Even if Access had no problems, since you were just using it to pass data through from the end DB all you were doing is adding overhead with no benefit.

_____________________________

"... when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick
Goog places to start:http://www.visualbasicscript.com/m_24727/tm.htm
http://www.visualbasicscript.com/m_47117/tm.htm

(in reply to markmcrobie)