Re: ADO / XP / Win98

RM wrote:

Here's my problem:
1. 70+ pc's using inhouse vb6 app development using Access just as a db.
2. Converted from Access to SQL 2005 and updated all source as necessary.
3. All XP Pro PC's work just fine
4. Too many Win98 PC's failed with the following error:
"Item cannot be found in the collection corresponding..."
Basically it's telling me that a field is not there but being referenced
in code.

My problem is that all of the XP Pro PC's are running the same .EXE
without any
problems; and it appears that all Win98 PC's are failing on the same .EXE.

Our connection string to SQL includes:
Provider=SQLOLEDB;

Hi,

Would a connection string similar to below help?

strDB = "MyDatabase"
strInstance = "MyInstance"

strDatabaseConnection = "DRIVER=SQL Server;" _
& "Trusted_Connection=Yes;" _
& "DATABASE=" & strDB & ";" _
& "SERVER=" & strServer & "\" & strInstance

--
Richard
Microsoft MVP Scripting and ADSI
Hilltop Lab - http://www.rlmueller.net


.

Relevant Pages

  • Re: Pass Through Query Question
    ... "Joe Williams" wrote in message ... > when you mentioned setting the connection string in the properties of the ... It runs with no problem using SQL query anlayzer. ...
    (microsoft.public.access.queries)
  • Re: Cant get SQL INSERT code to work
    ... I'm not sure you can use SQL to add data to an Excel file from another ... From Access Help file (covers JET SQL): ... ' Create the connection string. ... > 'Excel file and modify the SQL statement to fit your data. ...
    (microsoft.public.access.queries)
  • Re: Dataset - Error
    ... Server connection ... So looking at this we see that it is an error coming from SQL. ... Next we would look at the connection string, which is used to "login" to SQL ... What is does specify in regards to the userid is the ...
    (microsoft.public.cert.exam.mcsd)
  • Re: EXEC master..xp_cmdshell Prevention
    ... > I found that my web application did use a connection string in a file ... > stored procedures for every SQL statement would be impractical. ... I have created a new login account ...
    (microsoft.public.sqlserver.security)
  • Re: Win2.3k and dotnet. Urgent please
    ... Did you install MSDE as an instance? ... connection string, unless it is the default instance. ... ASP.NET application and MSDE installed on our Win2k dev server. ... Then I installed SQL server client tools only. ...
    (microsoft.public.inetserver.asp.general)