Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Tweir
  • Order by date
  1. Tweir

    ODBC Connection Syntax in VBScript

    Here are some different connection strings coming from my ASP test page: strconn = "Provider=SQLOLEDB;Data Source=YourSQLServerServerName;Initial Catalog=YourSQLDBNAME;" strconn = strconn & "User ID=webuser;Password=webuser;APP=ASP Script" 'OLE DB w/IP IT WORKS...
  2. Tweir

    Connecting to SQL Server 2000 w/ Access 97 Front End

    Here's the deal: I read this link: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q128809. Then I went back and looked at my table design. I had been using as a Primary Key a bigint field designated as the Identity Column. This apparently is not unique enough. I tried creating a...
  3. Tweir

    Connecting to SQL Server 2000 w/ Access 97 Front End

    Hi all, I am trying to hook up my Access97 Front End forms to a new SQL Server 2000 back end. I do this by: 1. Setting up a System DSN using ODBC drivers to hook up to the SQL Server Db. 2. Creating a new Linked table in Access 97 using the System DSN. This all works fine, I can see all...

Part and Inventory Search

Back
Top