Connect to SQL without webbot

[Ngan Bui]

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

 

[Tom Gahagan]

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]

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?