Connecting to SQL from Within VFP

In this post I am going to try to simply a question that I posted earlier.
Can I use VFP to access a SQL Database? If so what is the command?
What is the best software for creating applications to work with SQL?
I am just getting my feet wet with SQL so please take it easy on a rookie.
You can't expect someone to explain to you how to do all of this properly in
a news group posting. I suggest you read the help file and maybe some books
on VFP and SQL Server. But you can get started with looking up "remote
servers, connecting to" in the VFP help file. Also take a look at Remote
Views as they may be your easiest way to migrate from VFP to SQL Server.
SQL Server is not like VFP in many ways. VFP is mostly a programming
language with a built in DB. SQL Server does not have a programming
language other than SET based stuff and there are no gui's like forms,
dialogs etc.
Andrew J. Kelly SQL MVP
"Preacher Man" <nospam> wrote in message
news:%23PGojbIwFHA.3548@.tk2msftngp13.phx.gbl...
> In this post I am going to try to simply a question that I posted earlier.
> Can I use VFP to access a SQL Database? If so what is the command?
> What is the best software for creating applications to work with SQL?
> I am just getting my feet wet with SQL so please take it easy on a rookie.
>
>
|||Hi Andrew,
Visual FoxPro makes a great front end to SQL Server in much the same way
that Visual Basic, VB.NET, and C# do. Since data-handling is built in to
VFP, all of this capability is available when working with SQL Server.
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@.msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:eL6SzpKwFHA.1028@.TK2MSFTNGP12.phx.gbl...
> ...VFP is mostly a programming language with a built in DB. ...
|||Hi,
You're asking how to write Visual FoxPro code in SQL Server newsgroups. You
shouldn't expect SQL Server developers to know the details of programming in
Visual FoxPro, or Visual Basic or C# for that matter. You'll get much better
help in a microsoft.public.fox.* newsgroup on this same news server.
You haven't said which version of Visual FoxPro you're working with. You can
access SQL Server data (or Access or Oracle, or whatever) via ODBC with a
Remote View or SQL Pass-through (SQLConnect or SQLStringConnect, and
SQLExec). You can also access SQL Server via OLE DB and ADO using a
CursorAdapter.
As for which is the best software for accessing SQL Server data, that
depends. Often the "best" software is the one that you're most comfortable
with. Visual FoxPro makes a great front end to SQL Server and brings all of
its built-in data handling capabilities to the table.
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@.msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden
"Preacher Man" <nospam> wrote in message
news:%23PGojbIwFHA.3548@.tk2msftngp13.phx.gbl...
> In this post I am going to try to simply a question that I posted earlier.
> Can I use VFP to access a SQL Database? If so what is the command?
> What is the best software for creating applications to work with SQL?
> I am just getting my feet wet with SQL so please take it easy on a rookie.
>
>
|||Cindy,
Lest you forget I have been programming with VFP since it was in Beta for
3.0. I never stated that VFP was not a valid choice for a front end. If you
look at my post I sent him to the very same places you did in your other
post.
Andrew J. Kelly SQL MVP
"Cindy Winegarden" <cindy_winegarden@.msn.com> wrote in message
news:eCb9kwWwFHA.596@.TK2MSFTNGP12.phx.gbl...
> Hi Andrew,
> Visual FoxPro makes a great front end to SQL Server in much the same way
> that Visual Basic, VB.NET, and C# do. Since data-handling is built in to
> VFP, all of this capability is available when working with SQL Server.
> --
> Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
> cindy_winegarden@.msn.com www.cindywinegarden.com
> Blog: http://spaces.msn.com/members/cindywinegarden
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:eL6SzpKwFHA.1028@.TK2MSFTNGP12.phx.gbl...
>

Connecting to SQL from Within VFP

In this post I am going to try to simply a question that I posted earlier.
Can I use VFP to access a SQL Database? If so what is the command?
What is the best software for creating applications to work with SQL?
I am just getting my feet wet with SQL so please take it easy on a rookie.
You can't expect someone to explain to you how to do all of this properly in
a news group posting. I suggest you read the help file and maybe some books
on VFP and SQL Server. But you can get started with looking up "remote
servers, connecting to" in the VFP help file. Also take a look at Remote
Views as they may be your easiest way to migrate from VFP to SQL Server.
SQL Server is not like VFP in many ways. VFP is mostly a programming
language with a built in DB. SQL Server does not have a programming
language other than SET based stuff and there are no gui's like forms,
dialogs etc.
Andrew J. Kelly SQL MVP
"Preacher Man" <nospam> wrote in message
news:%23PGojbIwFHA.3548@.tk2msftngp13.phx.gbl...
> In this post I am going to try to simply a question that I posted earlier.
> Can I use VFP to access a SQL Database? If so what is the command?
> What is the best software for creating applications to work with SQL?
> I am just getting my feet wet with SQL so please take it easy on a rookie.
>
>
|||Hi Andrew,
Visual FoxPro makes a great front end to SQL Server in much the same way
that Visual Basic, VB.NET, and C# do. Since data-handling is built in to
VFP, all of this capability is available when working with SQL Server.
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@.msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:eL6SzpKwFHA.1028@.TK2MSFTNGP12.phx.gbl...
> ...VFP is mostly a programming language with a built in DB. ...
|||Hi,
You're asking how to write Visual FoxPro code in SQL Server newsgroups. You
shouldn't expect SQL Server developers to know the details of programming in
Visual FoxPro, or Visual Basic or C# for that matter. You'll get much better
help in a microsoft.public.fox.* newsgroup on this same news server.
You haven't said which version of Visual FoxPro you're working with. You can
access SQL Server data (or Access or Oracle, or whatever) via ODBC with a
Remote View or SQL Pass-through (SQLConnect or SQLStringConnect, and
SQLExec). You can also access SQL Server via OLE DB and ADO using a
CursorAdapter.
As for which is the best software for accessing SQL Server data, that
depends. Often the "best" software is the one that you're most comfortable
with. Visual FoxPro makes a great front end to SQL Server and brings all of
its built-in data handling capabilities to the table.
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@.msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden
"Preacher Man" <nospam> wrote in message
news:%23PGojbIwFHA.3548@.tk2msftngp13.phx.gbl...
> In this post I am going to try to simply a question that I posted earlier.
> Can I use VFP to access a SQL Database? If so what is the command?
> What is the best software for creating applications to work with SQL?
> I am just getting my feet wet with SQL so please take it easy on a rookie.
>
>
|||Cindy,
Lest you forget I have been programming with VFP since it was in Beta for
3.0. I never stated that VFP was not a valid choice for a front end. If you
look at my post I sent him to the very same places you did in your other
post.
Andrew J. Kelly SQL MVP
"Cindy Winegarden" <cindy_winegarden@.msn.com> wrote in message
news:eCb9kwWwFHA.596@.TK2MSFTNGP12.phx.gbl...
> Hi Andrew,
> Visual FoxPro makes a great front end to SQL Server in much the same way
> that Visual Basic, VB.NET, and C# do. Since data-handling is built in to
> VFP, all of this capability is available when working with SQL Server.
> --
> Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
> cindy_winegarden@.msn.com www.cindywinegarden.com
> Blog: http://spaces.msn.com/members/cindywinegarden
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:eL6SzpKwFHA.1028@.TK2MSFTNGP12.phx.gbl...
>

Connecting to SQL from Within VFP

In this post I am going to try to simply a question that I posted earlier.
Can I use VFP to access a SQL Database? If so what is the command?
What is the best software for creating applications to work with SQL?
I am just getting my feet wet with SQL so please take it easy on a rookie.
You can't expect someone to explain to you how to do all of this properly in
a news group posting. I suggest you read the help file and maybe some books
on VFP and SQL Server. But you can get started with looking up "remote
servers, connecting to" in the VFP help file. Also take a look at Remote
Views as they may be your easiest way to migrate from VFP to SQL Server.
SQL Server is not like VFP in many ways. VFP is mostly a programming
language with a built in DB. SQL Server does not have a programming
language other than SET based stuff and there are no gui's like forms,
dialogs etc.
Andrew J. Kelly SQL MVP
"Preacher Man" <nospam> wrote in message
news:%23PGojbIwFHA.3548@.tk2msftngp13.phx.gbl...
> In this post I am going to try to simply a question that I posted earlier.
> Can I use VFP to access a SQL Database? If so what is the command?
> What is the best software for creating applications to work with SQL?
> I am just getting my feet wet with SQL so please take it easy on a rookie.
>
>
|||Hi Andrew,
Visual FoxPro makes a great front end to SQL Server in much the same way
that Visual Basic, VB.NET, and C# do. Since data-handling is built in to
VFP, all of this capability is available when working with SQL Server.
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@.msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:eL6SzpKwFHA.1028@.TK2MSFTNGP12.phx.gbl...
> ...VFP is mostly a programming language with a built in DB. ...
|||Hi,
You're asking how to write Visual FoxPro code in SQL Server newsgroups. You
shouldn't expect SQL Server developers to know the details of programming in
Visual FoxPro, or Visual Basic or C# for that matter. You'll get much better
help in a microsoft.public.fox.* newsgroup on this same news server.
You haven't said which version of Visual FoxPro you're working with. You can
access SQL Server data (or Access or Oracle, or whatever) via ODBC with a
Remote View or SQL Pass-through (SQLConnect or SQLStringConnect, and
SQLExec). You can also access SQL Server via OLE DB and ADO using a
CursorAdapter.
As for which is the best software for accessing SQL Server data, that
depends. Often the "best" software is the one that you're most comfortable
with. Visual FoxPro makes a great front end to SQL Server and brings all of
its built-in data handling capabilities to the table.
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@.msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden
"Preacher Man" <nospam> wrote in message
news:%23PGojbIwFHA.3548@.tk2msftngp13.phx.gbl...
> In this post I am going to try to simply a question that I posted earlier.
> Can I use VFP to access a SQL Database? If so what is the command?
> What is the best software for creating applications to work with SQL?
> I am just getting my feet wet with SQL so please take it easy on a rookie.
>
>
|||Cindy,
Lest you forget I have been programming with VFP since it was in Beta for
3.0. I never stated that VFP was not a valid choice for a front end. If you
look at my post I sent him to the very same places you did in your other
post.
Andrew J. Kelly SQL MVP
"Cindy Winegarden" <cindy_winegarden@.msn.com> wrote in message
news:eCb9kwWwFHA.596@.TK2MSFTNGP12.phx.gbl...
> Hi Andrew,
> Visual FoxPro makes a great front end to SQL Server in much the same way
> that Visual Basic, VB.NET, and C# do. Since data-handling is built in to
> VFP, all of this capability is available when working with SQL Server.
> --
> Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
> cindy_winegarden@.msn.com www.cindywinegarden.com
> Blog: http://spaces.msn.com/members/cindywinegarden
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:eL6SzpKwFHA.1028@.TK2MSFTNGP12.phx.gbl...
>

Connecting to SQL from Within VFP

In this post I am going to try to simply a question that I posted earlier.
Can I use VFP to access a SQL Database? If so what is the command?
What is the best software for creating applications to work with SQL?
I am just getting my feet wet with SQL so please take it easy on a rookie.
You can't expect someone to explain to you how to do all of this properly in
a news group posting. I suggest you read the help file and maybe some books
on VFP and SQL Server. But you can get started with looking up "remote
servers, connecting to" in the VFP help file. Also take a look at Remote
Views as they may be your easiest way to migrate from VFP to SQL Server.
SQL Server is not like VFP in many ways. VFP is mostly a programming
language with a built in DB. SQL Server does not have a programming
language other than SET based stuff and there are no gui's like forms,
dialogs etc.
Andrew J. Kelly SQL MVP
"Preacher Man" <nospam> wrote in message
news:%23PGojbIwFHA.3548@.tk2msftngp13.phx.gbl...
> In this post I am going to try to simply a question that I posted earlier.
> Can I use VFP to access a SQL Database? If so what is the command?
> What is the best software for creating applications to work with SQL?
> I am just getting my feet wet with SQL so please take it easy on a rookie.
>
>
|||Hi Andrew,
Visual FoxPro makes a great front end to SQL Server in much the same way
that Visual Basic, VB.NET, and C# do. Since data-handling is built in to
VFP, all of this capability is available when working with SQL Server.
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@.msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:eL6SzpKwFHA.1028@.TK2MSFTNGP12.phx.gbl...
> ...VFP is mostly a programming language with a built in DB. ...
|||Hi,
You're asking how to write Visual FoxPro code in SQL Server newsgroups. You
shouldn't expect SQL Server developers to know the details of programming in
Visual FoxPro, or Visual Basic or C# for that matter. You'll get much better
help in a microsoft.public.fox.* newsgroup on this same news server.
You haven't said which version of Visual FoxPro you're working with. You can
access SQL Server data (or Access or Oracle, or whatever) via ODBC with a
Remote View or SQL Pass-through (SQLConnect or SQLStringConnect, and
SQLExec). You can also access SQL Server via OLE DB and ADO using a
CursorAdapter.
As for which is the best software for accessing SQL Server data, that
depends. Often the "best" software is the one that you're most comfortable
with. Visual FoxPro makes a great front end to SQL Server and brings all of
its built-in data handling capabilities to the table.
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@.msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden
"Preacher Man" <nospam> wrote in message
news:%23PGojbIwFHA.3548@.tk2msftngp13.phx.gbl...
> In this post I am going to try to simply a question that I posted earlier.
> Can I use VFP to access a SQL Database? If so what is the command?
> What is the best software for creating applications to work with SQL?
> I am just getting my feet wet with SQL so please take it easy on a rookie.
>
>
|||Cindy,
Lest you forget I have been programming with VFP since it was in Beta for
3.0. I never stated that VFP was not a valid choice for a front end. If you
look at my post I sent him to the very same places you did in your other
post.
Andrew J. Kelly SQL MVP
"Cindy Winegarden" <cindy_winegarden@.msn.com> wrote in message
news:eCb9kwWwFHA.596@.TK2MSFTNGP12.phx.gbl...
> Hi Andrew,
> Visual FoxPro makes a great front end to SQL Server in much the same way
> that Visual Basic, VB.NET, and C# do. Since data-handling is built in to
> VFP, all of this capability is available when working with SQL Server.
> --
> Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
> cindy_winegarden@.msn.com www.cindywinegarden.com
> Blog: http://spaces.msn.com/members/cindywinegarden
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:eL6SzpKwFHA.1028@.TK2MSFTNGP12.phx.gbl...
>
sqlsql

Connecting to SQL from Within VFP

In this post I am going to try to simply a question that I posted earlier.
Can I use VFP to access a SQL Database? If so what is the command?
What is the best software for creating applications to work with SQL?
I am just getting my feet wet with SQL so please take it easy on a rookie.You can't expect someone to explain to you how to do all of this properly in
a news group posting. I suggest you read the help file and maybe some books
on VFP and SQL Server. But you can get started with looking up "remote
servers, connecting to" in the VFP help file. Also take a look at Remote
Views as they may be your easiest way to migrate from VFP to SQL Server.
SQL Server is not like VFP in many ways. VFP is mostly a programming
language with a built in DB. SQL Server does not have a programming
language other than SET based stuff and there are no gui's like forms,
dialogs etc.
Andrew J. Kelly SQL MVP
"Preacher Man" <nospam> wrote in message
news:%23PGojbIwFHA.3548@.tk2msftngp13.phx.gbl...
> In this post I am going to try to simply a question that I posted earlier.
> Can I use VFP to access a SQL Database? If so what is the command?
> What is the best software for creating applications to work with SQL?
> I am just getting my feet wet with SQL so please take it easy on a rookie.
>
>|||Hi Andrew,
Visual FoxPro makes a great front end to SQL Server in much the same way
that Visual Basic, VB.NET, and C# do. Since data-handling is built in to
VFP, all of this capability is available when working with SQL Server.
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@.msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:eL6SzpKwFHA.1028@.TK2MSFTNGP12.phx.gbl...
> ...VFP is mostly a programming language with a built in DB. ...|||Hi,
You're asking how to write Visual FoxPro code in SQL Server newsgroups. You
shouldn't expect SQL Server developers to know the details of programming in
Visual FoxPro, or Visual Basic or C# for that matter. You'll get much better
help in a microsoft.public.fox.* newsgroup on this same news server.
You haven't said which version of Visual FoxPro you're working with. You can
access SQL Server data (or Access or Oracle, or whatever) via ODBC with a
Remote View or SQL Pass-through (SQLConnect or SQLStringConnect, and
SQLExec). You can also access SQL Server via OLE DB and ADO using a
CursorAdapter.
As for which is the best software for accessing SQL Server data, that
depends. Often the "best" software is the one that you're most comfortable
with. Visual FoxPro makes a great front end to SQL Server and brings all of
its built-in data handling capabilities to the table.
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@.msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden
"Preacher Man" <nospam> wrote in message
news:%23PGojbIwFHA.3548@.tk2msftngp13.phx.gbl...
> In this post I am going to try to simply a question that I posted earlier.
> Can I use VFP to access a SQL Database? If so what is the command?
> What is the best software for creating applications to work with SQL?
> I am just getting my feet wet with SQL so please take it easy on a rookie.
>
>|||Cindy,
Lest you forget I have been programming with VFP since it was in Beta for
3.0. I never stated that VFP was not a valid choice for a front end. If you
look at my post I sent him to the very same places you did in your other
post.
Andrew J. Kelly SQL MVP
"Cindy Winegarden" <cindy_winegarden@.msn.com> wrote in message
news:eCb9kwWwFHA.596@.TK2MSFTNGP12.phx.gbl...
> Hi Andrew,
> Visual FoxPro makes a great front end to SQL Server in much the same way
> that Visual Basic, VB.NET, and C# do. Since data-handling is built in to
> VFP, all of this capability is available when working with SQL Server.
> --
> Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
> cindy_winegarden@.msn.com www.cindywinegarden.com
> Blog: http://spaces.msn.com/members/cindywinegarden
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:eL6SzpKwFHA.1028@.TK2MSFTNGP12.phx.gbl...
>

Connecting to a Remote SQL Server From VB6

Hello,
I'm trying to connect to an SQL 2K server. The problem is that when using XP
it seems to work fine, but in Win 2k it simply does not work. I get an
Unable to fine host error (GetHostserver error). I'm using a dsn/dao to set
up the connection. I do a direct connection (Don't connect to the remote
server) it works fine on both OS.
This is what my cnn string looks like
gstrODBC.DSN = "DSN_NAME"
gstrODBC.DataSource = "Database=DATABASE" & vbCr & _
"Description=CSMisc" & vbCr &
"Server=SQL_SERVER\SQL_SERVER\" & vbCr &
Network=DBMSSOCN"
gstrODBC.Login = "ODBC;uid=USER_NAME;pwd=PASSWORD"
Thank you!!!!
Alex"Alex" <xoxo@.xoxo1.com> wrote:
> Hello,
> I'm trying to connect to an SQL 2K server. The problem is that when using
XP
> it seems to work fine, but in Win 2k it simply does not work. I get an
> Unable to fine host error (GetHostserver error). I'm using a dsn/dao to
set
> up the connection. I do a direct connection (Don't connect to the remote
> server) it works fine on both OS.
--
Hi Alex,
Some steps to troubleshoot connectivity problems from your Windows 200
client to SQL Server 2000:
1. Ping the SQL Server machine name. Does it work?
2. Do a net view to the SQL Server machine. Does it work?
3. Click the test ODBC connection button from the DSN dialogue. Does it
work?
4. See if you can connect via Query Analyzer.
Hope this helps,
-Eric Cárdenas
SQL Server support