Home > Archive > Visual Basic Crystal Reports > April 2006 > Connect Remote DB for Crystal Report Data Field
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Connect Remote DB for Crystal Report Data Field
|
|
| den 2005 2006-03-22, 4:06 am |
| Hi everybody,
I never tried to create a db connection to a sql located other than local
pc, how can you create a connection to a remote sql database to be used in
creating a Crystal report data fields (*.rpt)? Say, the remote location name
is Ms-server(192.1.1.50).
The database name say is "Emit".
In Ole Db provider dialog, Select: Microsoft OLE DB Provider for SQL Server
In Ole Db (ADO): Connection Information, enter
Server: Ms-server\Emit
User ID: sa
Password: blank password
Database: <<--- Totally Empty
Integrated Security:(checkbox) <<--Unchecked
How to solved this?
Using VS 2002 and ASP.Net
Thanks.
denpsia
--
MCP Year 2005, Philippines
| |
| den 2005 2006-04-12, 4:05 am |
| This problem has been resolved.
den2005
--
MCP Year 2005, Philippines
"den 2005" wrote:
> Hi everybody,
> I never tried to create a db connection to a sql located other than local
> pc, how can you create a connection to a remote sql database to be used in
> creating a Crystal report data fields (*.rpt)? Say, the remote location name
> is Ms-server(192.1.1.50).
> The database name say is "Emit".
> In Ole Db provider dialog, Select: Microsoft OLE DB Provider for SQL Server
>
> In Ole Db (ADO): Connection Information, enter
>
> Server: Ms-server\Emit
> User ID: sa
> Password: blank password
> Database: <<--- Totally Empty
> Integrated Security:(checkbox) <<--Unchecked
>
>
> How to solved this?
> Using VS 2002 and ASP.Net
>
> Thanks.
>
> denpsia
> --
> MCP Year 2005, Philippines
|
|
|
|
|