Re: BatchUpdate problem with Vista SP1 and XP SP3
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Mon, 12 May 2008 09:31:15 -0400
Damir Arh wrote:
cn.Provider = "SQLOLEDB"
cn.ConnectionString =
"Server=ServerName;Database=TestDB;Trusted_Connection=No;User
ID=user;Password=pwd"
Another response keyed on your connection string, which, while it
obviously works, is a strange mixture of ODBC and OLE DB keywords. i
would advise switching to the OLE DB keywords. Here is an example from
www.connectionstrings.com:
Provider=sqloledb;Data Source=myServerAddress;Initial
Catalog=myDataBase;User Id=myUsername;Password=myPassword;
Note that you do not have to tell it not to use integrated (trusted)
security, which is off by default.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
.
- References:
- BatchUpdate problem with Vista SP1 and XP SP3
- From: Damir Arh
- BatchUpdate problem with Vista SP1 and XP SP3
- Prev by Date: Re: BatchUpdate problem with Vista SP1 and XP SP3
- Next by Date: Re: Reading text files with UTF-8 byte order mark
- Previous by thread: Re: BatchUpdate problem with Vista SP1 and XP SP3
- Next by thread: ASP/ADO/VB.NET: How to update multiple datatables with typed datasets ?
- Index(es):
Relevant Pages
|
Loading
