Windows 2003 Server Std. Edition - SQL Server 200 Std. Edition
I'm able to create a new data source in the ODBC panel on the SQL
server which points to a db on the same SQL server but not creating
that same new data source in the SQL Server Enterprise Manager or
Analysis Manager. I tried creating a new cube, a new DTS and so on but
I won't get past the new data source failure.
Error: [DBNETLIB][ConnectionOpen(Connect()).] SQL Server does not
exist or access is denied.
I tried using local admin account, sa account which both belong to the
sysadmin serve role.
Thank you.
Steve
Starting with VB2005 and SQL Server 2008 Express Edition ... Writing a VB application to connect to SQL Server 2008 Express to handle the data entry instead of using Access. ... However I'm finding it difficult to try out SQL Server 2008 Express to connect to a database from VB. ... When I click this it opens a window that asks me to choose a data source type.... The next screen asks me to choose a data connection.... (microsoft.public.vb.database)
Re: Access 2003 - ODBC File Data Source - Relink every Access Sess ... Click on System DSN, click Add, select SQL Server, click Finish. ... titled "Create a New Data Source to SQL Server." ..."SQL Server Login" pops up, with the Data Source and then the name I called ... "Use Trusted Connection" is unchecked. ... (microsoft.public.data.odbc)
Re: Populating mail merge doc with data from MSsql 2K table ... > the MS Query option in Word - when you get to the Select Data Source ... Enter the name of the Windows computer that is running SQL Server... Word should now create the .odc file and select it as the data source.... if you did not sleect Windows Authentication and you did not ... (microsoft.public.word.mailmerge.fields)
RE: Use of IF then Else syntax in Access ... Is this being used in a query?... this is referring to a field in the query's data source.... that means using the SQL Server T-SQL syntax,... (microsoft.public.access.queries)
Re: Mail Merge office 2003 from SQL Database ... Word nowpops up an additional question when you open a mail merge document that is already attached to its data source.... With WOrd 2000 you would have been using ODBC to connect to SQL Server and you would have had something like ... Field2: Staff Number ... using a selected template (we could end up with several different template ... (microsoft.public.word.mailmerge.fields)
