ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 SQL Connection String
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

David Edwards

United Kingdom
1 Posts

Posted - 04/09/2007 :  11:56:41  Show Profile  Reply with Quote
Can someone help me with a connetcion string to an SQL2005 Database.
I have tried using following string
Provider=sqloledb.1;
Data Source=(local);
Initial Catalog=myDataBase;
User Id=myUsername;
Password=myPassword;

Many Thanks

admin

1645 Posts

Posted - 04/09/2007 :  20:18:14  Show Profile  Reply with Quote
You can build your connection string in the following way:

1) Create a blank text file
2) Rename the file to Test.udl
3) Double click Test.udl
4) Click on the Provider tab ad select OLEDB provider for SQL Server
5) On the next tab enter the connection information and test the connection.
6) Check Allow Saving password option
7) Click ok to save the file
8) Open Test.udl in notepad and copy the line that starts with "Provider="

Also, the newest build (starting 137) creates the connection string for you. Just go to Admin > Connections to make one.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page