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!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by 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... -
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...- Tweir
- Post #2
- Forum: Microsoft SQL Server: Programming
-
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...- Tweir
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
