connecting to an sql server 2000 database from window 98

Article View: free.it.visual-basic

Article #2917

Back to free.it.visual-basic Previous Next

#2917

From: nnamezie
Date: Thu, 02 Jan 2003 01:25

15 lines
1564 bytes

I have a program written in vb,that connects to an sql server 2000 database
over the internet. The system connects to the remote database over the
internet on a window 2000 computers, but keep failing on a window 98 system.
Please can anyone help me.

The code for the connection is shown below

   Dim Conn As ADODB.Connection
   Dim Rs As ADODB.Recordset
   Set Rs = New ADODB.Recordset
   Set Conn = New ADODB.Connection
   connectme = "Driver={SQL
Server};Server=205.139.174.150;Database=K4G3560;Uid=K4G3560;Pwd=das"

    Conn.Open (connectme)

Technical Details

Message-ID: <1041787580.93007.0@iapetus.uk.clara.net>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!peer1.news.newnet.co.uk!mephistopheles.news.clara.net!newspeer.clara.net!news.clara.net!iapetus.uk.clara.net

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f94ee,443a8955f183c5ad,start
X-Google-Attributes: gidf94ee,public
X-Google-ArrivalTime: 2003-01-05 09:28:04 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!peer1.news.newnet.co.uk!mephistopheles.news.clara.net!newspeer.clara.net!news.clara.net!iapetus.uk.clara.net
From: <nnamezie@clara.co.uk>
Newsgroups: free.it.visual-basic
Subject: connecting  to an sql server 2000 database  from window 98
Date: Wed, 1 Jan 2003 17:25:12 -0800
Lines: 17
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
X-Complaints-To: abuse@clara.net (please include full headers)
X-Trace: 0162e653a6182dc09876d0e58658e0b699866b829a08088093dd00443e186abc
NNTP-Posting-Date: Sun, 05 Jan 2003 17:26:20 +0000
Message-ID: <1041787580.93007.0@iapetus.uk.clara.net>