=?Utf-8?B?cm9kY2hhcg==?=
4/14/2004 4:31:00 PM
I tried that and other sites. However, I'm getting error
messages when I try the connection string.
The eror message is:
Microsoft OLE DB Provider for SQL Server (0x80004005)
Cannot open database requested in login 'clientTest'.
Login fails.
The connection string is:
<%
Dim cn, rsRider
set cn=server.createobject("ADODB.Connection")
cn.open "PROVIDER=SQLOLEDB;DATA
SOURCE=Webbus\Lab;;Trusted_Connection=Yes;DATABASE=clientTe
st"
%>
What am I missing?
>-----Original Message-----
>I don't know this this will help but...
>
>www.connectionstrings.com
>
>is a pretty cool site with all kinds of connection
strings for all kinds of
>databases.
>
>Best to you....
>Tom Gahagan
>eThomaston.com
>
>"Ngan Bui" <anonymous@discussions.microsoft.com> wrote in
message
>news:1c74501c42233$3d405800$a301280a@phx.gbl...
>> I'm at a loss so I hope someone can help me. We have
SQL
>> 2K in a W2K environment. I have FP XP.
>>
>> When I create a new page and form and want to link it
to a
>> sql server table, I can do that inside the form
>> properties. However, when I do that, FP creates the
>> connection via the webbot. I don't want to use webbot,
>> instead I rather use the dsn-less connection string.
>>
>> One problem I have with webbot is that I can't seem to
do
>> custom fields. for instance, if I want to add a phone
>> number to a field in the table, minus the dashes, I'm
not
>> sure how to do that programmatically with webbot.
>>
>> Is there a way to have FP not use webbot when connecting
>> to a sql server?
>>
>> I have tried a dsn-less connection string with
>> Trusted_connection=yes, but that doesn't seem to work.
It
>> keeps saying login failed. I have turned off anonymous
>> access on the sql server. Is there something else I
need
>> to do to make it so my windows login is used?
>>
>> Thanks!
>> Ngan
>
>
>.
>