BaseNow - Database Front-End Software
*
Home Buy Download Details Support
BaseNow Forums 
Home
Login Register Member List
  » BaseNow Forums   » Installation   » login to a SQL database  

Welcome Guest ( Login or Register )


login to a SQL database
Author
Message
Posted 3/10/2003 5:26 PM
Forum Member
Forum Newbie

Group: Forum Members
Active: 3/9/2003
Posts: 1
I am having trouble getting started. I set up a database connection and test the connection successfully. When I try to view the database tables, it get this message: "[Microsoft][odbc sql server driver] login failed for dbuser"

The database connection test successfully for dbuser, I just can't login. I am trying to login to a remote database.
IP Logged
This member is offline.
Posted 3/10/2003 7:58 PM
Forum Administrator
Forum Administrator

Group: Advanced Members
Active: 3/7/2010
Posts: 64
Try to use OLE DB provider for SQL Server instead of ODBC driver. Here is the connection string you can use:

Provider=SQLOLEDB.1;Password=***Persist Security Info=True;User ID=***;Initial Catalog=DatabaseName;Data Source=ServerName

You can enter the connection string by right-clicking the connection name in the Object Browser. Choose the Properties option. You will see the the Connection String text box where you should enter appropriate value.

You can find a video that shows you how to connect to a remote SQL Server database. Please visit this page:
http://www.basenow.com/help/How_to_connect_to_a_remote_server.asp
IP Logged
This member is offline.
Showing page 1 of 1 - 2 messages found
« Next Oldest :: Next Newest »

Powered by InstantForum.NET v3.4
Copyright © 2002, 2004, InstantASP Ltd. All rights reserved.