What are the advantages of using OLE DB with SQL Server 7.0?
Mark
-----Original Message-----
From: Adrian Cooper [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 14, 2000 10:48 PM
To: CF-Talk
Subject: Re: OLE DB and CF
----- Original Message -----
From: "S R" <[EMAIL PROTECTED]>
Sent: Tuesday, November 14, 2000 9:52 PM
> I am trying to add an OLD DB datasource to CF Admin, but when I add it,
the
> datasource connection fails. I have never used OLE DB, I've only used
ODBC.
> I've been urged to use OLE DB for SQL Server 7.0 but I guess I don't know
> how to do it. Does anyone have any ideas as to why this may be happening?
> What is the difference between ODBC and OLE DB?
Have you tried creating a user for the SQL database, and including that user
and
password in the CF settings for the OLEDB provider?
Adrian Cooper.
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
